Can it help with JSONB optimization?

Absolutely. It provides guidance on when to use JSONB versus relational columns and how to implement GIN indexes for efficient semi-structured data queries.

Does it support performance tuning for high-volume writes?

Yes, it includes specific strategies for insert-heavy workloads, such as minimizing index overhead and utilizing unlogged tables or partitioning.

Does this skill handle database migrations?

Yes, it provides the specific SQL syntax and safe DDL patterns needed to write robust migration scripts, focusing on transactional changes to prevent downtime.

Why does it recommend identity columns over Serial?

It follows modern PostgreSQL standards by preferring 'GENERATED ALWAYS AS IDENTITY', which is more SQL-standard compliant and avoids common sequence-related pitfalls.

PostgreSQL Table Design

Name: PostgreSQL Table Design
Author: HermeticOrmus

byHermeticOrmus

0•

データベース管理

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

The PostgreSQL Table Design skill empowers Claude to act as an expert database architect, providing specific guidance on schema normalization, optimized data type selection, and advanced indexing strategies. It ensures your database layer is robust and scalable by enforcing rules like using TIMESTAMPTZ for events, BIGINT for identity, and GIN/GiST indexes for complex data types. Beyond basic DDL, it provides deep insights into performance optimization for insert-heavy workloads, row-level security implementation, and safe schema evolution through transactional DDL.

主な機能

01Declarative partitioning strategies for large-scale data management

02Strict enforcement of data integrity through constraints and Row-Level Security

03Performance patterns for high-concurrency environments and MVCC optimization

04Advanced indexing strategies covering B-tree, GIN, GiST, BRIN, and partial indexes

05Optimized data type selection including JSONB, identity columns, and precise numerics

060 GitHub stars

ユースケース

01Implementing multi-tenant data isolation using Row-Level Security (RLS) policies

02Refactoring legacy PostgreSQL tables to improve query performance and reduce bloat

03Architecting a scalable database schema for a new SaaS application

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/hermetic-line postgresql

For use in Claude.ai and ChatGPT

Download Skill