More screenshots
Works with the AI Agents you already use
Database & Migration Review: Safe Schema Changes
Review schemas, indexes and slow queries, and plan zero-downtime migrations with batching, locks, verification and rollback.
$12
Database & Migration Review: Safe Schema Changes
Example session with this skill installed
PostgreSQL 15, orders table with 40M rows. I need to add a NOT NULL column "currency" with default 'EUR'. Is ALTER TABLE safe?
- Read your context and instructions
- Compiled the database & migration
Summary: MEDIUM risk. Assumptions: PostgreSQL 15, rolling deploys, writes 200/s (verify on your version).\n\nPlan: 1) Expand: add currency as nullable (brief lock, set lock_timeout). 2) Deploy code that writes currency on insert. 3) Backfill in batches of 10k rows with short pauses, resumable. 4) Add a CHECK (currency IS NOT NULL) constraint as NOT VALID, then VALIDATE it. 5) Enforce NOT NULL. Rollback: drop the column until step 5.
Connects securely to your tools. The creator never sees your data.
About this skill
The migration you are about to run on Friday afternoon, reviewed first. This skill reviews your schema, indexes and queries, and turns risky database changes into a step-by-step plan you can run, verify and roll back.
What it covers
- Schema review: keys, foreign keys with indexes, exact money types, time zones, NOT NULL, unique and check constraints, multi-tenant keys, soft-delete traps, plain-text secrets
- Query and index tuning: reads the plan, finds sequential scans, wrong composite index order, functions on indexed columns, leading wildcards, OFFSET pagination, N+1 patterns. Suggests the smallest index that works and tells you its write cost
- Zero-downtime migrations with the expand and contract pattern: add, dual-write, batch backfill, switch reads, enforce, then remove later
- Lock awareness, lock and statement timeouts, staged NOT NULL, online index builds, batching with pauses
- A filled-in migration plan with lock level, verification query and rollback for every step, and the point of no return marked clearly
Honest: asks for your engine and version (PostgreSQL, MySQL/MariaDB, SQL Server, SQLite, Oracle), states its assumptions, says "verify on your version" when unsure, and requires a backup and restore test before anything destructive. It never runs changes against shared or production databases.
En español: revisa esquemas, índices y migraciones y planifica cambios sin caída. Responde en tu idioma.
Advice depends on engine, version, data size and traffic, which it asks for and states as assumptions. It does not connect to or change production databases, and cannot measure real performance without the plan or data you provide.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 6 days ago
Permissions
No special permissions declared or detected