PostgreSQL Table Design

关于

This skill empowers Claude Code with deep expertise in PostgreSQL database architecture, enabling the creation of robust, production-ready schemas. It provides specialized guidance on normalization to 3NF, sophisticated indexing strategies (B-tree, GIN, GiST, BRIN), and the selection of optimal data types for performance and precision. Beyond basic table design, it covers advanced features such as row-level security, declarative partitioning for large-scale datasets, and performance tuning for insert-heavy or update-heavy workloads, ensuring your database remains efficient as it grows.

主要功能

• Expert schema normalization and data integrity enforcement (3NF).
• Declarative partitioning patterns (Range, List, Hash) for massive datasets.
• Advanced indexing strategies including partial, expression, and covering indexes.
• Optimization of PostgreSQL-specific types like JSONB, TIMESTAMPTZ, and UUID.
• Implementation of Row-Level Security (RLS) and complex constraints.
• 23,194 GitHub stars

使用场景

• Designing a scalable multi-tenant SaaS database with Row-Level Security.
• Optimizing an existing schema for high-read performance or large-scale logging.
• Migrating legacy database structures to modern PostgreSQL best practices.