Engineering Advanced DatabaseOperationsReliability

Database Administrator

Database administration: backups, replication, query tuning, maintenance windows, capacity planning, access control, and incident response.

A production database administration skill that prioritizes restore confidence, disciplined change management, and evidence-based performance tuning. It is designed for teams running business-critical databases that need better backup, access, replication, and runbook hygiene.

Added Apr 12, 2026

$npx skills add johnefemer/skillfish --skill database-administrator

Capabilities Get Started Models & Context Works Great With

What This Skill Can Do

Concrete capabilities you get when you install this skill.

Design backup, restore, replication, and maintenance strategies around recovery objectives

Diagnose slow queries, lock contention, replication lag, and storage pressure from evidence

Manage connection pools, indexes, maintenance, and capacity before emergencies happen

Enforce least-privilege access, credential rotation, and audited admin workflows

Plan safe schema or topology changes for live production databases

Write failover, restore, and high-risk operational runbooks

Get Started

How to install and use this skill in your preferred environment.

Skills are designed for AI coding agents (Claude Code, Cursor, Windsurf) and IDE-based workflows where the agent can read files, run scripts, and act on your codebase.

Models & Context

Which AI models and context windows work best with this skill.

Recommended Models

Claude Sonnet or GPT-4o recommended. Include query plans, wait events, and topology details for best results.

Context Window

SKILL.md is concise (~3KB). Fits in 32K context; full operational diagnosis with plans and metrics benefits from 64K+.

Pro tips for best results

1

Be specific

Include numbers — users, budget, RPS — so the skill can size the architecture.

2

Share constraints

Compliance needs, team size, and existing stack all improve the output.

3

Iterate

Start with a high-level design, then ask follow-ups for IaC, cost analysis, or security review.

4

Combine skills

Pair with companion skills below for end-to-end coverage.

Works Great With

These skills complement Database Administrator for end-to-end coverage. Install them together for better results.

Postgres Pro

PostgreSQL mastery: advanced indexing (GIN, GiST, BRIN), JSONB, full-text search, partitioning, replication, pgvector for embeddings, and performance tuning.

PostgreSQLpgvector

Database Designer

Schema analysis, ERD generation, index optimization, and migrations.

DatabaseSchema

Performance Profiler

Node/Python/Go profiling, bundle analysis, and load testing.

PerformanceProfiling

Senior Backend

REST APIs, database optimization, authentication, and microservices.

BackendAPIs

$ skillfish add johnefemer/skillfish --all # install all skills at once

Ready to try Database Administrator?

Install the skill and start getting expert-level guidance in your workflow — any agent, any IDE.