database-schema-design
Installation
Summary
Design and optimize SQL and NoSQL database schemas with normalization, indexing, and migration strategies.
- Covers entity definition, relationship design (1:1, 1:N, N:M), and normalization levels (1NF–3NF) for PostgreSQL, MySQL, MongoDB, and SQLite
- Provides indexing strategies, constraint setup, and trigger implementation to ensure data integrity and query performance
- Includes migration script generation with UP/DOWN rollback capabilities for safe schema evolution
- Delivers complete schema artifacts: ERD diagrams, SQL DDL, migration files, and documentation with best practices for denormalization trade-offs
SKILL.md
Database Schema Design
When to use this skill
Lists specific situations where this skill should be triggered:
- New Project: Database schema design for a new application
- Schema Refactoring: Redesigning an existing schema for performance or scalability
- Relationship Definition: Implementing 1:1, 1:N, N:M relationships between tables
- Migration: Safely applying schema changes
- Performance Issues: Index and schema optimization to resolve slow queries
Input Format
The required and optional input information to collect from the user: