PostgreSQL Schema Architect

Schema mistakes are the most expensive kind — code refactors in days, but a wrong table design holds your data hostage for years. This skill designs your PostgreSQL schema from the ground up: table structure, normalization decisions and where to deliberately denormalize, index strategy for your actual query patterns, constraint design that enforces business rules at the database level, and the migration path if you're evolving an existing schema. It explains every decision in terms of the trade-offs specific to your use case — not generic best practices, but choices calibrated to your data volume, query patterns, and growth trajectory. Use it before you write your first CREATE TABLE, or when you've hit the performance wall that tells you the original design was wrong. Give it your domain model and your most expensive queries; it returns a schema you can defend.