Guides the creation of performant, scalable, and normalized PostgreSQL database schemas using industry best practices.
This skill equips Claude with specialized knowledge for architecting PostgreSQL databases, focusing on performance, data integrity, and modern features. It provides strict guidance on data type selection (preferring TIMESTAMPTZ and BIGINT), indexing strategies for various workloads, and advanced patterns like declarative partitioning and Row-Level Security. By following these rules, developers can avoid common pitfalls such as silent truncations, inefficient vacuuming, and missing foreign key indexes, resulting in a production-grade database foundation.
주요 기능
01Advanced data modeling for JSONB, arrays, range types, and full-text search.
02Comprehensive indexing strategies including B-tree, GIN, GiST, and BRIN for specialized query paths.
03Data integrity enforcement through normalization (3NF) and complex constraints like EXCLUDE and CHECK.
041 GitHub stars
05Performance patterns for update-heavy vs. insert-heavy workloads and safe schema evolution.
06Enforcement of optimal PostgreSQL data types and avoidance of legacy types like SERIAL or VARCHAR(n).
사용 사례
01Architecting a new relational schema for high-concurrency applications.
02Implementing specialized features like geospatial data with PostGIS or time-series partitioning.
03Refactoring existing tables to improve query performance and reduce storage bloat.
