database-schema-designer

1# Database Schema Designer
2 
3Design production-ready database schemas with best practices built-in.
4 
5---
6 
7## Quick Start
8 
9Just describe your data model:
10 
11```
12design a schema for an e-commerce platform with users, products, orders
13```
14 
15You'll get a complete SQL schema like:
16 
17```sql
18CREATE TABLE users (
19  id BIGINT AUTO_INCREMENT PRIMARY KEY,
20  email VARCHAR(255) UNIQUE NOT NULL,
21  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
22);
23 
24CREATE TABLE orders (
25  id BIGINT AUTO_INCREMENT PRIMARY KEY,
26  user_id BIGINT NOT NULL REFERENCES users(id),
27  total DECIMAL(10,2) NOT NULL,
28  INDEX idx_orders_user (user_id)
29);
30```
31 
32**What to include in your request:**
33- Entities (users, products, orders)
34- Key relationships (users have orders, orders have items)
35- Scale hints (high-traffic, millions of records)
36- Database preference (SQL/NoSQL) - defaults to SQL if not specified
37 
38---
39 
40## Triggers
41 
42| Trigger | Example |
43|---------|---------|
44| `design schema` | "design a schema for user authentication" |
45| `database design` | "database design for multi-tenant SaaS" |
46| `create tables` | "create tables for a blog system" |
47| `schema for` | "schema for inventory management" |
48| `model data` | "model data for real-time analytics" |
49| `I need a database` | "I need a database for tracking orders" |
50| `design NoSQL` | "design NoSQL schema for product catalog" |
51 
52---
53 
54## Key Terms
55 
56| Term | Definition |
57|------|------------|
58| **Normalization** | Organizing data to reduce redundancy (1NF → 2NF → 3NF) |
59…