What primary key type does this skill recommend?

It recommends using BIGINT GENERATED ALWAYS AS IDENTITY for standard reference tables, suggesting UUID only when global uniqueness or ID opacity is required.

Does this skill provide guidance on JSON data?

Yes, it specifically recommends JSONB over JSON for semi-structured attributes and provides strategies for GIN indexing to maintain performance.

How does it handle time-zone sensitive data?

The skill strictly enforces the use of TIMESTAMPTZ for event times to avoid common pitfalls associated with the TIMESTAMP (without time zone) type.

Can this help with very large datasets?

Yes, it includes detailed patterns for RANGE, LIST, and HASH partitioning, specifically targeting tables with more than 100 million rows.

Does it support modern features like Vector search?

Yes, the skill includes support for vector types via pgvector, enabling the design of databases for AI embeddings and similarity searches.

PostgreSQL Table Design

Name: PostgreSQL Table Design
Author: nguyendinhquocx

bynguyendinhquocx

0•

Database Management

Architects high-performance PostgreSQL schemas using industry best practices for data types, indexing, and normalization.

The PostgreSQL Table Design skill provides Claude with comprehensive expertise to design, refactor, and optimize relational database schemas. It enforces rigorous standards such as 3NF normalization, the use of identity columns over serial types, and the selection of precise data types like TIMESTAMPTZ and NUMERIC. By incorporating advanced patterns for partitioning, GIN/GiST indexing, and Row-Level Security, this skill ensures that database architectures are not only performant and scalable but also maintainable and secure against common 'gotchas' like silent coercions and unindexed foreign keys.

Key Features

01Expert data type selection including JSONB, Vector types, and Range types

02Advanced partitioning patterns for high-volume and time-series data

03Security-first design using Row-Level Security and robust constraints

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

05Comprehensive indexing strategies for B-tree, GIN, GiST, and BRIN

060 GitHub stars

Use Cases

01Refactoring legacy database tables to improve query performance and data integrity

02Designing a new relational schema for a scalable SaaS application

03Implementing specialized storage solutions like full-text search or vector embeddings

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add nguyendinhquocx/code-ai postgresql

For use in Claude.ai and ChatGPT

Download Skill