Skip to main content
subagent CX Codex

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

Install into Claude Code · Plugin marketplace All methods and platforms ↓
/plugin marketplace add legioncodeinc/vibe-coding-tools
/plugin install data-and-ai-tools@wasp-nest
Open on GitHub

What 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 EXPLAIN output
  • 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-nest

2Manually: put the files in place

.claude/agents/db-wasp-drone.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 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.

Similar subagents

All subagents for Data and databases →

From the same set172

The whole set →
customer-support-tooling-wasp-drone customer-support-tooling-wasp-drone helps SaaS teams pick helpdesk software, organize shared inboxes, integrate Linear and draft SLA policies for small founder-led squads. CX Codex ★ 96repo stars typography-font-wasp-drone typography-font-wasp-drone is a Claude Code subagent for font loading and web typography. It activates for requests about FOIT/FOUT, fluid type scales, or moving to next/font. CX Codex ★ 96repo stars mcp-tool-docs-stinger mcp-tool-docs-stinger — a skill for documenting MCP tools, TypeScript APIs, and CLIs grounded in source code: schemas, outputs, side effects, examples. Use when writing or auditing tool, API, or CLI documentation. CX Codex +1 ★ 96repo stars queen-wasp-stinger queen-wasp-stinger — an orchestrator skill for authoring, testing, and packaging Wasp Nest components, subagents, rules, and plugins in Claude Code and Codex. CX Codex +1 ★ 96repo stars ux-ui-wasp-drone ux-ui-wasp-drone — a subagent for Claude Code and Codex that enforces a project's design system on UI and components, tracks token drift, and governs shadcn/ui, Mantine, Lucide-react, and Framer Motion integration. CX Codex ★ 96repo stars devops-wasp-drone devops-wasp-drone is a Claude Code subagent for container builds and CI/CD workflows in Node.js, Next.js, and TypeScript projects. CX Codex ★ 96repo stars knowledge-wasp-drone The knowledge-wasp-drone subagent writes technical documentation that explains how a repository works. Use it for architecture notes, system overviews, and data references. CX Codex ★ 96repo stars kb-refresh-stinger kb-refresh-stinger refreshes the entire docs folder: splits work into units, runs parallel writer and verifier agents, checks citations and secrets, opens ready PRs with gate reports. CX Codex +1 ★ 96repo stars

Project sponsors

Companies that keep this analytics open