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

データベース管理

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.

主な機能

Constraint validation and referential integrity enforcement
Automated database integration and migration testing
SQL query optimization and indexing best practices
128 GitHub stars
Exposed ORM table definitions and relationship mapping
Flyway migration versioning and rollback strategies

ユースケース

Identifying and fixing performance issues in SQL queries and ORM mappings
Architecting new relational database schemas for backend services
Executing complex schema refactors on tables with existing data

概要

主な機能

Constraint validation and referential integrity enforcement
Automated database integration and migration testing
SQL query optimization and indexing best practices
128 GitHub stars
Exposed ORM table definitions and relationship mapping
Flyway migration versioning and rollback strategies

ユースケース

Identifying and fixing performance issues in SQL queries and ORM mappings
Architecting new relational database schemas for backend services
Executing complex schema refactors on tables with existing data