How does it handle performance for large datasets?

It provides detailed strategies for table partitioning (Range, List, Hash), BRIN indexing for time-series data, and MVCC optimization to avoid bloat.

Can it help me decide between UUID and BIGINT primary keys?

Yes, the skill provides specific criteria for when to use BIGINT IDENTITY for performance versus UUID for global uniqueness and distributed systems.

Does this skill support the latest PostgreSQL features?

Yes, it covers modern PostgreSQL features including PG15+ 'NULLS NOT DISTINCT' and recommendations for pgvector and uuidv7.

Does it enforce specific naming conventions?

Yes, it promotes standard PostgreSQL conventions such as snake_case identifiers and avoiding quoted/mixed-case names to prevent syntax issues.

PostgreSQL Schema Architect

Name: PostgreSQL Schema Architect
Author: gwickman

bygwickman

0•

Gestión de Bases de Datos

Architects optimized PostgreSQL database schemas following industry best practices for performance, scalability, and data integrity.

The PostgreSQL Schema Architect skill provides specialized guidance for designing production-ready database structures. It helps developers navigate complex decisions regarding data types, indexing strategies, and table partitioning while avoiding common pitfalls like silent coercions and unindexed foreign keys. Whether you are building a new application or refactoring an existing schema, this skill ensures your database leverages advanced features such as JSONB, Row-Level Security, and GIN/GiST indexes for maximum efficiency and maintainability.

Características Principales

01Comprehensive indexing strategies for B-tree, GIN, GiST, and BRIN types.

02Strict adherence to normalization (3NF) and PostgreSQL-specific naming conventions.

03Advanced schema features including partitioning, row-level security, and range types.

04Expert data type selection including TIMESTAMPTZ, BIGINT, and JSONB optimization.

050 GitHub stars

06Performance patterns for update-heavy, insert-heavy, and upsert-friendly designs.

Casos de Uso

01Refactoring legacy database schemas to improve query performance and reduce storage bloat.

02Designing a scalable backend for a high-concurrency SaaS application.

03Implementing specialized data structures for time-series logging or vector similarity search.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add gwickman/auto-dev-test-target-1 postgresql

For use in Claude.ai and ChatGPT

Download Skill