database-schema-designer

Production-ready SQL and NoSQL schemas with normalization, indexing, and migration strategies built in. Design production-ready database schemas with best practices built-in. Just describe your data model: You'll get a complete SQL schema like: What to include in your request: Workflow: Start with design schema → iterate with normalize → optimize with add indexes → evolve with migration After designing a schema: Rule: Most selective column first, or column most queried alone. - Generates complete schemas from natural language descriptions, covering entities, relationships, constraints, and indexes tailored to SQL or NoSQL databases - Provides normalization guidance (1NF through 3NF), foreign key strategies with ON DELETE rules, and composite index planning based on access patterns - Includes anti-patterns reference (FLOAT for money, missing FK indexes, non-reversible migrations) and verification checklist for schema quality - Supports zero-downtime migration patterns, denormalization for read-heavy workloads, and performance optimization via EXPLAIN analysis and query pattern matching - Entities (users, products, orders) - Key relationships (users have orders, orders have items) - Scale hints (high-traffic, millions of records) - Database preference (SQL/NoSQL) - defaults to SQL if not specified - Database-Specific Patterns: Add MySQL vs PostgreSQL vs SQLite variations -...