← All skills

db-migration-mysql-postgres

80 / 100 · Low risk

Fine to try.

By MadBomber/experiments (GitHub) · data · 11 stars · scanned at commit 8139ff6

Migrate a Ruby on Rails application's primary database from MySQL to PostgreSQL — schema upgrades (JSON to JSONB for queryability, ENUMs to native types or check constraints, TINYINT to BOOLEAN, case-sensitivity changes), data export/import via pgloader, the dual-write cutover pattern, the gem switch (mysql2/trilogy to pg), Rails-side caveats. Use when migrating from MySQL to Postgres, the user mentions pgloader, JSONB upgrade, ENUM migration, TINYINT to BOOLEAN, or asks how to move a Rails app…

Works with any agent that supports SKILL.md skills.

What this skill can do

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'db-migration-mysql-postgres' ] || [ -L ~/.agents/skills/'db-migration-mysql-postgres' ]; then echo 'A skill folder named db-migration-mysql-postgres already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/MadBomber/experiments' "$d" && git -C "$d" checkout --quiet '8139ff68e8895b544661aa2ba8b53268d68652bc' -- 'ai_misc/skills/rails-skills/22-db-migration-mysql-postgres' && mkdir -p ~/.agents/skills && cp -R "$d"/'ai_misc/skills/rails-skills/22-db-migration-mysql-postgres' ~/.agents/skills/'db-migration-mysql-postgres' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'db-migration-mysql-postgres' ~/.claude/skills/'db-migration-mysql-postgres' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for MadBomber/experiments shows the score of its lowest-scoring skill.

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/MadBomber/experiments.svg)](https://zalavijaysinh.github.io/skilltrust/repos/MadBomber/experiments/)

Score history