Manages database schema design, Flyway migrations, and query optimization using Exposed ORM and SQL.
This skill provides specialized guidance for architecting and maintaining relational databases within a Claude Code environment. It streamlines the creation of SQL migrations, handles complex schema changes like junction tables and foreign key constraints, and optimizes query performance through strategic indexing. By integrating Flyway validation commands and Exposed ORM patterns, it ensures that database changes are reliable, testable, and follow industry best practices for data integrity and performance.
Key Features
01Query optimization strategies and indexing best practices
02Schema design patterns for complex relational models
03Automated Flyway migration generation and validation
04Integrated testing workflows for database repositories
050 GitHub stars
06Advanced troubleshooting for common migration blockers
Use Cases
01Optimizing slow database queries and fixing N+1 query problems
02Designing and implementing a new relational schema for a microservice
03Refactoring existing tables to add columns or constraints without data loss
