| name | database-design |
| version | 1.0.0 |
| type | knowledge |
| description | Database schema design, migrations, query optimization, and ORM patterns. Use when designing database schemas, writing migrations, optimizing queries, or working with ORMs like SQLAlchemy or Django ORM. |
| keywords | database, schema, migration, query, sql, orm, sqlalchemy, django orm, postgres, mysql, index, transaction |
| auto_activate | true |
| allowed-tools | Read, Write, Edit, Grep, Glob |
Database Design Skill
Database schema design, migration strategies, query optimization, and ORM best practices.
When This Skill Activates
- Designing database schemas
- Writing database migrations
- Optimizing slow queries
- Working with ORMs (SQLAlchemy, Django ORM)
- Setting up database indexes
- Handling transactions
- Keywords: "database", "schema", "migration", "query", "sql", "orm"
Core Concepts
Overview
This skill provides comprehensive guidance on database design. For detailed patterns and implementation examples, see the documentation files in docs/.
Key Topics:
- Detailed methodologies and best practices
- Implementation patterns and examples
- Common pitfalls and anti-patterns
- Cross-references to related skills
See: Documentation files in docs/ directory for complete details
Quick Reference
| Topic | Details |
|---|---|
| Detailed Guide 1 | docs/detailed-guide-1.md |
| Detailed Guide 2 | docs/detailed-guide-2.md |
| Detailed Guide 3 | docs/detailed-guide-3.md |
| Detailed Guide 4 | docs/detailed-guide-4.md |
Progressive Disclosure
This skill uses progressive disclosure to prevent context bloat:
- Index (this file): High-level concepts and quick reference (<500 lines)
- Detailed docs:
docs/*.mdfiles with implementation details (loaded on-demand)
Available Documentation:
docs/detailed-guide-1.md- Detailed implementation guidedocs/detailed-guide-2.md- Detailed implementation guidedocs/detailed-guide-3.md- Detailed implementation guidedocs/detailed-guide-4.md- Detailed implementation guide
Cross-References
Related Skills:
- See PROJECT.md for complete skill dependencies
Related Tools:
- See documentation files for tool-specific guidance
Key Takeaways
- Research existing patterns before implementing
- Follow established best practices
- Refer to detailed documentation for implementation specifics
- Cross-reference related skills for comprehensive understanding