Design relational and document databases
database-specialistsubagentsetup L3★1
dherrero/fullstack-starter ↗What it does
Design PostgreSQL and MongoDB schemas
Best for
Crafting zero-downtime migrations and optimizing query patterns.
Inputs
- · schema spec
- · query requirements
- · cardinality estimates
Outputs
- · migration .sql files
- · index strategy
- · backup plan
Requires
- · sonnet-model
- · Sequelize
Preconditions
Repo: dherrero/fullstack-starter. Context files must exist.
Failure modes
Incorrect schema assumptions, missing migration history, cardinality mismatch
Trust signals
- · Detailed multi-step procedure
- · Includes verification step
- · Code examples provided
- · Specifies sonnet model
- · Comprehensive documentation (>2000 chars)