Works with the AI tools you already use
Database Migration Safety Reviewer
by heyhridyansh
Audit database migrations for production safety, locking risks, and zero-downtime compatibility.
Free
See it in action
You say
Review this Postgres migration adding a NOT NULL column 'user_tier' to a 'users' table with 50M rows. Current strategy: ALTER TABLE users ADD COLUMN user_tier text NOT NULL DEFAULT 'free';
Your agent does
Verdict: Do not run. Score: 45/100. Risk: Adding a column with a default value to a 50M row table will trigger a full table rewrite and an Access Exclusive lock. Correction: Add column as nullable, deploy code to handle nulls, backfill in batches, then add the constraint.
About this skill
The problem
Applying database migrations to production often leads to table locking, downtime, or application crashes during rolling deployments. Manual reviews frequently miss backward compatibility issues that only surface when old and new application versions run simultaneously.
What it does
- Identifies blocking DDL operations and long-running table rewrites that cause production outages.
- Validates backward and forward compatibility for mixed-version application deployments.
- Audits backfill scripts for idempotency, batching, and replication lag risks.
- Sequences constraint enforcement and index creation to prevent data integrity failures.
- Generates a step-by-step corrected migration plan with rollback and repair procedures.
Why this beats prompting it yourself
General-purpose LLMs often suggest "technically correct" SQL that is operationally fatal on large tables. This skill applies a specific safety rubric to check for lock duration, transaction boundaries, and partial-failure states that generic prompts overlook.
Use cases
- Reviewing zero-downtime schema changes for high-traffic Postgres or MySQL databases.
- Planning complex table splits, merges, or column renames without service interruption.
- Auditing large-scale data backfills to ensure they are resumable and rate-limited.
- Validating migration safety before a critical production release.
Known limitations
Cannot execute migrations or connect to live databases. Runtime estimates are static and unverified without production metrics.
How to install
Drop the file into your AI Agent. Works with Claude, Cursor, ChatGPT, and 20+ more.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill passes our trust checks below.
Security scanned
Passed our 8-point scan before listing
Fresh listing
Recently published to Agensi
Free forever
No account required to browse
Trust & safety
Security scanned
Verified clean today
- Free to download with an account
Creator
9 skills on Agensi
I create practical, AI-ready skills for Cursor, Claude Code, Codex CLI, Replit, and other agents that support the SKILL.md format. My skills focus on specific business and workflow problems, including ecommerce creative audits, design quality checks, prompt and skill validation, content systems, and process automation. Each skill is built with clear inputs, structured outputs, defined permissions, safeguards, and real-world usability.
Frequently Asked Questions
Popular in DevOps & Deployment
env-doctor-advanced
Automated environment audit to fix configuration gaps, detect secret leaks, and solve "works on my machine" issues.
gitignore-generator
Automatically generate, audit, and repair .gitignore files to prevent secrets leakage and repository pollution.
agent-team-orchestrator
Teaches AI agents (Claude Code, Cursor, Codex CLI) to set up, dispatch, and coordinate multi-agent workflows using the `claude agents` command. Covers agent role definition, handoff protocols, paralle
env-doctor
Diagnoses why your project will not start. Checks runtime versions, dependencies, environment variables, databases, ports, and build artifacts systematically.