How does this skill improve PostgreSQL performance?

It provides specific patterns for indexing, such as using GIN for JSONB and B-tree for selective columns, and suggests table-specific settings like fillfactor for update-heavy environments.

Can it handle modern PostgreSQL features?

Absolutely. It includes guidance on modern features like NULLS NOT DISTINCT (PG15+), JSONB, identity columns, and declarative partitioning.

Does this skill help with data integrity?

Yes, it enforces strict practices regarding NOT NULL constraints, foreign key indexing, and custom CHECK or EXCLUDE constraints to prevent invalid data entry.

Why does it recommend BIGINT over UUID for primary keys?

It prefers BIGINT GENERATED ALWAYS AS IDENTITY for performance and storage efficiency, suggesting UUIDs only when global uniqueness or opacity is strictly required.

PostgreSQL Table Design Guide

Name: PostgreSQL Table Design Guide
Author: trancong12102

bytrancong12102

•

Database Management

Architects high-performance, production-ready PostgreSQL schemas using industry-standard best practices and domain-specific patterns.

This skill provides Claude with a comprehensive knowledge base for designing robust PostgreSQL databases. It moves beyond basic SQL to offer specific guidance on optimal data types, advanced indexing strategies like GIN and GiST, table partitioning for large datasets, and performance tuning for specific workloads. By incorporating PostgreSQL 'gotchas' and modern features like Identity columns and Row-Level Security, this skill ensures your database architecture is scalable, maintainable, and optimized for peak performance.

Key Features

01Comprehensive constraint logic covering PKs, FKs, CHECK constraints, and exclusion policies.

02Workload-specific optimizations for update-heavy, insert-heavy, and upsert-heavy tables.

03Expert data type selection including TIMESTAMPTZ, BIGINT identity, and JSONB recommendations.

04Advanced indexing patterns for B-tree, GIN, GiST, BRIN, and partial/expression indexes.

05Scalability strategies via declarative partitioning (Range, List, Hash) and TimescaleDB patterns.

061 GitHub stars

Use Cases

01Refactoring legacy table structures to improve query performance and eliminate data redundancy.

02Implementing complex access controls using PostgreSQL Row-Level Security (RLS) and custom domain types.

03Designing normalized 3NF database schemas for new applications from scratch.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add trancong12102/ccc design-postgres-tables

For use in Claude.ai and ChatGPT

Download Skill