Does it cover advanced PostgreSQL features?

Yes, it includes specialized guidance on Row-Level Security (RLS), JSONB indexing, range types, and custom domain types.

Can it help with bulk data loading?

Yes, it provides specific patterns for insert-heavy workloads, including the use of COPY commands, multi-row inserts, and UNLOGGED tables for staging.

Which ID type does this skill recommend?

It prefers BIGINT GENERATED ALWAYS AS IDENTITY for standard tables and UUIDv7 for distributed systems or where global uniqueness is required.

Does this skill help with performance tuning?

Yes, it provides specific guidance on indexing strategies, partitioning, and vacuum behavior to ensure high performance under various workloads.

How does it handle naming conventions?

It follows standard PostgreSQL conventions, recommending snake_case and lowercase identifiers to avoid issues with quoted or mixed-case names.

PostgreSQL Table Design Specialist

Name: PostgreSQL Table Design Specialist
Author: carloscroc

bycarloscroc

0•

数据库管理

Designs optimized PostgreSQL database schemas using performance-first patterns and industry best practices.

This skill transforms Claude into an expert PostgreSQL architect, providing specialized guidance for schema design, data type selection, and performance optimization. It enforces best practices like 3NF normalization, proper indexing of foreign keys, and the use of robust data types such as TIMESTAMPTZ and BIGINT. Whether you are building time-series logs, high-concurrency transactional systems, or complex data models, this skill ensures your PostgreSQL implementation is scalable, durable, and follows modern standards like Row-Level Security and declarative partitioning.

主要功能

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

020 GitHub stars

03Comprehensive schema design rules for normalization and data integrity

04Advanced indexing strategies including B-tree, GIN, GiST, and BRIN

05Optimized data type selection for performance and precision

06Implementation patterns for Partitioning, Row-Level Security, and Upserts

使用场景

01Implementing advanced PostgreSQL features like Row-Level Security or time-series partitioning

02Designing a high-performance relational schema for a new SaaS application

03Refactoring an existing database to improve query speed and data consistency

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add carloscroc/fitness postgresql

For use in Claude.ai and ChatGPT

Download Skill