lookup-migration

Inspect Flyway migration scripts to verify database schemas.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/semicolon-devteam/sax-backend --skill lookup-migration
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: lookup-migration
Source: https://github.com/semicolon-devteam/sax-backend/tree/main/skills/lookup-migration
Command: npx skills add https://github.com/semicolon-devteam/sax-backend --skill lookup-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines database interaction by providing instant access to Flyway migration scripts, eliminating the manual effort of inspecting DB schemas and mapping them to Kotlin entities. It ensures consistency between your database and application code, saving development time and preventing schema-related errors.

Core Features & Use Cases

  • Schema Discovery: Query core-supabase Flyway migrations to understand table structures and column definitions.
  • Kotlin Entity Mapping Guidance: Provides clear mapping rules from PostgreSQL types to Kotlin R2DBC types, including UUID, Instant, and String for enums.
  • Entity Suggestion: Generates boilerplate Kotlin entity code based on the retrieved schema, accelerating the v0.3.x DATA phase of implementation.

Quick Start

Look up the migration script for the 'posts' table to see its schema.

Frequently Asked Questions about lookup-migration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I map PostgreSQL database columns to Kotlin entity properties?

Map PostgreSQL columns to Kotlin entities by examining Flyway migration scripts to identify table structures and column types, then apply SQL-to-R2DBC type conversion rules (UUID, Instant, String) and convert snake_case column names to camelCase property names for R2DBC entity classes.

Can I use Flyway migrations to validate my Kotlin entity schema?

Yes. Query Flyway migration scripts to inspect database schemas and verify they match your Kotlin entity definitions, ensuring consistency between your application code and database structure before implementing repositories or creating new entities.

How do I handle database enums in Kotlin R2DBC entities?

Database enums are mapped to Kotlin entities as String constants, as specified in R2DBC type-mapping requirements. Inspect the Flyway migration script defining the enum column to understand its possible values and constraints.

What's the fastest way to generate Kotlin entity boilerplate from my database schema?

Look up your table's Flyway migration script to retrieve the schema structure, then use the provided entity-suggestion guidance to generate boilerplate Kotlin entity code with correct type mappings and property naming, accelerating the data phase of implementation.

Do I need to manually inspect migration files to understand my database structure?

No. This Skill queries Flyway migrations automatically to retrieve and present table structures and column definitions, eliminating manual inspection and providing instant schema discovery for entity design and validation.