What primary key convention does this skill follow?

It prefers BIGINT GENERATED ALWAYS AS IDENTITY for standard reference tables and recommends UUID (specifically uuidv7) for distributed systems or global uniqueness.

Does it provide guidance on indexing?

Yes, it covers B-tree for standard queries, GIN for JSONB and arrays, GiST for geometric or range types, and BRIN for large, naturally ordered datasets.

How does it handle time-sensitive data?

The skill strictly enforces the use of TIMESTAMPTZ to ensure time zone awareness and avoid common 'timestamp without time zone' pitfalls.

Can it help with database security?

Absolutely. It includes best practices for Row-Level Security (RLS) and the use of domain types and constraints to ensure data integrity at the schema level.

Does it support modern PostgreSQL features?

Yes, it includes modern features like NULLS NOT DISTINCT (PG15+), declarative partitioning, and pgvector for AI-related similarity searches.

PostgreSQL Table Design

Name: PostgreSQL Table Design
Author: HermeticOrmus

byHermeticOrmus

•

データベース管理

Designs optimized PostgreSQL schemas using industry best practices for performance, data integrity, and scalability.

This skill equips Claude with specialized knowledge for architecting robust PostgreSQL database schemas. It provides comprehensive guidance on selecting optimal data types, implementing 3NF normalization, and configuring advanced indexing strategies like GIN and GiST. By enforcing modern PostgreSQL conventions—such as identity columns over serial types and TIMESTAMPTZ for global consistency—this skill helps developers avoid common pitfalls while optimizing for specific workloads like high-concurrency inserts, update-heavy tables, or complex time-series data.

主な機能

01Implementation of Row-Level Security (RLS) and complex CHECK constraints

02Advanced partitioning guidance for large-scale data and time-series management

03Comprehensive indexing strategies including B-tree, GIN, GiST, and partial indexes

04Optimization patterns for insert-heavy, update-heavy, and upsert workloads

052 GitHub stars

06Expert data type selection including identity columns, JSONB, and network types

ユースケース

01Refactoring legacy schemas to modern PostgreSQL standards and performance patterns

02Architecting new application databases from scratch using 3NF and proper constraints

03Designing high-performance indexing for complex query paths and JSONB data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/libreuiux-claude-code postgresql

For use in Claude.ai and ChatGPT

Download Skill