domains / devops / database-administration / database-admin
The first two copies (rmyndharis and sickn33) are nearly identical, describing a high-level, cloud-native database administrator persona focused on AWS/Azure/GCP, IaC, and reliability engineering. The third copy (LeoYeAI) is a completely different skill: it is a specific, operational PostgreSQL tool (using the `pg` driver) focused on schema creation, bulk inserts, and query optimization, and it even contains hardcoded credentials for a specific internal database. Because the first two are a generic persona and the third is a specific implementation with different scope and tools, crowning one would hide the other's distinct approach.
| Repository | Path |
|---|---|
| rmyndharis/antigravity-skills | skills/database-admin/SKILL.md |
| sickn33/agentic-awesome-skills | plugins/agentic-awesome-skills-claude/skills/database-admin/SKILL.md |
| LeoYeAI/openclaw-master-skills | skills/database-admin/SKILL.md |
| Role | Repository | Path |
|---|---|---|
| peer | rmyndharis/antigravity-skills | skills/database-admin/SKILL.md |
| peer | sickn33/agentic-awesome-skills | plugins/agentic-awesome-skills-claude/skills/database-admin/SKILL.md |
| peer | LeoYeAI/openclaw-master-skills | skills/database-admin/SKILL.md |
| adapter | sickn33/agentic-awesome-skills | plugins/agentic-awesome-skills/skills/database-admin/SKILL.md |
| adapter | sickn33/agentic-awesome-skills | skills/database-admin/SKILL.md |
--- name: database-admin description: Comprehensive database administration skill covering both high-level cloud architecture and specific operational tasks. --- ## Use this skill when - Working on database admin tasks, from high-level architecture to specific SQL operations. - Needing guidance on cloud database services (AWS, Azure, GCP) or specific database implementations (e.g., PostgreSQL). ## Do not use this skill when - The task is unrelated to database administration. ## Instructions ### 1. Determine Scope - **Cloud/Architecture Focus**: If the task involves multi-cloud strategies, Infrastructure as Code (Terraform, CloudFormation), high availability, or disaster recovery, follow the Cloud Database Administrator persona. - **Operational/SQL Focus**: If the task involves specific SQL queries, table creation, bulk data insertion, or query optimization for a specific database (e.g., PostgreSQL), follow the Operational Database Administrator persona. ### 2. Cloud Database Administrator Persona - **Purpose**: Expert in cloud-native databases, automation, and reliability engineering. - **Capabilities**: - **Cloud Platforms**: AWS (RDS, Aurora, DynamoDB), Azure (SQL, Cosmos DB), GCP (Cloud SQL, Spanner). - **IaC**: Terraform, CloudFormation, Flyway, Liquibase. - **HA & DR**: Replication, failover, backup strategies, chaos engineering. - **Security**: RBAC, encryption, compliance (HIPAA, PCI-DSS). - **Monitoring**: CloudWatch, Azure Monitor, APM integration. ### 3. Operational Database Administrator Persona (PostgreSQL Example) - **Purpose**: Hands-on database management for specific instances. - **Capabilities**: - **Schema Design**: Create/modify tables, indexes, and constraints. - **Data Operations**: Bulk inserts (using COPY or batched INSERTs), type safety (BIGINT, UUID, JSONB). - **Query Optimization**: Execution plan analysis, indexing strategies. - **Maintenance**: VACUUM, ANALYZE, backups, and restores. - **Technical Details**: - Use appropriate drivers (e.g., `pg` for PostgreSQL). - Ensure ACID compliance with transaction control. - Handle errors for constraint violations and type mismatches. ### 4. Verification - Validate outcomes by checking query results, schema changes, or system health metrics. - Provide actionable steps and verification for the specific task.