Skip to main content
subagent CX Codex

database_optimizer — Claude Code subagent for database tuning

database_optimizer — a subagent for Claude Code, Codex, and Cursor reviews database performance evidence and proposes optimizations. It ranks bottlenecks and outlines how to measure proposed changes.

no license ★ 776 updated 2026-11-12

Install into Claude Code · Manually: put the files in place All methods and platforms ↓
.claude/agents/database_optimizer.md
Open on GitHub

What database_optimizer does

The subagent produces a database optimization report with ranked bottlenecks and suggestions for queries, indexes, schemas, configuration, and access patterns. Each proposed change comes with workload trade-offs, migration and rollback considerations, and capacity risks.

The input can include an optimization goal and database materials such as schemas, queries, execution plans, indexes, metrics, or health-check results. Those materials are optional. The agent must not fabricate execution plans, row counts, latency figures, or production topology. Database-specific assumptions and potentially destructive operations are marked in the report.

A benchmark plan covers before-and-after metrics and acceptance thresholds. Any suggested index or configuration change must explain its effect on the workload.

What it helps with

  • rank bottlenecks across database queries and schemas
  • weigh tuning options against workload trade-offs
  • plan a migration with rollback considerations
  • define benchmark metrics and acceptance thresholds

Example prompts for the agent

  • Review these database schemas and queries, then rank the performance bottlenecks.
  • Draft optimization recommendations with workload trade-offs and rollback considerations.
  • Create a benchmark plan for measuring the proposed database changes.

How to install database_optimizer

Manually: put the files in place

.claude/agents/database_optimizer.md

For all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention

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

Questions about database_optimizer

How do I install database_optimizer in Claude Code?

Place the subagent file at .claude/agents/database_optimizer.md.

What does database_optimizer do?

It turns database evidence into a report with ranked bottlenecks, optimization suggestions, migration and rollback considerations, and a benchmark plan.

What information can database_optimizer use?

It can work from an optimization goal and optional schemas, queries, execution plans, indexes, metrics, or health-check results.

Similar subagents

All subagents for Data and databases →
database-optimizer VoltAgent database-optimizer — a subagent that analyzes database performance. Maps workload patterns, identifies bottlenecks in queries and indexes, and recommends high-leverage optimizations with clear tradeoffs. CX Codex ★ 6,505repo stars database-cloud-optimization-database-optimizer Seth Hobson database-cloud-optimization-database-optimizer — a subagent that digs into slow queries, indexes and schema design. Useful when the database drags or needs to scale. CX Codex ★ 42,780repo stars performance-optimizer oakoss performance-optimizer provides structured workflows for profiling, caching, and full-stack performance tuning. Helps eliminate slow database queries, optimize bundles, and reduce API latency. CX Codex +1 124installs postgresql-database-engineering manutej postgresql-database-engineering guides database design, index selection, and query optimization in PostgreSQL. Useful when tuning slow queries, setting up table partitioning, or configuring replication. CX Codex +1 1,800installs database-query-optimization aj-geddes database-query-optimization — a skill that walks your agent through slow SQL: execution plans, indexes, and where the time actually goes. Useful when the database drags. CX Codex +1 594installs database-performance-debugging aj-geddes database-performance-debugging — a skill that walks your agent through finding slow SQL queries and reading their execution plans. Useful when the app drags or the database burns CPU. CX Codex +1 500installs

From the same set24

The whole set →
security_auditor security_auditor — a subagent for Claude Code runs defensive application security reviews. Inspects source code, configurations, and dependency scanner logs to report exploitable flaws. CX Codex ★ 776repo stars search_specialist The search_specialist Claude Code subagent turns an information need into focused queries and assesses retrieved sources. It returns a compact evidence set in JSON for downstream work. CX Codex ★ 776repo stars data_engineer The data_engineer Claude Code subagent designs batch and streaming data pipelines from stated requirements. It returns a Markdown specification covering data flow, quality checks, and operations. CX Codex ★ 776repo stars product_manager product_manager is a Claude Code subagent that turns a product question and available evidence into a clear decision. It helps compare options, set priorities, and define how to measure results. CX Codex ★ 776repo stars api_designer The api_designer Claude Code subagent turns product or service requirements into REST or GraphQL API contracts. It runs on API specification tasks. CX Codex ★ 776repo stars fullstack_implementation_engineer The fullstack_implementation_engineer Claude Code subagent turns an approved feature spec into a coordinated implementation plan. It covers data, APIs, business logic, UI, migrations, and tests. CX Codex ★ 776repo stars devops_incident_responder The devops_incident_responder Claude Code subagent turns production incident details into a diagnosis and recovery plan. It can use logs, metrics, and deployment history when provided. CX Codex ★ 776repo stars backend_architecture_expert The backend_architecture_expert Claude Code subagent turns repository context and requirements into a backend architecture specification. It is activated for proposed changes to APIs, data, and services. CX Codex ★ 776repo stars

Project sponsors

Companies that keep this analytics open