Does this skill help with PostgreSQL performance tuning?

Yes, it provides specific strategies for indexing, partitioning, and managing MVCC bloat to ensure high-performance queries even under heavy load.

Can it handle modern PostgreSQL features like JSONB and Vectors?

Absolutely. It covers advanced features including JSONB for semi-structured data, RLS for security, and specialized types like vectors for AI embeddings via pgvector.

Does it provide guidance on choosing correct data types?

Yes, it recommends specific types such as BIGINT GENERATED ALWAYS AS IDENTITY over SERIAL, and TIMESTAMPTZ over TIMESTAMP to ensure global consistency and reliability.

How does it handle large-scale data migrations or evolution?

The skill includes patterns for safe schema evolution using transactional DDL and strategies for partitioning (RANGE, LIST, HASH) to manage datasets exceeding 100M rows.

PostgreSQL Schema Architect

Name: PostgreSQL Schema Architect
Author: sla-te

bysla-te

0•

Gestión de Bases de Datos

Designs production-ready PostgreSQL schemas using industry best practices for data integrity, indexing, and performance optimization.

This skill transforms Claude into a specialized PostgreSQL architect, providing comprehensive guidance for building robust and scalable database models. It enforces critical design patterns such as 3NF normalization, proper indexing of foreign keys, and the strategic use of modern PostgreSQL features like identity columns, JSONB, and Row-Level Security. Whether you are bootstrapping a new project or optimizing a high-traffic system, this skill helps you avoid common pitfalls like silent type coercion and table bloat while ensuring your data types and constraints are semantically correct.

Características Principales

01Implementation of Row-Level Security (RLS) and complex CHECK/EXCLUDE constraints

02Expert data type selection including BIGINT Identity, TIMESTAMPTZ, and JSONB

030 GitHub stars

04Declarative partitioning and schema evolution strategies for large-scale data

05Performance patterns for update-heavy workloads and high-volume inserts

06Advanced indexing strategies for B-tree, GIN, GiST, and partial indexes

Casos de Uso

01Optimizing query performance through advanced indexing and partitioning strategies

02Architecting a normalized relational schema for a new enterprise application

03Implementing secure multi-tenant data models using Row-Level Security

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add sla-te/copilot-converter postgresql

For use in Claude.ai and ChatGPT

Download Skill