migration-db
OfficialMigrate to shared PostgreSQL with safety checks
Software Engineering#postgresql#database migration#rbac#secrets management#docker compose#alembic#pgbouncer
AuthorAscenseurs-Menetrey-SA
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill helps teams migrate an application to the shared PostgreSQL database (db_commune) while preventing destructive conflicts like duplicate schemas, roles, PgBouncer aliases, or secrets.
Core Features & Use Cases
- Pre-migration discovery: Inspects the source app (Alembic + Docker compose) and the target db_commune (roles, schemas, grants, PgBouncer, secrets) to understand the current state.
- Conflict detection and guardrails: Blocks the migration when shared Phase 2 prerequisites are missing or when duplicates are detected; allows progress with warnings otherwise.
- Idempotent db_commune updates: Creates the application RBAC roles and schema, wires PgBouncer routing, updates docker-compose secrets references, and sets passwords and grants safely.
- Application integration: Attaches the db_commune network to the app, configures Alembic to use schemas, and documents the correct DATABASE_URL patterns for PgBouncer and migrations.
Quick Start
Ask the AI to run the migration for your app directory by providing the app name and absolute path, using the optional db_commune directory if needed.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: migration-db Download link: https://github.com/Ascenseurs-Menetrey-SA/amsa-claude-skills/archive/main.zip#migration-db Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.