postgresql-table-design
Tool for architecting efficient, robust PostgreSQL schemas using industry best practices.
Install
mkdir -p .claude/skills/postgresql-table-design && curl -L -o skill.zip "https://agentskills.codes/api/skills/download/52" && unzip -o skill.zip -d .claude/skills/postgresql-table-design && rm skill.zipInstalls to .claude/skills/postgresql-table-design
Activation
This is the description your AI agent reads to decide when to run this skill — the better it matches your request, the more reliably it fires.
Use this skill when designing or reviewing a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced featuresKey capabilities
- →Validate normalization to 3NF standards
- →Apply BIGINT IDENTITY patterns for primary keys
- →Identify missing foreign key indexes
- →Format table and column names to snake_case
- →Configure UNIQUE constraints with NULLS NOT DISTINCT
How it works
Follows a strict checklist of PostgreSQL design rules to enforce consistency and performance at the schema level.
Inputs & outputs
When to use postgresql-table-design
- →Create a new database schema
- →Review schema for normalization issues
- →Add optimized indexes to existing tables
About postgresql-table-design
Guides developers through PostgreSQL schema design, covering normalization, constraints, and specific PostgreSQL behaviors like foreign key indexing. It helps avoid common database pitfalls.
Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features
When not to use it
- →Designing NoSQL schemas
- →Complex data warehousing tasks requiring star schema analysis
Limitations
- →Requires manual confirmation for denormalization choices
- →Does not check for existing data migration conflicts
How it compares
It enforces database-specific constraints like strict type coercion rather than suggesting generic ORM abstractions.
Compared to similar skills
postgresql-table-design side by side with the closest alternatives in the catalog.
| Skill | Installs | Updated | Safety | Difficulty |
|---|---|---|---|---|
| postgresql-table-design (this skill) | 30 | 6mo | No flags | Intermediate |
| event-store-design | 5 | 4mo | No flags | Advanced |
| database-design | 6 | 8mo | Review | Intermediate |
| database-schema-designer | 6 | 8mo | No flags | Intermediate |
Try saying
Example prompts that trigger this skill in your AI assistant.
More by wshobson
View all by wshobson →You might also like
event-store-design
wshobson
Design and implement event stores for event-sourced systems. Use when building event sourcing infrastructure, choosing event store technologies, or implementing event persistence patterns.
database-design
davila7
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.
database-schema-designer
davila7
Design robust, scalable database schemas for SQL and NoSQL databases. Provides normalization guidelines, indexing strategies, migration patterns, constraint design, and performance optimization. Ensures data integrity, query performance, and maintainable data models.
schema-designer
clidey
Help design database schemas, create tables, and plan data models. Activates when users ask to create tables, design schemas, or model data relationships.
managing-database-sharding
jeremylongshore
Process use when you need to work with database sharding. This skill provides horizontal sharding strategies with comprehensive guidance and automation. Trigger with phrases like "implement sharding", "shard database", or "distribute data".
database-design
Harmitx7
Database design principles and decision-making. Schema design, indexing strategy, ORM selection, serverless databases.