Why does it prefer BIGINT over UUID for primary keys?

It follows the practice of using BIGINT GENERATED ALWAYS AS IDENTITY for superior performance and storage efficiency, recommending UUID only for distributed systems where global uniqueness is required.

Can it help with row-level security (RLS)?

Yes, it includes instructions for enabling RLS and creating access policies to secure your data at the database level for multi-tenant applications.

Does this skill support PostgreSQL-specific types like JSONB?

Yes, it provides detailed guidance on when and how to use JSONB, including GIN indexing for optimal search performance.

How does this help with database performance?

It implements best practices for indexing (B-tree, GIN, GiST), partitioning for large datasets, and specific configurations for update-heavy vs. insert-heavy workloads.

Does it handle schema migrations?

It focuses on the architectural design of tables and constraints, which can be directly used to generate high-quality, production-ready migration scripts.

PostgreSQL Table Design Expert

Name: PostgreSQL Table Design Expert
Author: HermeticOrmus

byHermeticOrmus

0•

Database Management

Architects high-performance PostgreSQL schemas using industry-standard best practices for indexing, data types, and normalization.

This skill transforms Claude into a PostgreSQL specialist, providing comprehensive guidance on designing robust and scalable database schemas. It enforces critical architectural rules like 3NF normalization, proper use of constraints, and optimized indexing strategies including B-tree, GIN, and GiST. Whether you are handling time-series data with partitioning, managing JSONB for semi-structured attributes, or optimizing update-heavy tables with fillfactor adjustments, this skill ensures your database architecture is performant, durable, and follows modern PostgreSQL idioms.

Key Features

010 GitHub stars

02Advanced indexing strategies (Partial, Expression, Covering, GIN/GiST)

03Partitioning strategies for large-scale data (Range, List, Hash)

04Comprehensive data type guidance (TIMESTAMPTZ, BIGINT, JSONB, etc.)

05Schema normalization and performance-driven denormalization patterns

06Constraint management including Row-Level Security and Exclusion constraints

Use Cases

01Refactoring legacy databases to use modern PostgreSQL features like identity columns

02Designing a new relational schema for a SaaS application from scratch

03Optimizing existing slow queries by implementing advanced indexing or partitioning

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/floraheritage postgresql

For use in Claude.ai and ChatGPT

Download Skill