skills.rest
AdamAwan
AdamAwanCOMMUNITY
Explore all skills by this author →
GitHub

write-a-migration

Generate Postgres migration files for Markdown Magpie's custom SQL migrator.

Updated Jun 11, 2026
Search Tags:#SQL#database migration#development automation#Postgres#Markdown Magpie
One-click install
npx skills add https://github.com/AdamAwan/markdown-magpie --skill write-a-migration
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: write-a-migration
Source: https://github.com/AdamAwan/markdown-magpie/tree/main/.claude/skills/write-a-migration
Command: npx skills add https://github.com/AdamAwan/markdown-magpie --skill write-a-migration

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill automates the creation of database migrations for Markdown Magpie, simplifying the process of adding, altering, or backfilling Postgres tables, columns, indexes, and constraints.

Core Features & Use Cases

  • Automated Migration Creation: Generates migration files following Markdown Magpie's naming conventions and rules.
  • Custom SQL Migrator: Uses Markdown Magpie's custom SQL migrator to apply migrations.
  • Use Case: When you need to add a new column to a table, this Skill can create the necessary migration file with the correct naming and content.

Quick Start

Generate a new migration for adding a 'status' column to the 'users' table with the description 'User account status'.

Frequently Asked Questions about write-a-migration

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

FAQPage Schema
How do I automate database migration creation for Postgres tables and columns?▼

Automating database migration creation for Postgres involves generating SQL files with correct naming and content to add, alter, or backfill tables, columns, indexes, and constraints without manual file setup.

What is a SQL database migration file and when do I need one?▼

A SQL database migration file is a script that applies schema changes like adding columns or altering constraints to a database. You need one whenever you modify a Postgres database schema.

How do I create a migration file to add a new column to an existing table?▼

To create a migration file for adding a new column, you generate a file following specific SQL migrator naming conventions, containing the appropriate ALTER TABLE statements to add the column.

Can I use a custom SQL migrator to backfill Postgres database indexes and constraints?▼

Yes, you can use a custom SQL migrator to backfill Postgres database indexes and constraints by generating migration files that adhere to the migrator's specific naming rules and content requirements.

Do I need to follow specific naming conventions when automating SQL migration files?▼

Yes, automating SQL migration files requires strict adherence to specific naming conventions defined by the custom migrator script to ensure the database changes are recognized and applied correctly.

Related Skills

Explore More Software Engineering Skills→
fsollafsolla

payload-migrations

Generate, verify, and apply Payload CMS schema migrations to Postgres databases.

Community
Advanced
Xipher-LabsXipher-Labs
6

data-migration-safety

Review Postgres and Supabase migration files for reversibility, lock duration, and RLS correctness.

Official
Advanced
HeldinhowHeldinhow
4

database-migrations

Manage database schema changes through version-controlled migration scripts.

Community
Intermediate
4lerman4lerman

sql-database-assistant

Generate SQL queries, introspect schemas, optimize performance, and create migration scripts.

Community
Advanced