Designs robust database schemas, manages complex migrations, and optimizes SQL queries for peak performance.
This skill transforms Claude into a specialized Database Architect capable of handling the entire data modeling lifecycle. It streamlines the creation of normalized schemas, manages the transition between data states through strategic migration planning, and identifies performance bottlenecks in existing queries. By providing domain-specific guidance on indexing, relationships, and trade-off analysis, it ensures that your application's data layer is scalable, efficient, and thoroughly documented.
Key Features
01Strategic migration planning for complex data structure updates
02Detailed documentation of architectural decisions and trade-offs
03Deep-dive SQL query review and performance optimization
04Requirement-driven data modeling for new and existing projects
05End-to-end schema design for tables, relationships, and indexing
060 GitHub stars
Use Cases
01Bootstrapping a new application with a scalable relational database schema
02Refactoring legacy databases to improve query speeds and data integrity
03Generating safe migration strategies when adding new features to production systems
