About
The PostgreSQL Table Design skill empowers Claude to act as an expert database architect, providing specific guidance on schema normalization, optimized data type selection, and advanced indexing strategies. It ensures your database layer is robust and scalable by enforcing rules like using TIMESTAMPTZ for events, BIGINT for identity, and GIN/GiST indexes for complex data types. Beyond basic DDL, it provides deep insights into performance optimization for insert-heavy workloads, row-level security implementation, and safe schema evolution through transactional DDL.
