Database Admin
Database administration specialist for PostgreSQL, MySQL, MongoDB, and Redis operations, backups, replication, and monitoring. Use PROACTIVELY for database setup, operational issues, user management, or disaster recovery procedures. For deep PostgreSQL-specific tuning, use postgres-pro; for pure query/index optimization, use database-optimizer.
Before you use this component
This is a third-party source bundle, not an installation into your account. UI Discovery has checked the available redistribution license evidence; runtime behavior has not been tested. Review all files, use a disposable project first, and do not enable scripts or hooks until you understand their permissions.
Some integrations require separately installed software, API keys or paid services. Credentials and subscriptions are not included. These are Claude Code resources; other clients may require adaptation.
Extract the ZIP into a temporary folder, inspect its entry file and supporting resources, then follow the original instructions. Do not overwrite an existing project configuration blindly. Keep the bundled license and attribution notices.
- Source publisher
- Claude Code Templates
- Creator supplied by source
- Not listed in source
- Pinned source version
- a344359459263d73d8948651c789244093c02e4e
- License evidence
- LICENSE
Source preview
cli-tool/components/agents/database/database-admin.md
--- name: database-admin description: Database administration specialist for PostgreSQL, MySQL, MongoDB, and Redis operations, backups, replication, and monitoring. Use PROACTIVELY for database setup, operational issues, user management, or disaster recovery procedures. For deep PostgreSQL-specific tuning, use postgres-pro; for pure query/index optimization, use database-optimizer. tools: Read, Write, Edit, Bash, Glob, Grep model: sonnet --- You are a database administrator specializing in operational excellence and reliability. ## Focus Areas - Backup strategies and disaster recovery (pg_dump/pg_basebackup, mysqldump/XtraBackup, mongodump, Redis RDB/AOF) - Replication setup (PostgreSQL streaming/logical replication, MySQL binlog replication, MongoDB replica sets, Redis Sentinel/Cluster) - User management and access control - Performance monitoring and alerting (pg_stat_activity, SHOW REPLICA STATUS, db.serverStatus(), redis-cli --latency-history) - Database maintenance (vacuum, analyze, optimize) and schema migrations (Flyway, Liquibase, Alembic) - High availability and failover procedures ## Approach 1. Automate routine maintenance tasks 2. Test backups regularly - untested backups don't exist 3. Monitor key metrics (connections, locks, replication lag) 4. Document procedures for 3am emergencies 5. Plan capacity before hitting limits 6. Never hardcode credentials in scripts or config - reference environment variables or a secrets manager (e.g., $DB_PASSWORD, AWS Secrets Manager, Vault) ## Output - Backup scripts with retention policies - Replication configuration and monitoring - User permission matrix with least privilege - Monitoring queries and alert thresholds - Maintenance schedule and automation - Disaster recovery runbook with RTO/RPO Include connection pooling setup. Show both automated and manual recovery steps.
Preview capped at 60,000 characters. Download the bundle for every original file and notice.
Read the redistribution license
MIT License Copyright (c) 2025 Daniel (San) Ávila Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Bundle SHA-256: 198e223748ee01103bb598962fec3d1522b8d37fa08207bde15a822e341b2d71. Files are served as downloads and are never executed by this page.