Which database tools does this skill support?

This skill focuses on SQL database management, specifically utilizing Flyway for versioned migrations and the Exposed ORM for data mapping and queries.

Can this skill optimize my SQL queries?

Yes, it includes guidance on indexing strategies, analyzing query plans, and avoiding the N+1 query problem through proper JOIN usage.

What ORM patterns are included?

It features specific implementation patterns for the Exposed ORM, including UUID table definitions, foreign key references, and joined queries.

How does it help with failing migrations?

It provides specific patterns for common blockers, such as adding NOT NULL columns to existing data and resolving circular foreign key dependencies.

Does it include automated testing for databases?

Absolutely. The skill provides Gradle validation commands and Kotlin test templates to ensure migrations run correctly on clean databases and constraints are enforced.

Database Implementation

Name: Database Implementation
Author: jpicklyk

byjpicklyk

•

128

•

Database Management

Streamlines database schema design, Flyway migrations, and ORM integration for production-ready applications.

The Database Implementation skill provides specialized domain guidance for creating and maintaining robust database layers. It focuses on SQL schema design, sequential Flyway migrations, and ORM implementation using patterns like Kotlin's Exposed. By offering validated migration templates, query optimization strategies, and automated testing workflows, this skill helps developers eliminate common database bottlenecks such as circular dependencies, N+1 query problems, and data integrity issues during schema evolution.

Key Features

01Constraint validation and referential integrity enforcement

02Automated database integration and migration testing

03SQL query optimization and indexing best practices

04128 GitHub stars

05Exposed ORM table definitions and relationship mapping

06Flyway migration versioning and rollback strategies

Use Cases

01Identifying and fixing performance issues in SQL queries and ORM mappings

02Architecting new relational database schemas for backend services

03Executing complex schema refactors on tables with existing data

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jpicklyk/task-orchestrator database-implementation

For use in Claude.ai and ChatGPT

Download Skill