ss-design-postgres-tables

What problem does it solve?

This Skill provides comprehensive guidance and best practices for designing efficient and robust PostgreSQL tables, schemas, and data models.

Core Features & Use Cases

• Data Type Selection: Recommends appropriate data types for various use cases (IDs, strings, numbers, time, JSONB, etc.).
• Constraint Design: Details best practices for Primary Keys, Foreign Keys, UNIQUE, CHECK, and EXCLUDE constraints.
• Indexing Strategies: Explains different index types (B-tree, GIN, GiST, BRIN) and when to use them.
• Partitioning: Guides on implementing effective table partitioning for large datasets.
• Use Case: When designing a new e-commerce application, use this Skill to ensure your products and orders tables are structured for performance, scalability, and data integrity.

Quick Start

Use the ss-design-postgres-tables skill to design a PostgreSQL table for storing user profiles with an email, name, and a JSONB field for preferences.