Can it help with slow database performance?

Yes, it includes guidance on indexing strategies for foreign keys and frequently queried columns, as well as query optimization patterns for JOINs.

Does it support rollback strategies?

Yes, it provides guidance on creating reversible migrations and documenting rollback SQL to ensure database stability.

How does it handle migration validation?

It utilizes Flyway commands via Gradle, such as flywayValidate and flywayInfo, to ensure migrations are correctly sequenced and applied.

Which ORMs does this skill support?

The skill provides specific patterns for JetBrains Exposed ORM, but the SQL migration and schema design logic are applicable to JPA, Hibernate, and other relational libraries.

What happens if a migration fails on existing data?

The skill includes specific patterns for 'safe' migrations, such as adding nullable columns first and updating existing rows before applying NOT NULL constraints.

Database Implementation & Migrations

Name: Database Implementation & Migrations
Author: Angriff36

byAngriff36

Database Management

Manages database schema design, Flyway migrations, and query optimization using Exposed ORM and SQL.

About

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

Query optimization strategies and indexing best practices
Schema design patterns for complex relational models
Automated Flyway migration generation and validation
Integrated testing workflows for database repositories
0 GitHub stars
Advanced troubleshooting for common migration blockers

Use Cases

Optimizing slow database queries and fixing N+1 query problems
Designing and implementing a new relational schema for a microservice
Refactoring existing tables to add columns or constraints without data loss

About

Key Features

Query optimization strategies and indexing best practices
Schema design patterns for complex relational models
Automated Flyway migration generation and validation
Integrated testing workflows for database repositories
0 GitHub stars
Advanced troubleshooting for common migration blockers

Use Cases

Optimizing slow database queries and fixing N+1 query problems
Designing and implementing a new relational schema for a microservice
Refactoring existing tables to add columns or constraints without data loss