Can this skill help with large-scale data management?

Yes, it includes detailed patterns for declarative partitioning (Range, List, and Hash) to manage tables exceeding 100 million rows efficiently.

How does this skill handle time-zone sensitive data?

The skill strictly enforces the use of TIMESTAMPTZ over TIMESTAMP to ensure all time data is stored with UTC offsets, preventing common timezone-related bugs.

Does it provide advice for JSON storage?

It recommends JSONB for most semi-structured data needs due to its support for GIN indexing and efficient binary storage, reserving JSON only for cases where original ordering must be preserved.

Why does this skill discourage using the SERIAL data type?

It favors 'GENERATED ALWAYS AS IDENTITY' which is SQL standard compliant and provides cleaner behavior for identity management compared to the legacy SERIAL macro.

PostgreSQL Schema Architect

Name: PostgreSQL Schema Architect
Author: HermeticOrmus

byHermeticOrmus

0•

データベース管理

Designs high-performance, production-grade PostgreSQL schemas optimized for durability, scalability, and modern data standards.

This skill empowers Claude with expert-level PostgreSQL architectural guidance, focusing on 3rd Normal Form (3NF) normalization, efficient data type selection, and advanced indexing strategies. It enforces strict industry best practices, such as using identity columns instead of legacy serial types and prioritizing TIMESTAMPTZ for global consistency. Whether designing multi-tenant SaaS databases or high-throughput time-series tables, this skill provides the patterns needed for Row-Level Security, partitioning, and performance tuning to ensure your database remains robust under heavy workloads.

主な機能

010 GitHub stars

02Advanced indexing strategies (B-tree, GIN, GiST, BRIN, and Partial)

03Partitioning patterns for massive datasets (Range, List, and Hash)

04Optimized data type selection including JSONB, Vector, and Range types

05Standardized identity columns and primary key best practices

06Row-Level Security (RLS) and policy-driven access control

ユースケース

01Refactoring legacy database structures to modern PostgreSQL standards

02Designing a scalable relational schema for a multi-tenant web application

03Optimizing database performance for high-concurrency write and read operations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add hermeticormus/alqvimia-contador postgresql

For use in Claude.ai and ChatGPT

Download Skill