{"id":"4640e37b-1230-455f-9c3d-a30ece424b8b","shortId":"dTWv36","kind":"skill","title":"database-admin","tagline":"Expert database administrator specializing in modern cloud databases, automation, and reliability engineering.","description":"## Use this skill when\n\n- Working on database admin tasks or workflows\n- Needing guidance, best practices, or checklists for database admin\n\n## Do not use this skill when\n\n- The task is unrelated to database admin\n- You need a different domain or tool outside this scope\n\n## Instructions\n\n- Clarify goals, constraints, and required inputs.\n- Apply relevant best practices and validate outcomes.\n- Provide actionable steps and verification.\n- If detailed examples are required, open `resources/implementation-playbook.md`.\n\nYou are a database administrator specializing in modern cloud database operations, automation, and reliability engineering.\n\n## Purpose\nExpert database administrator with comprehensive knowledge of cloud-native databases, automation, and reliability engineering. Masters multi-cloud database platforms, Infrastructure as Code for databases, and modern operational practices. Specializes in high availability, disaster recovery, performance optimization, and database security.\n\n## Capabilities\n\n### Cloud Database Platforms\n- **AWS databases**: RDS (PostgreSQL, MySQL, Oracle, SQL Server), Aurora, DynamoDB, DocumentDB, ElastiCache\n- **Azure databases**: Azure SQL Database, PostgreSQL, MySQL, Cosmos DB, Redis Cache\n- **Google Cloud databases**: Cloud SQL, Cloud Spanner, Firestore, BigQuery, Cloud Memorystore\n- **Multi-cloud strategies**: Cross-cloud replication, disaster recovery, data synchronization\n- **Database migration**: AWS DMS, Azure Database Migration, GCP Database Migration Service\n\n### Modern Database Technologies\n- **Relational databases**: PostgreSQL, MySQL, SQL Server, Oracle, MariaDB optimization\n- **NoSQL databases**: MongoDB, Cassandra, DynamoDB, CosmosDB, Redis operations\n- **NewSQL databases**: CockroachDB, TiDB, Google Spanner, distributed SQL systems\n- **Time-series databases**: InfluxDB, TimescaleDB, Amazon Timestream operational management\n- **Graph databases**: Neo4j, Amazon Neptune, Azure Cosmos DB Gremlin API\n- **Search databases**: Elasticsearch, OpenSearch, Amazon CloudSearch administration\n\n### Infrastructure as Code for Databases\n- **Database provisioning**: Terraform, CloudFormation, ARM templates for database infrastructure\n- **Schema management**: Flyway, Liquibase, automated schema migrations and versioning\n- **Configuration management**: Ansible, Chef, Puppet for database configuration automation\n- **GitOps for databases**: Database configuration and schema changes through Git workflows\n- **Policy as Code**: Database security policies, compliance rules, operational procedures\n\n### High Availability & Disaster Recovery\n- **Replication strategies**: Master-slave, master-master, multi-region replication\n- **Failover automation**: Automatic failover, manual failover procedures, split-brain prevention\n- **Backup strategies**: Full, incremental, differential backups, point-in-time recovery\n- **Cross-region DR**: Multi-region disaster recovery, RPO/RTO optimization\n- **Chaos engineering**: Database resilience testing, failure scenario planning\n\n### Database Security & Compliance\n- **Access control**: RBAC, fine-grained permissions, service account management\n- **Encryption**: At-rest encryption, in-transit encryption, key management\n- **Auditing**: Database activity monitoring, compliance logging, audit trails\n- **Compliance frameworks**: HIPAA, PCI-DSS, SOX, GDPR database compliance\n- **Vulnerability management**: Database security scanning, patch management\n- **Secret management**: Database credentials, connection strings, key rotation\n\n### Performance Monitoring & Optimization\n- **Cloud monitoring**: CloudWatch, Azure Monitor, GCP Cloud Monitoring for databases\n- **APM integration**: Database performance in application monitoring (DataDog, New Relic)\n- **Query analysis**: Slow query logs, execution plans, query optimization\n- **Resource monitoring**: CPU, memory, I/O, connection pool utilization\n- **Custom metrics**: Database-specific KPIs, SLA monitoring, performance baselines\n- **Alerting strategies**: Proactive alerting, escalation procedures, on-call rotations\n\n### Database Automation & Maintenance\n- **Automated maintenance**: Vacuum, analyze, index maintenance, statistics updates\n- **Scheduled tasks**: Backup automation, log rotation, cleanup procedures\n- **Health checks**: Database connectivity, replication lag, resource utilization\n- **Auto-scaling**: Read replicas, connection pooling, resource scaling automation\n- **Patch management**: Automated patching, maintenance windows, rollback procedures\n\n### Container & Kubernetes Databases\n- **Database operators**: PostgreSQL Operator, MySQL Operator, MongoDB Operator\n- **StatefulSets**: Kubernetes database deployments, persistent volumes, storage classes\n- **Database as a Service**: Helm charts, database provisioning, service management\n- **Backup automation**: Kubernetes-native backup solutions, cross-cluster backups\n- **Monitoring integration**: Prometheus metrics, Grafana dashboards, alerting\n\n### Data Pipeline & ETL Operations\n- **Data integration**: ETL/ELT pipelines, data synchronization, real-time streaming\n- **Data warehouse operations**: BigQuery, Redshift, Snowflake operational management\n- **Data lake administration**: S3, ADLS, GCS data lake operations and governance\n- **Streaming data**: Kafka, Kinesis, Event Hubs for real-time data processing\n- **Data governance**: Data lineage, data quality, metadata management\n\n### Connection Management & Pooling\n- **Connection pooling**: PgBouncer, MySQL Router, connection pool optimization\n- **Load balancing**: Database load balancers, read/write splitting, query routing\n- **Connection security**: SSL/TLS configuration, certificate management\n- **Resource optimization**: Connection limits, timeout configuration, pool sizing\n- **Monitoring**: Connection metrics, pool utilization, performance optimization\n\n### Database Development Support\n- **CI/CD integration**: Database changes in deployment pipelines, automated testing\n- **Development environments**: Database provisioning, data seeding, environment management\n- **Testing strategies**: Database testing, test data management, performance testing\n- **Code review**: Database schema changes, query optimization, security review\n- **Documentation**: Database architecture, procedures, troubleshooting guides\n\n### Cost Optimization & FinOps\n- **Resource optimization**: Right-sizing database instances, storage optimization\n- **Reserved capacity**: Reserved instances, committed use discounts, cost planning\n- **Cost monitoring**: Database cost allocation, usage tracking, optimization recommendations\n- **Storage tiering**: Automated storage tiering, archival strategies\n- **Multi-cloud cost**: Cross-cloud cost comparison, workload placement optimization\n\n## Behavioral Traits\n- Automates routine maintenance tasks to reduce human error and improve consistency\n- Tests backups regularly with recovery procedures because untested backups don't exist\n- Monitors key database metrics proactively (connections, locks, replication lag, performance)\n- Documents all procedures thoroughly for emergency situations and knowledge transfer\n- Plans capacity proactively before hitting resource limits or performance degradation\n- Implements Infrastructure as Code for all database operations and configurations\n- Prioritizes security and compliance in all database operations\n- Values high availability and disaster recovery as fundamental requirements\n- Emphasizes automation and observability for operational excellence\n- Considers cost optimization while maintaining performance and reliability\n\n## Knowledge Base\n- Cloud database services across AWS, Azure, and GCP\n- Modern database technologies and operational best practices\n- Infrastructure as Code tools and database automation\n- High availability, disaster recovery, and business continuity planning\n- Database security, compliance, and governance frameworks\n- Performance monitoring, optimization, and troubleshooting\n- Container orchestration and Kubernetes database operations\n- Cost optimization and FinOps for database workloads\n\n## Response Approach\n1. **Assess database requirements** for performance, availability, and compliance\n2. **Design database architecture** with appropriate redundancy and scaling\n3. **Implement automation** for routine operations and maintenance tasks\n4. **Configure monitoring and alerting** for proactive issue detection\n5. **Set up backup and recovery** procedures with regular testing\n6. **Implement security controls** with proper access management and encryption\n7. **Plan for disaster recovery** with defined RTO and RPO objectives\n8. **Optimize for cost** while maintaining performance and availability requirements\n9. **Document all procedures** with clear operational runbooks and emergency procedures\n\n## Example Interactions\n- \"Design multi-region PostgreSQL setup with automated failover and disaster recovery\"\n- \"Implement comprehensive database monitoring with proactive alerting and performance optimization\"\n- \"Create automated backup and recovery system with point-in-time recovery capabilities\"\n- \"Set up database CI/CD pipeline with automated schema migrations and testing\"\n- \"Design database security architecture meeting HIPAA compliance requirements\"\n- \"Optimize database costs while maintaining performance SLAs across multiple cloud providers\"\n- \"Implement database operations automation using Infrastructure as Code and GitOps\"\n- \"Create database disaster recovery plan with automated failover and business continuity procedures\"\n\n## Limitations\n- Use this skill only when the task clearly matches the scope described above.\n- Do not treat the output as a substitute for environment-specific validation, testing, or expert review.\n- Stop and ask for clarification if required inputs, permissions, safety boundaries, or success criteria are missing.","tags":["database","admin","antigravity","awesome","skills","sickn33","agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows"],"capabilities":["skill","source-sickn33","skill-database-admin","topic-agent-skills","topic-agentic-skills","topic-ai-agent-skills","topic-ai-agents","topic-ai-coding","topic-ai-workflows","topic-antigravity","topic-antigravity-skills","topic-claude-code","topic-claude-code-skills","topic-codex-cli","topic-codex-skills"],"categories":["antigravity-awesome-skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/sickn33/antigravity-awesome-skills/database-admin","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add sickn33/antigravity-awesome-skills","source_repo":"https://github.com/sickn33/antigravity-awesome-skills","install_from":"skills.sh"}},"qualityScore":"0.700","qualityRationale":"deterministic score 0.70 from registry signals: · indexed on github topic:agent-skills · 34831 github stars · SKILL.md body (9,859 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-04-24T06:51:00.770Z","embedding":null,"createdAt":"2026-04-18T21:35:37.011Z","updatedAt":"2026-04-24T06:51:00.770Z","lastSeenAt":"2026-04-24T06:51:00.770Z","tsv":"'1':920 '2':929 '3':938 '4':947 '5':956 '6':966 '7':976 '8':987 '9':997 'access':372,972 'account':380 'across':867,1071 'action':74 'activ':395 'adl':604 'admin':3,23,35,48 'administr':6,89,103,258,602 'alert':476,479,577,951,1028 'alloc':741 'amazon':238,245,256 'analysi':450 'analyz':492 'ansibl':284 'api':251 'apm':439 'appli':66 'applic':444 'approach':919 'appropri':934 'architectur':712,932,1059 'archiv':751 'arm':268 'ask':1130 'assess':921 'at-rest':383 'audit':393,399 'aurora':154 'auto':514 'auto-sc':513 'autom':12,96,112,277,290,329,487,489,500,522,525,561,682,748,767,848,885,940,1017,1033,1051,1078,1091 'automat':330 'avail':134,313,840,887,926,995 'aw':146,194,868 'azur':158,160,196,247,432,869 'backup':339,344,499,560,565,570,779,786,959,1034 'balanc':643,646 'base':863 'baselin':475 'behavior':765 'best':29,68,877 'bigqueri':177,595 'boundari':1138 'brain':337 'busi':891,1094 'cach':168 'call':484 'capabl':142,1044 'capac':729,811 'cassandra':218 'certif':655 'chang':298,678,705 'chao':361 'chart':555 'check':506 'checklist':32 'chef':285 'ci/cd':675,1048 'clarif':1132 'clarifi':60 'class':549 'cleanup':503 'clear':1002,1105 'cloud':10,93,109,119,143,170,172,174,178,182,186,429,435,755,759,864,1073 'cloud-nat':108 'cloudform':267 'cloudsearch':257 'cloudwatch':431 'cluster':569 'cockroachdb':225 'code':124,261,304,701,823,881,1082 'commit':732 'comparison':761 'complianc':308,371,397,401,410,833,896,928,1062 'comprehens':105,1023 'configur':282,289,295,654,662,829,948 'connect':422,463,508,518,631,634,639,651,659,666,795 'consid':854 'consist':777 'constraint':62 'contain':531,905 'continu':892,1095 'control':373,969 'cosmos':165,248 'cosmosdb':220 'cost':716,735,737,740,756,760,855,911,990,1066 'cpu':460 'creat':1032,1085 'credenti':421 'criteria':1141 'cross':185,351,568,758 'cross-cloud':184,757 'cross-clust':567 'cross-region':350 'custom':466 'dashboard':576 'data':190,578,582,586,592,600,606,612,621,623,625,627,688,697 'databas':2,5,11,22,34,47,88,94,102,111,120,126,140,144,147,159,162,171,192,197,200,204,207,216,224,235,243,253,263,264,271,288,293,294,305,363,369,394,409,413,420,438,441,469,486,507,533,534,544,550,556,644,672,677,686,694,703,711,724,739,792,826,836,865,873,884,894,909,916,922,931,1024,1047,1057,1065,1076,1086 'database-admin':1 'database-specif':468 'datadog':446 'db':166,249 'defin':982 'degrad':819 'deploy':545,680 'describ':1109 'design':930,1010,1056 'detail':79 'detect':955 'develop':673,684 'differ':52 'differenti':343 'disast':135,188,314,357,842,888,979,1020,1087 'discount':734 'distribut':229 'dms':195 'document':710,800,998 'documentdb':156 'domain':53 'dr':353 'dss':406 'dynamodb':155,219 'elasticach':157 'elasticsearch':254 'emerg':805,1006 'emphas':847 'encrypt':382,386,390,975 'engin':15,99,115,362 'environ':685,690,1121 'environment-specif':1120 'error':774 'escal':480 'etl':580 'etl/elt':584 'event':615 'exampl':80,1008 'excel':853 'execut':454 'exist':789 'expert':4,101,1126 'failov':328,331,333,1018,1092 'failur':366 'fine':376 'fine-grain':375 'finop':718,914 'firestor':176 'flyway':275 'framework':402,899 'full':341 'fundament':845 'gcp':199,434,871 'gcs':605 'gdpr':408 'git':300 'gitop':291,1084 'goal':61 'googl':169,227 'govern':610,624,898 'grafana':575 'grain':377 'graph':242 'gremlin':250 'guid':715 'guidanc':28 'health':505 'helm':554 'high':133,312,839,886 'hipaa':403,1061 'hit':814 'hub':616 'human':773 'i/o':462 'implement':820,939,967,1022,1075 'improv':776 'in-transit':387 'increment':342 'index':493 'influxdb':236 'infrastructur':122,259,272,821,879,1080 'input':65,1135 'instanc':725,731 'instruct':59 'integr':440,572,583,676 'interact':1009 'issu':954 'kafka':613 'key':391,424,791 'kinesi':614 'knowledg':106,808,862 'kpis':471 'kubernet':532,543,563,908 'kubernetes-n':562 'lag':510,798 'lake':601,607 'limit':660,816,1097 'lineag':626 'liquibas':276 'load':642,645 'lock':796 'log':398,453,501 'maintain':858,992,1068 'mainten':488,490,494,527,769,945 'manag':241,274,283,381,392,412,417,419,524,559,599,630,632,656,691,698,973 'manual':332 'mariadb':213 'master':116,319,322,323 'master-mast':321 'master-slav':318 'match':1106 'meet':1060 'memori':461 'memorystor':179 'metadata':629 'metric':467,574,667,793 'migrat':193,198,201,279,1053 'miss':1143 'modern':9,92,128,203,872 'mongodb':217,540 'monitor':396,427,430,433,436,445,459,473,571,665,738,790,901,949,1025 'multi':118,181,325,355,754,1012 'multi-cloud':117,180,753 'multi-region':324,354,1011 'multipl':1072 'mysql':150,164,209,538,637 'nativ':110,564 'need':27,50 'neo4j':244 'neptun':246 'new':447 'newsql':223 'nosql':215 'object':986 'observ':850 'on-cal':482 'open':83 'opensearch':255 'oper':95,129,222,240,310,535,537,539,541,581,594,598,608,827,837,852,876,910,943,1003,1077 'optim':138,214,360,428,457,641,658,671,707,717,720,727,744,764,856,902,912,988,1031,1064 'oracl':151,212 'orchestr':906 'outcom':72 'output':1115 'outsid':56 'patch':416,523,526 'pci':405 'pci-dss':404 'perform':137,426,442,474,670,699,799,818,859,900,925,993,1030,1069 'permiss':378,1136 'persist':546 'pgbouncer':636 'pipelin':579,585,681,1049 'placement':763 'plan':368,455,736,810,893,977,1089 'platform':121,145 'point':346,1040 'point-in-tim':345,1039 'polici':302,307 'pool':464,519,633,635,640,663,668 'postgresql':149,163,208,536,1014 'practic':30,69,130,878 'prevent':338 'priorit':830 'proactiv':478,794,812,953,1027 'procedur':311,334,481,504,530,713,783,802,962,1000,1007,1096 'process':622 'prometheus':573 'proper':971 'provid':73,1074 'provis':265,557,687 'puppet':286 'purpos':100 'qualiti':628 'queri':449,452,456,649,706 'rbac':374 'rds':148 'read':516 'read/write':647 'real':589,619 'real-tim':588,618 'recommend':745 'recoveri':136,189,315,349,358,782,843,889,961,980,1021,1036,1043,1088 'redi':167,221 'redshift':596 'reduc':772 'redund':935 'region':326,352,356,1013 'regular':780,964 'relat':206 'relev':67 'reliabl':14,98,114,861 'relic':448 'replic':187,316,327,509,797 'replica':517 'requir':64,82,846,923,996,1063,1134 'reserv':728,730 'resili':364 'resourc':458,511,520,657,719,815 'resources/implementation-playbook.md':84 'respons':918 'rest':385 'review':702,709,1127 'right':722 'right-siz':721 'rollback':529 'rotat':425,485,502 'rout':650 'router':638 'routin':768,942 'rpo':985 'rpo/rto':359 'rto':983 'rule':309 'runbook':1004 's3':603 'safeti':1137 'scale':515,521,937 'scan':415 'scenario':367 'schedul':497 'schema':273,278,297,704,1052 'scope':58,1108 'search':252 'secret':418 'secur':141,306,370,414,652,708,831,895,968,1058 'seed':689 'seri':234 'server':153,211 'servic':202,379,553,558,866 'set':957,1045 'setup':1015 'situat':806 'size':664,723 'skill':18,40,1100 'skill-database-admin' 'sla':472 'slas':1070 'slave':320 'slow':451 'snowflak':597 'solut':566 'source-sickn33' 'sox':407 'spanner':175,228 'special':7,90,131 'specif':470,1122 'split':336,648 'split-brain':335 'sql':152,161,173,210,230 'ssl/tls':653 'statefulset':542 'statist':495 'step':75 'stop':1128 'storag':548,726,746,749 'strategi':183,317,340,477,693,752 'stream':591,611 'string':423 'substitut':1118 'success':1140 'support':674 'synchron':191,587 'system':231,1037 'task':24,43,498,770,946,1104 'technolog':205,874 'templat':269 'terraform':266 'test':365,683,692,695,696,700,778,965,1055,1124 'thorough':803 'tidb':226 'tier':747,750 'time':233,348,590,620,1042 'time-seri':232 'timeout':661 'timescaledb':237 'timestream':239 'tool':55,882 'topic-agent-skills' 'topic-agentic-skills' 'topic-ai-agent-skills' 'topic-ai-agents' 'topic-ai-coding' 'topic-ai-workflows' 'topic-antigravity' 'topic-antigravity-skills' 'topic-claude-code' 'topic-claude-code-skills' 'topic-codex-cli' 'topic-codex-skills' 'track':743 'trail':400 'trait':766 'transfer':809 'transit':389 'treat':1113 'troubleshoot':714,904 'unrel':45 'untest':785 'updat':496 'usag':742 'use':16,38,733,1079,1098 'util':465,512,669 'vacuum':491 'valid':71,1123 'valu':838 'verif':77 'version':281 'volum':547 'vulner':411 'warehous':593 'window':528 'work':20 'workflow':26,301 'workload':762,917","prices":[{"id":"468d3d0d-4988-4dbf-b692-9eee8da02ea0","listingId":"4640e37b-1230-455f-9c3d-a30ece424b8b","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"sickn33","category":"antigravity-awesome-skills","install_from":"skills.sh"},"createdAt":"2026-04-18T21:35:37.011Z"}],"sources":[{"listingId":"4640e37b-1230-455f-9c3d-a30ece424b8b","source":"github","sourceId":"sickn33/antigravity-awesome-skills/database-admin","sourceUrl":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database-admin","isPrimary":false,"firstSeenAt":"2026-04-18T21:35:37.011Z","lastSeenAt":"2026-04-24T06:51:00.770Z"}],"details":{"listingId":"4640e37b-1230-455f-9c3d-a30ece424b8b","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"sickn33","slug":"database-admin","github":{"repo":"sickn33/antigravity-awesome-skills","stars":34831,"topics":["agent-skills","agentic-skills","ai-agent-skills","ai-agents","ai-coding","ai-workflows","antigravity","antigravity-skills","claude-code","claude-code-skills","codex-cli","codex-skills","cursor","cursor-skills","developer-tools","gemini-cli","gemini-skills","kiro","mcp","skill-library"],"license":"mit","html_url":"https://github.com/sickn33/antigravity-awesome-skills","pushed_at":"2026-04-24T06:41:17Z","description":"Installable GitHub library of 1,400+ agentic skills for Claude Code, Cursor, Codex CLI, Gemini CLI, Antigravity, and more. Includes installer CLI, bundles, workflows, and official/community skill collections.","skill_md_sha":"51ca4c24eb0ad84076c686bcf3fa436ab11e0934","skill_md_path":"skills/database-admin/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/sickn33/antigravity-awesome-skills/tree/main/skills/database-admin"},"layout":"multi","source":"github","category":"antigravity-awesome-skills","frontmatter":{"name":"database-admin","description":"Expert database administrator specializing in modern cloud databases, automation, and reliability engineering."},"skills_sh_url":"https://skills.sh/sickn33/antigravity-awesome-skills/database-admin"},"updatedAt":"2026-04-24T06:51:00.770Z"}}