Does this skill help with query performance?

Yes, it provides specific rules for indexing access paths, including mandatory FK indexing, B-tree for ranges, and GIN for JSONB or array containment queries.

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

It favors BIGINT GENERATED ALWAYS AS IDENTITY for superior performance and storage efficiency, recommending UUID only for distributed systems where global uniqueness is mandatory.

How does it handle time-series or large-scale data?

The skill includes patterns for RANGE partitioning and recommends TimescaleDB for automated partitioning and compression of insert-heavy workloads.

What PostgreSQL data types are discouraged by this skill?

It explicitly advises against using SERIAL, VARCHAR(n), CHAR(n), and TIMESTAMP without time zone, opting for more robust alternatives like TEXT and TIMESTAMPTZ.

Can it assist with secure data access?

Yes, it includes guidance on implementing Row-Level Security (RLS) policies to manage user-based access control at the database level.

PostgreSQL Schema Architect

Name: PostgreSQL Schema Architect
Author: amurata

byamurata

•

Database Management

Designs optimized, production-ready PostgreSQL schemas following industry best practices for data integrity and performance.

This skill transforms Claude into a specialized database architect focused on modern PostgreSQL standards. It provides rigorous guidance on schema design, from selecting the most efficient data types like TIMESTAMPTZ and BIGINT Identity columns to implementing advanced indexing strategies and partitioning for high-scale environments. By enforcing best practices such as 3NF normalization, proper constraint usage, and row-level security, it ensures your database is scalable, maintainable, and high-performing while avoiding common pitfalls like silent coercions or unindexed foreign keys.

Key Features

01Optimized data type selection including JSONB, TIMESTAMPTZ, and Identity columns

023 GitHub stars

03Declarative partitioning patterns for large-scale data management

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

05Schema normalization to 3NF and high-ROI denormalization tactics

06Best practices for Row-Level Security (RLS) and safe DDL evolution

Use Cases

01Architecting scalable relational databases for new SaaS applications

02Refactoring legacy schemas to modern PostgreSQL standards to improve performance

03Implementing complex data models using range types, vectors, or JSONB storage

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add amurata/cc-tools postgresql

For use in Claude.ai and ChatGPT

Download Skill