database-design
Database schema design, optimization, and migration patterns for PostgreSQL, MySQL, and NoSQL databases. Use for designing schemas, writing migrations, or optimizing queries.
By moizibnyousaf · 578 installs
npx skills add moizibnyousaf/ai-agent-skills --skill database-design
Source repository · Upstream listing
Database Design
Schema Design Principles
Normalization Guidelines
Denormalization for Performance
Index Design
Common Index Patterns
Index Analysis
Migration Patterns
Safe Migration Template
Zero Downtime Migrations
Query Optimization
EXPLAIN Analysis
Common Optimizations
Constraints & Data Integrity
Best Practices
Use UUIDs for public facing IDs, SERIAL/BIGSERIAL for internal
Always add created at and updated at timestamps
Use soft deletes ( deleted at ) for important data
Design for eventual consistency in distributed systems
Document schema decisions in migration files
Test migrations on production size data before deploying