db-migration

Automate PostgreSQL migration file creation with SQL scripts and schema updates.

13|1|Updated Dec 22, 2020

Search Tags:#database #code generation #schema #migration #sql #jooq

Ready to run

npx skills add https://github.com/terraware/terraware-server --skill db-migration-terraware

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: db-migration
Source: https://github.com/terraware/terraware-server/tree/main/.claude/skills/db-migration
Command: npx skills add https://github.com/terraware/terraware-server --skill db-migration-terraware

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the process of creating and managing database schema changes, ensuring data integrity and consistency as the application evolves.

Core Features & Use Cases

Automated Migration File Generation: Creates new SQL migration files with proper naming conventions and directory structures.
Schema Documentation: Integrates schema documentation updates into the migration process.
Code Generation: Triggers necessary code generation steps (e.g., JOOQ) to reflect schema changes.
Use Case: When adding a new feature that requires new database tables and columns, use this Skill to generate the migration script, update documentation, and regenerate necessary code artifacts.

Quick Start

Use the db-migration skill to create a new database migration file.

Frequently Asked Questions about db-migration

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

FAQPage Schema

How do I automate database schema migration for PostgreSQL?▼

Database schema migration for PostgreSQL is automated by generating SQL migration files with proper numbering, updating schema documentation, and modifying Kotlin configurations to maintain consistent database evolution.

What is the best way to generate SQL migration scripts and update schema documentation?▼

Generating SQL migration scripts and updating schema documentation is handled by creating properly named migration files, inserting enum values, and integrating documentation updates directly into the migration workflow.

How does JOOQ code generation work with database schema changes?▼

JOOQ code generation is triggered automatically after creating database schema migration files, ensuring that the generated code accurately reflects the new tables and columns added during the migration process.

Can I manage PostgreSQL enum value insertion within a SQL migration file?▼

PostgreSQL enum value insertion is managed within the SQL migration file generation process, ensuring that schema changes including new enum types are applied idempotently and follow established conventions.

Does db-migration support idempotent SQL script generation for schema updates?▼

Idempotent SQL script generation for schema updates is supported, ensuring that repeated migration executions do not cause errors and that database schema changes remain maintainable across application versions.