Can it help with modern PostgreSQL features like JSONB?

Absolutely, it covers best practices for JSONB usage, indexing with GIN for containment queries, and when to prefer structured columns over semi-structured data.

Does it follow specific naming conventions?

Yes, it enforces standard snake_case naming for tables and columns and avoids mixed-case quoted identifiers to prevent common PostgreSQL identifier issues.

How does it handle database security?

It provides implementation patterns for Row-Level Security (RLS) and robust constraint management to protect data integrity and access control at the database layer.

Does this skill help with database performance tuning?

Yes, it provides detailed guidance on indexing strategies, partitioning, and vacuum behavior to ensure optimal database performance for both read and write-heavy workloads.

Can I use it for designing time-series data structures?

Yes, it includes specialized advice for time-series workloads, including BRIN indexing, partitioning strategies, and integration with extensions like TimescaleDB.

PostgreSQL Schema Architect

Name: PostgreSQL Schema Architect
Author: duanbiao2000

byduanbiao2000

0•

数据库管理

Designs high-performance, industry-standard PostgreSQL schemas following expert-level normalization and optimization patterns.

The PostgreSQL Table Design skill provides comprehensive guidance for creating robust database schemas that leverage the full power of modern PostgreSQL. It enforces best practices such as 3NF normalization, identity columns over serial types, and the use of TIMESTAMPTZ for temporal data. Beyond basic structure, the skill assists with advanced performance tuning through strategic indexing—including GIN, GiST, and BRIN—and provides implementation patterns for Row-Level Security (RLS), declarative partitioning, and efficient JSONB usage. This is an essential resource for developers looking to build scalable, production-grade databases that avoid common pitfalls and maintainable data integrity.

主要功能

01Enforces 3NF normalization and provides strategic denormalization advice

02Configures Row-Level Security (RLS) policies and complex database constraints

03Recommends modern PostgreSQL data types like BIGINT Identity and TIMESTAMPTZ

04Optimizes large-scale tables via declarative partitioning and storage strategy analysis

05Guides implementation of advanced indexing including GIN, GiST, BRIN, and Partial indexes

060 GitHub stars

使用场景

01Migrating legacy database schemas to leverage modern PostgreSQL 15+ features

02Designing a scalable schema for a high-traffic e-commerce or SaaS platform

03Optimizing slow-performing queries through advanced indexing and partitioning analysis

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add duanbiao2000/obsidiandoc26 postgresql

For use in Claude.ai and ChatGPT

Download Skill