Skip to main content
subagent CX Codex

database-administrator · voltagent/awesome-codex-subagents — Codex subagent for database operations

database-administrator — a subagent that reviews your database readiness: backups and recovery, replication, access control, performance, and risk. Catches issues that cause data loss or downtime.

MIT ★ 6,505 updated 2026-10-05

Install into Codex · Manually: put the files in place All methods and platforms ↓
.codex/agents/database-administrator.toml
Open on GitHub

What database-administrator does

Call it when a task touches database operations — backup strategy against RPO/RTO, failover topology, permission boundaries, index health, or schema changes under load. The subagent separates confirmed facts from assumptions, then recommends the smallest change that restores safety without overreach.

It maps the operational path (control and data planes), validates one normal scenario and one recovery path, and checks whether changes break rollback. It flags capacity risks: storage growth, connection limits, lock contention, query regressions. It reviews privilege scope, credential handling, and maintenance windows.

You get a precise summary of what was analyzed, the concrete risk with evidence, one preferred action and why, what was validated, and what still needs live-environment proof. No broad engine migration unless you ask.

What it helps with

  • verify backup and recovery meet RPO and RTO requirements
  • assess replication topology and failover correctness
  • audit permission model and remove over-scoped roles
  • identify lock and index contention risks
  • plan schema migration safely under production load

Example prompts for the agent

  • Review our backup strategy. Can we meet a 30-minute RTO with the current setup?
  • What happens to data if the primary replication node fails? How do we fail over safely?
  • Grant the analytics team read-only access to reporting_schema and validate the privilege model.

How to install database-administrator

Manually: put the files in place

.codex/agents/database-administrator.toml

Codex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/

Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean

Questions about database-administrator

How do I install database-administrator in Codex?

Create the file .codex/agents/database-administrator.toml with the subagent configuration. Codex loads the agent definition and parameters from this path.

What does database-administrator do?

It reviews how your database handles failure, recovery, and load: backup and restore posture, replication, permissions, indexes, and maintenance. It finds concrete risks and suggests the smallest safe action.

Should I use this subagent for every database question?

No. Use it for operational reliability tasks — backup validation, failover testing, schema migration under load, permission audits. For running queries, use basic SQL tools.

Source text

database-administrator.toml · MIT
# database-administrator

Use when a task needs operational database administration review for availability, backups, recovery, permissions, or runtime health.

Own database administration work as production-safety and operability engineering, not checklist completion.

Favor the smallest defensible recommendation or change that restores reliability, preserves security boundaries, and keeps rollback options clear.

Working mode:
1. Map the affected operational path (control plane, data plane, and dependency edges).
2. Distinguish confirmed facts from assumptions before proposing mitigation or redesign.
3. Implement or recommend the smallest coherent action that improves safety without widening blast radius.
4. Validate normal-path behavior, one failure path, and one recovery or rollback path.

Focus on:
- backup and restore posture against required RPO/RTO expectations
- replication/high-availability topology and failover correctness
- index strategy, query-plan regression risk, and lock/contention hotspots
- permission model and least-privilege access for operators and applications
- maintenance operations (vacuum/reindex/checkpoint/statistics) and timing risk
- capacity signals: storage growth, connection limits, and resource saturation
- migration and schema-change operational safety under production load

Quality checks:
- verify recovery path is explicit and testable, not assumed from backup existence alone
- confirm high-risk queries or DDL changes include contention and rollback considerations
- check privilege assignments for over-scoped roles and credential handling risks
- ensure operational checks include both normal traffic and incident scenarios
- call out production-only validations that cannot be proven from repository data

Return:
- exact operational boundary analyzed (service, environment, pipeline, or infrastructure path)
- concrete issue/risk and supporting evidence or assumptions
- smallest safe recommendation/change and why this option is preferred
- validation performed and what still requires live environment verification
- residual risk, rollback notes, and prioritized follow-up actions

Do not propose broad engine migration or tenancy redesign unless explicitly requested by the parent agent.

© VoltAgent · MIT · VoltAgent/awesome-codex-subagents

Similar subagents

All subagents for DevOps and infrastructure →

database-administrator by other authors comes first.

database-administrator VoltAgent Community database-administrator is a Claude Code subagent for database operations and performance work. It joins tasks involving high availability, backup planning, and disaster recovery. CX Codex 452installs database-administrator josstei The database-administrator subagent reviews query plans, index choices, and migration risks across relational databases. Use it when investigating slow SQL or planning changes to large tables. CX Codex ★ 489repo stars MS-SQL Database Administrator official github MS-SQL Database Administrator is a GitHub Copilot subagent that inspects schemas and optimizes T-SQL queries. For upgrades, it checks compatibility with SQL Server 2025. CX Codex +1 ★ 41,430repo stars database-admin rohitg00 database-admin guides schema architecture, query optimization, migrations, and backup routines across PostgreSQL, MySQL, and MongoDB. CX Codex ★ 2,858repo stars mongo-dba official github mongo-dba configures GitHub Copilot for MongoDB DBA tasks: manages replica sets, tunes indexes, handles backups, and enforces security practices for MongoDB 7.x+. CX Codex +1 ★ 41,430repo stars postgres-pro VoltAgent Community postgres-pro — a PostgreSQL subagent for query tuning, replication design, backups, and database troubleshooting. Use it when performance or high-availability work needs a structured review. CX Codex 897installs postgresql devops-skills Guides PostgreSQL database administration, streaming replication, backups, and performance tuning. Useful when deploying or optimizing database instances. CX Codex +1 469installs mysql devops-skills Walks your agent through MySQL and MariaDB work: install, InnoDB tuning, backups, source-replica replication. Useful when the agent touches a live database. CX Codex +1 389installs

From the same set176

The whole set →
docker-expert The docker-expert subagent reviews Dockerfiles, image builds, and container runtime issues. Use it for multi-stage build fixes and startup debugging. CX Codex ★ 6,505repo stars devops-incident-responder devops-incident-responder — a subagent for rapid analysis of CI failures, deployment issues, infrastructure problems, and service outages. CX Codex ★ 6,505repo stars devops-engineer devops-engineer handles CI/CD pipelines, release automation, and environment setups with a focus on production safety and safe rollbacks. CX Codex ★ 6,505repo stars deployment-engineer deployment-engineer reviews deployment changes, release strategy, and rollout or rollback risks. Use it when a release plan needs operational checks before the change goes live. CX Codex ★ 6,505repo stars cloud-architect Reviews cloud architecture across compute, storage, and networking. Helps catch single points of failure and plan safe rollbacks. CX Codex ★ 6,505repo stars azure-infra-engineer The azure-infra-engineer subagent reviews and changes Azure infrastructure with security, reliability, and rollback in mind. Delegate work on resources, networking, identity, or automation. CX Codex ★ 6,505repo stars vue-expert vue-expert — a subagent for fixing Vue component issues, reactivity, and state problems. Maps execution boundaries and proposes minimal safe fixes that preserve project architecture. CX Codex ★ 6,505repo stars typescript-pro typescript-pro — a Codex subagent that fixes TypeScript compiler errors, interfaces, and types using minimal safe code edits. CX Codex ★ 6,505repo stars

Project sponsors

Companies that keep this analytics open