Database Design

Example Prompts

• "Design a schema for a multi-tenant SaaS with row-level security"
• "Optimize my slow PostgreSQL query scanning 10M rows"
• "Create a migration to add soft deletes without downtime"

Example Output

CREATE TABLE orders (
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  user_id UUID NOT NULL REFERENCES users(id),
  status VARCHAR(20) NOT NULL DEFAULT 'pending',
  total_cents INTEGER NOT NULL,
  created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);
CREATE INDEX idx_orders_user_status ON orders (user_id, status)
  INCLUDE (total_cents, created_at) WHERE status != 'cancelled';