PostgreSQL Table Design

关于

This skill provides comprehensive guidance for architecting PostgreSQL databases, focusing on schema normalization, optimal data type selection, and advanced indexing strategies. It helps developers avoid common pitfalls like silent coercions and unindexed foreign keys while leveraging powerful features such as Row-Level Security (RLS), partitioning for large datasets, and specialized types for JSONB, vectors, and full-text search. Whether building a new application or optimizing an existing database, this skill ensures your PostgreSQL implementation is scalable, maintainable, and performance-optimized.

主要功能

• Advanced schema normalization and 3NF design patterns
• Optimal data type selection including JSONB, UUID, and pgvector
• Comprehensive indexing strategies using B-tree, GIN, GiST, and BRIN
• Performance tuning for insert-heavy and update-heavy workloads
• Implementation of Row-Level Security (RLS) and declarative partitioning
• 1 GitHub stars

使用场景

• Architecting a new SaaS backend with scalable and normalized table structures
• Optimizing slow queries through advanced indexing and table partitioning
• Implementing secure multi-tenant data access using Row-Level Security policies