db-wasp-drone — Claude Code subagent: installation
db-wasp-drone — a PostgreSQL architecture subagent for schema design, indexes, migrations, ORM decisions, query plans, and serverless database selection.
AGPL-3.0-or-later ★ 96 updated 2026-10-18
/plugin marketplace add legioncodeinc/vibe-coding-tools
/plugin install data-and-ai-tools@wasp-nestWhat db-wasp-drone does
db-wasp-drone reviews PostgreSQL data architecture across schema design, indexing, migration safety, query performance, pooling, ORM selection, and serverless database choice. It compares Drizzle, Prisma, and raw SQL, reads EXPLAIN (ANALYZE, BUFFERS) plans, and covers Supabase, Neon, Turso, PlanetScale, CockroachDB, and Tiger Data.
The workflow starts with the project’s DDL or ORM schema, recent migrations, query plans, pooler settings, and ORM versions. Index reviews distinguish B-tree, GIN, GiST, BRIN, partial, and covering indexes; the package also includes scripts/audit-missing-indexes.sql. Tables larger than 1M rows require an expand-backfill-contract migration plan, with pgroll available for online changes.
This subagent routes PRD writing, RLS or PII security audits, encryption-at-rest checks, and RAG retrieval work to other agents. A serious review needs the relevant schema, migration, or query plan first.
What it helps with
- design a relational PostgreSQL schema
- choose an index for a workload and column type
- plan a safe migration for a large table
- diagnose a slow query from
EXPLAINoutput - compare Drizzle, Prisma, and raw SQL
Example prompts for the agent
- Design a PostgreSQL schema for this feature and recommend its indexes.
- Review this migration for a table larger than 1M rows and split it into safe phases.
- Read this
EXPLAIN (ANALYZE, BUFFERS)plan and identify the missing index.
How to install db-wasp-drone
1Plugin marketplace
/plugin marketplace add legioncodeinc/vibe-coding-tools/plugin install data-and-ai-tools@wasp-nest2Manually: put the files in place
.claude/agents/db-wasp-drone.mdFor all projects use ~/.claude/agents/. Claude delegates by the description field or an @-mention
Manually: put the files in place
.codex/agents/db-wasp-drone.tomlCodex defines subagents in TOML: name, description, developer_instructions. Move the Markdown text into developer_instructions by hand. For all projects use ~/.codex/agents/
Manually: put the files in place
.cursor/agents/db-wasp-drone.mdCursor also reads .claude/agents/
Step by step, with commands for each platform: Claude Code subagents: how to create one, call it and keep context clean
Questions about db-wasp-drone
How do I install db-wasp-drone in Claude Code?
Add the marketplace with /plugin marketplace add legioncodeinc/vibe-coding-tools, then install the plugin with /plugin install data-and-ai-tools@wasp-nest. Finally, add .claude/agents/db-wasp-drone.md.
What does db-wasp-drone do?
It reviews PostgreSQL schemas, indexes, migrations, query performance, connection pooling, ORM choices, and serverless database platforms. It can produce an audit, migration plan, or architecture ADR.
What should I provide for a query performance review?
Give the agent the query and an EXPLAIN (ANALYZE, BUFFERS) plan. Include the schema, migrations, and pool settings when they affect the issue.