How does this skill handle performance optimization?

It provides specific guidance on indexing strategies for foreign keys and frequently queried columns, as well as techniques for analyzing query plans.

Can this skill help fix failed migrations?

Yes, it includes troubleshooting guides for common blockers like adding NOT NULL columns to existing data and resolving circular foreign key dependencies.

Which database tools does this skill support?

This skill is optimized for SQL databases using Flyway for migrations and the Exposed ORM, though the general SQL patterns apply to most relational systems.

Does it provide automated testing patterns?

Absolutely. It includes standardized Gradle commands and Kotlin testing patterns to validate migration execution and database constraints.

Database Implementation

Name: Database Implementation
Author: Angriff36

byAngriff36

Gestión de Bases de Datos

Streamlines database schema design, automated Flyway migrations, and SQL query optimization within the Claude Code environment.

Acerca de

The Database Implementation skill provides specialized guidance for managing the complete database lifecycle, from initial schema design to production-grade migrations and performance tuning. It focuses on SQL best practices, Flyway migration versioning, and Exposed ORM integration, offering robust patterns for entity relationships, constraints, and indexes. By incorporating automated validation commands and rollback strategies, this skill ensures that database changes are reliable, testable, and optimized for high-performance applications.

Características Principales

Automated Flyway migration generation and validation patterns
0 GitHub stars
Standardized database testing and rollback procedures
Exposed ORM entity mapping and relationship configuration
Query optimization and N+1 problem detection strategies
Comprehensive schema design for tables, indexes, and constraints

Casos de Uso

Designing and implementing a new relational database schema for a backend service
Optimizing application performance through indexing and query plan analysis
Managing complex schema evolutions and data migrations in production environments

Acerca de

Características Principales

Automated Flyway migration generation and validation patterns
0 GitHub stars
Standardized database testing and rollback procedures
Exposed ORM entity mapping and relationship configuration
Query optimization and N+1 problem detection strategies
Comprehensive schema design for tables, indexes, and constraints

Casos de Uso

Designing and implementing a new relational database schema for a backend service
Optimizing application performance through indexing and query plan analysis
Managing complex schema evolutions and data migrations in production environments