- Home
- Skills
- Data & Databases
- ๐๏ธ SQL Migration Safety Doctor
More screenshots
Works with the AI Agents you already use
๐๏ธ SQL Migration Safety Doctor
Review DROP, TRUNCATE, type changes, NOT NULL additions, unfiltered writes, renames, indexes, constraints and mixed backfill patterns.
$12
๐๏ธ SQL Migration Safety Doctor
Example session with this skill installed
Review this illustrative SQL text without executing it: CREATE INDEX idx_user_email ON users(email); Explain the potential risk and what must be verified for the target engine.
- Read your context and instructions
- Compiled the sql migration safety
Illustrative review โ not a database execution
Potential finding: non-concurrent index creation. The SQL creates an index without the PostgreSQL CONCURRENTLY option. This is a static review prompt, not a measured production lock event.
What to verify
- Confirm the target engine and version; CONCURRENTLY is PostgreSQL-specific.
- Review table size, expected writes, transaction context and deployment window.
- If PostgreSQL is the target, assess whether a concurrent build is supported and appropriate.
- Confirm failure recovery and rollback handling separately.
Limits
No SQL was executed, no database was connected, and no lock duration or affected-row count was measured. Do not treat this example as authorization to deploy or as a guaranteed-safe rewrite.
Connects securely to your tools. The creator never sees your data.
About this skill
What you get
A local Python scanner for selected risky SQL patterns, with file-and-line findings and a manual review checklist. It identifies patterns to investigate, not confirmed database defects or guaranteed-safe rewrites.
How to use it
Provide local migration SQL files or a folder. Review DROP, TRUNCATE, type changes, NOT NULL additions, unfiltered writes, renames, indexes, constraints and mixed backfill patterns. Then check the target database engine, deployment order, rollback feasibility and actual data impact.
Boundaries
This is not a complete SQL parser, database connection, lock-duration estimator or deployment gate. PostgreSQL, MySQL and SQLite differ; proposed changes require engine-specific review. A WHERE clause or DEFAULT does not prove safety.
Verified release scope
Package v1.0.1 was retrieved through Agensi creator access and tested in Claude on Linux with Python 3.13: 30 bundled tests and the fixture check passed. All 12 captured files match the sealed release, allowing one disclosed trailing-newline normalization. This is not a paid-buyer checkout test or universal host certification. Reports omit source excerpts but retain file paths; review sensitive output locally.
Find more skills like this on the Claude Skills Marketplace, the Codex Skills Marketplace and the Gemini Skills Marketplace, or browse Claude Skills for Data & Databases.
Static heuristics, not a complete SQL parser or database safety proof. No database connection, lock measurement, affected-row estimate or verified rollback. v1.0.1 omits source excerpts but reports paths. Ambiguous or incomplete inputs require review. Windows junctions and hosts beyond the documented test environment remain unverified. Creator-delivery text capture is not paid-buyer checkout or raw ZIP-byte verification.
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 buying a skill.
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 today
- Software
Python
Python 3.10+ and authorized local SQL files are required. Missing runtime or files means the scan is unperformed, not clean. v1.0.1 creator-delivery tests passed on Linux/Python 3.13; other hosts need verification.
Permissions
File Scopes
Read-only inspection first. The bundled scanner reads matching .sql files and prints markdown or JSON findings. It installs nothing, transmits nothing, modifies nothing, and never connects to a database. Any write, install, deploy, or live-account action requires explicit user confirmation.