postgresql-table-design
CommunityPostgreSQL table design with best practices.
Authorovachiever
Version1.0.0
Installs0
System Documentation
What problem does it solve?
Provides a design guide for PostgreSQL schemas emphasizing normalization, appropriate data types, indexing, constraints, and performance considerations to build scalable, maintainable data models.
Core Features & Use Cases
- Primary keys, normalization to 3NF, and when to denormalize
- Data types recommendations (TIMESTAMPTZ, NUMERIC, TEXT, BIGINT)
- Indexing strategies, including FK indexes and expression indexes
- Constraints, partitioning, and advanced features (JSONB usage, range types)
- Practical examples for common domains (Users, Orders, Transactions)
Quick Start
Design a new schema with a Users table (BIGINT IDENTITY primary key) and a related Orders table, ensuring proper FK relationships and indexing.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: postgresql-table-design Download link: https://github.com/ovachiever/droid-tings/archive/main.zip#postgresql-table-design Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.