Acerca de
This skill provides Claude with comprehensive expertise in PostgreSQL database architecture, covering everything from initial normalization (3NF) to advanced performance tuning. It enforces modern standards like identity columns over serial types, TIMESTAMPTZ for temporal data, and strategic indexing for complex query paths. By incorporating deep knowledge of PostgreSQL 'gotchas'—such as the lack of automatic foreign key indexing and the nuances of MVCC—this skill ensures that your database designs are not only semantically correct but also optimized for production-grade workloads, including insert-heavy time-series data and update-heavy transactional systems.
