Can it assist with database security?

Yes, it includes patterns for implementing Row-Level Security (RLS) policies to control data access at the engine level.

Does this skill help with performance for very large tables?

Yes, it provides strategies for declarative partitioning (Range, List, Hash) and BRIN indexing, which are ideal for tables exceeding 100 million rows.

What are the common PostgreSQL 'gotchas' this skill prevents?

It specifically addresses unquoted identifier casing, the lack of automatic foreign key indexing, and the nuances of NULLs in unique constraints.

Why does this skill prefer BIGINT over UUID for primary keys?

BIGINT GENERATED ALWAYS AS IDENTITY is preferred for performance and storage efficiency in most cases; UUID is recommended only when global uniqueness or opacity is required.

How does it handle semi-structured data?

It provides best practices for using JSONB and GIN indexing, allowing for flexible schemas while maintaining query performance.

PostgreSQL Schema Architect

Name: PostgreSQL Schema Architect
Author: HermeticOrmus

byHermeticOrmus

•

数据库管理

Designs high-performance, normalized PostgreSQL schemas using industry best practices for indexing, data types, and scaling.

The PostgreSQL Schema Architect skill transforms Claude into a senior database engineer, providing expert guidance on designing robust and efficient PostgreSQL databases. It covers the full spectrum of schema design, from selecting the most efficient data types—such as TIMESTAMPTZ and BIGINT identity columns—to implementing advanced features like Row-Level Security, GIN/GiST indexing, and declarative partitioning. Designed to avoid common pitfalls like silent truncations or unindexed foreign keys, this skill ensures your database is optimized for both transactional integrity and high-concurrency performance, making it ideal for everything from game backends to enterprise-grade APIs.

主要功能

014 GitHub stars

02Advanced indexing strategies (Partial, Expression, Covering, and BRIN)

03Scalable partitioning patterns for multi-million row tables

04Performance tuning for update-heavy and insert-heavy workloads

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

06Expert data type selection including JSONB, GIN/GiST, and network types

使用场景

01Optimizing high-traffic databases for read/write performance and reliability

02Architecting scalable backends for multiplayer games and web applications

03Refactoring legacy SQL schemas to modern PostgreSQL standards

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/claude-code-game-development postgresql

For use in Claude.ai and ChatGPT

Download Skill