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.