skills.rest
terraware
terrawareOFFICIAL
Explore all skills by this author →
Website𝕏@GlobalTerraformGitHub

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
One-click install
npx skills add https://github.com/terraware/terraware-server --skill db-migration-terraware
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
JaiminVadadoriyaJaiminVadadoriya
1

database-testing

Validate database integrity and test forward and backward migrations.

Community
Advanced
wfukatsuwfukatsu
12

migrate-postgresql

Migrate PostgreSQL schemas to ScalarDB with compatibility checks and Java code generation.

Community
Advanced
DexploarerDexploarer
7

drizzle-migration

Generate and apply Drizzle Kit SQL migrations from TypeScript schema changes.

Community
Intermediate
yaresimeonthomasyaresimeonthomas

writing-migrations

Generate idempotent Supabase SQL migrations from session branch code diffs.

Community
Advanced