cyberneticlibrary

Design and write database schema

dbasubagentsetup L10
uygnoey/multi-agent
What it does

Design and write database schemas

Best for

When data layer must be explicit and performant before backend implements repositories.

Inputs
  • · data model spec
  • · performance requirements
Outputs
  • · schema.sql
  • · migrations
  • · index scripts
Requires
  • · SQLite
  • · Postgres
Preconditions
  • · DB choice pinned in CLAUDE.md
  • · Data model documented
Failure modes
  • · missing constraints
  • · N+1 queries
  • · unsafe migrations
Trust signals
  • · Migration pattern examples
  • · Constraint emphasis