How does it handle complex migration blockers?

It includes strategies for common issues like adding NOT NULL columns to existing data, circular dependencies, and long-running index creations.

Is this skill specific to a certain SQL dialect?

While the patterns are generally applicable to SQL, the examples and commands are highly compatible with PostgreSQL and standard relational databases.

Which database migration tools are supported?

The skill is optimized for Flyway migrations, including commands for migration, cleaning, validation, and status checking.

Can this skill help with ORM integration?

Yes, it provides specific patterns for the Exposed ORM, including table definitions, foreign key relationships, and join queries.

Database Implementation

Name: Database Implementation
Author: jpicklyk

byjpicklyk

•

128

数据库管理

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

关于

This skill provides Claude with domain-specific guidance for robust database management, focusing on schema design, migrations, and performance tuning. It facilitates reliable data modeling through sequential migration patterns, ORM entity mapping, and referential integrity management. By leveraging automated validation commands for Flyway and predefined rollback strategies, it ensures database changes are safe, testable, and optimized for performance. It is particularly useful for projects requiring persistent storage, complex relational modeling, or high-performance query execution.

主要功能

128 GitHub stars
Exposed ORM mapping and entity relationship patterns
Advanced troubleshooting for common database blockers and circular dependencies
Sequential migration versioning and Flyway lifecycle management
Automated migration validation and integration testing commands
SQL schema design with optimized indexing and constraints

使用场景

Implementing complex many-to-many relationships and foreign key constraints in ORMs
Optimizing application performance through query analysis and indexing strategies
Designing and executing zero-downtime schema migrations for production databases

关于

主要功能

128 GitHub stars
Exposed ORM mapping and entity relationship patterns
Advanced troubleshooting for common database blockers and circular dependencies
Sequential migration versioning and Flyway lifecycle management
Automated migration validation and integration testing commands
SQL schema design with optimized indexing and constraints

使用场景

Implementing complex many-to-many relationships and foreign key constraints in ORMs
Optimizing application performance through query analysis and indexing strategies
Designing and executing zero-downtime schema migrations for production databases