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

0•

Gestión de Bases de Datos

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

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

01Automated Flyway migration generation and validation patterns

020 GitHub stars

03Standardized database testing and rollback procedures

04Exposed ORM entity mapping and relationship configuration

05Query optimization and N+1 problem detection strategies

06Comprehensive schema design for tables, indexes, and constraints

Casos de Uso

01Designing and implementing a new relational database schema for a backend service

02Optimizing application performance through indexing and query plan analysis

03Managing complex schema evolutions and data migrations in production environments

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add angriff36/task-orchestrator database-implementation

For use in Claude.ai and ChatGPT

Download Skill