database-schema-designer
Design optimized database schemas for SQL and NoSQL databases including tables, relationships, indexes, and constraints. Creates ERD diagrams, migration scripts, and data modeling best practices. Use when users need database design, schema optimization, or data architecture planning.
Works with
--- name: database-schema-designer description: Design optimized database schemas for SQL and NoSQL databases including tables, relationships, indexes, and constraints. Creates ERD diagrams, migration scripts, and data modeling best practices. Use when users need database design, schema optimization, or data architecture planning. license: MIT --- # Database Schema Designer Design optimized, scalable database schemas with proper relationships and indexes. ## Contents - `references/schema-templates.md` — SQL/NoSQL schema templates, ASCII ERD, and migration script templates. - `references/output-format.md` — labeled section structure for the final deliverable. - `references/best-practices.md` — naming, data types, indexes, relationships, SQL/NoSQL design rules, and the output quality checklist. ## Workflow 1. Gather requirements. Determine the database engine (PostgreSQL, MySQL, MongoDB, etc.), application domain, main entities, most common queries, expected data volume and growth, performance requirements, and any compliance constraints. 2. Design the schema. Apply the engine-appropriate rules in `references/best-practices.md` (SQL Database Design or NoSQL Database Design). 3. Generate the complete schema. Produce CREATE TABLE statements or collection documents using the templates in `references/schema-templates.md`. 4. Create the entity relationship diagram in text format following the ERD template in `references/schema-templates.md`. 5. Provide migration scripts with both up and down (rollback) paths, per the migration template in `references/schema-templates.md`. 6. Format the complete output using the labeled sections in `references/output-format.md`. 7. Verify the result against the output quality checklist in `references/best-practices.md`. ## Example Triggers - "Design a database schema for an e-commerce platform" - "Create SQL tables for a blog system" - "Help me design a MongoDB schema for a social network" - "Optimize this database schema for performance" - "Generate migration scripts for my schema" Generate production-ready, optimized database schemas that scale.
More Database skills
supabase-postgres-best-practices
supabase/agent-skills
Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.
prisma-database-setup
prisma/skills
Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, MongoDB, etc.). Use when setting up a new project, changing databases, or troubleshooting connection issues. Triggers on "configure postgres", "connect to mysql", "setup mongodb", "sqlite setup".
prisma-postgres
prisma/skills
Prisma Postgres setup and operations guidance across Console, create-db CLI, Management API, and Management API SDK. Use when creating Prisma Postgres databases, working in Prisma Console, provisioning with create-db/create-pg/create-postgres, or integrating programmatic provisioning with service tokens or OAuth.
