Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Get Started Free →

SQL Database Migration Strategy and Implementation · dokhacgiakhoa | DecimalAI

databy dokhacgiakhoa

SQL Database Migration Strategy and Implementation

dokhacgiakhoa/database-migrations-sql-migrations

Source dokhacgiakhoa/agent-skills-4-vibe-coding-cli ↗License NOASSERTION

SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server

SkillScore68Maintained

Automatic

Data Engineer pack

Last verified 8/29/2026

What it changes

Passed 15 of 22 test cases with the skill, and 13 of 22 without it.

Without skill59%

With skill68%

Checks it passed that the model alone missed

Pre-migration validation scripts check for orphaned or invalid status values.
Verification queries ensure non-null record count integrity after encryption.
The package includes a rollback plan to reverse the archival if data validation fails.

and 2 more in the full report

4 fixed11 passed either way5 still failing2 broke

Pass-rate lift: +9 pp
Tokens: +38%
Agent turns: 0%
Response time: +41%

Model gemini-3.6-flashMeasured 8/29/2026v115 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/dokhacgiakhoa-database-migrations-sql-migrations/SKILL.md https://app.decimal.ai/s/dokhacgiakhoa-database-migrations-sql-migrations/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add dokhacgiakhoa-database-migrations-sql-migrations, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/dokhacgiakhoa-database-migrations-sql-migrations/ and pins it in .decimal/skills.lock

decimalai skills add dokhacgiakhoa-database-migrations-sql-migrations

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/dokhacgiakhoa-database-migrations-sql-migrations/SKILL.md https://app.decimal.ai/s/dokhacgiakhoa-database-migrations-sql-migrations/SKILL.md

Raw file: /s/dokhacgiakhoa-database-migrations-sql-migrations/SKILL.md ↗ · machine-readable summary at /s/dokhacgiakhoa-database-migrations-sql-migrations.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 4 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 4

Prompt

We need to migrate historical audit logs older than 3 years from a high-frequency SQL Server table `system_logs` into an archive table `system_logs_archive`. Direct DELETE queries are locking the table. Provide the zero-downtime migration strategy and full deliverables.

What was checked, without and with the skill
Checked	Without skill	With skill
The implementation uses SQL Server partition switching or batched chunk deletions.	Passed	Passed
The package includes a rollback plan to reverse the archival if data validation fails.	Missed	Passed
The output includes performance optimization measures to avoid transaction log bloat.	Passed	Passed

case-04 · gemini-3.6-flash · 8/29/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md47 linessingle file

SQL Database Migration Strategy and Implementation

You are a SQL database migration expert specializing in zero-downtime deployments, data integrity, and production-ready migration strategies for PostgreSQL, MySQL, and SQL Server. Create comprehensive migration scripts with rollback procedures, validation checks, and performance optimization.

Use this skill when

Working on sql database migration strategy and implementation tasks or workflows
Needing guidance, best practices, or checklists for sql database migration strategy and implementation

Do not use this skill when

The task is unrelated to sql database migration strategy and implementation
You need a different domain or tool outside this scope

Context

The user needs SQL database migrations that ensure data integrity, minimize downtime, and provide safe rollback options. Focus on production-ready strategies that handle edge cases, large datasets, and concurrent operations.

Requirements

$ARGUMENTS

Instructions

Clarify goals, constraints, and required inputs.
Apply relevant best practices and validate outcomes.
Provide actionable steps and verification.
If detailed examples are required, open resources/implementation-playbook.md.

Output Format

Migration Analysis Report: Detailed breakdown of changes
Zero-Downtime Implementation Plan: Expand-contract or blue-green strategy
Migration Scripts: Version-controlled SQL with framework integration
Validation Suite: Pre and post-migration checks
Rollback Procedures: Automated and manual rollback scripts
Performance Optimization: Batch processing, parallel execution
Monitoring Integration: Progress tracking and alerting

Focus on production-ready SQL migrations with zero-downtime deployment strategies, comprehensive validation, and enterprise-grade safety mechanisms.

Resources

Track record

Benchmark

15 / 22

test cases passed, vs 13 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/10/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

dokhacgiakhoa / agent-skills-4-vibe-coding-cli

.agent/skills/database-migrations-sql-migrations/SKILL.md

View on GitHub ↗

License NOASSERTIONImported 8/10/2026Version v1

Other skills for the same job

Published skills whose descriptions closely match this one, with their headline benchmark lift.

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

SQL Database Migration Strategy and Implementation

Use this skill when

Do not use this skill when

Context

Requirements

Instructions

Output Format

Resources

Track record

Benchmark

Adoption

SkillSafety

Source

Other skills for the same job

Related skills