Skip to content
Development
Command

/db

Diagnose and fix a database bottleneck evidence-first — EXPLAIN, indexes, N+1, locks, pooling, safe migrations

From plugin
hydraia
817 skills27 agents17 commands4 hooks
Install
> /plugin marketplace add jdanigo/hydraia
> /plugin install hydraia@hydraia

How it fires

How this command gets triggered: by you, by Claude, or both.

  • Fires itselfClaude auto-loads it when your prompt matches the work.
  • You can call itInvoke it directly when you want it.
  • Slash command/db

Context preview

What this command does when you run it.

Diagnose and fix a database bottleneck evidence-first — EXPLAIN, indexes, N+1, locks, pooling, safe migrations

Command definition

db.md
description: Diagnose and fix a database bottleneck evidence-first — EXPLAIN, indexes, N+1, locks, pooling, safe migrations
argument-hint: <symptom or query — e.g. "orders list times out when filtering by date">

Invoke the **hydraia** skill forcing the Phase -1 route to **performance (DB-shaped)**. Follow the performance-tuning and db-optimization skills with the db-performance-tuner agent as PRIMARY diagnostician: detect the engine from evidence, collect read-only evidence (EXPLAIN plans, stat views, slow logs — redacting data values), classify findings (index, query shape, N+1, locking, pooling, schema, caching), write the spec with baseline + numeric target, then run the full pipeline. Schema changes follow expand-contract; write-shaped operations are plan tasks, never direct agent actions. Dispatch perf-engineer too only if the evidence points outside the database.

Request: $ARGUMENTS

Ships withhydraia

An agentic development harness for Claude Code. **One command runs the entire feature pipeline** — it collaborates with you on the design, then builds autonomously: plan, execute, double-review, and verify.

Get the whole plugin

Other commands on hydraia.