Database Schema Designer

Overview

This skill designs database schemas from requirements, including table structures, relationships, indexes, constraints, row-level security policies, and migration scripts. It produces production-ready SQL with proper normalization and performance considerations.

Instructions

Step 1: Understand the Domain

Identify the core entities, their relationships, and access patterns:

• What are the main entities? (users, orders, products, etc.)
• What are the relationships? (one-to-many, many-to-many)
• What queries will be most frequent? (reads vs writes, filtering patterns)
• Is multi-tenancy needed? What isolation level?

Step 2: Design the Schema

Apply these principles: