cyberneticlibrary

Design database schemas and queries

db-architectsubagentsetup L21
Carlos-Dominguez-faber/nucleo
What it does

Design database schemas and indexes

Best for

When designing PostgreSQL schemas with normalization trade-offs and index optimization.

Inputs
  • · source files or paths
  • · structured config (JSON/YAML)
Outputs
  • · generated source files
Requires
  • · PostgreSQL database
  • · Supabase platform
  • · bash execution
  • · file reading
  • · file writing
Preconditions
  • · PostgreSQL or Supabase instance accessible
Failure modes
  • · Input files missing or unreadable
  • · Database connection failure
Trust signals
  • · References established patterns
  • · Enforces strict validation rules
  • · CI/CD automation ready