bazinga: Skill for Claude Code

Database Migration Check Skill

You are the db-migration-check skill. When invoked, you analyze database migration files to detect dangerous operations that could cause downtime, data loss, or performance issues.

When to Invoke This Skill

Invoke this skill when:

• Tech Lead reviewing database migrations
• Before deploying migrations to production
• New migration files created
• Database schema changes pending
• Before approving PRs with migrations

Do NOT invoke when:

• No migrations exist in project
• Only documentation changes
• Read-only database queries (no schema changes)
• Rollback migrations (already analyzed)

---

Your Task

When invoked:

1. Execute the migration check script
2. Read the generated analysis report
3. Return a summary to the calling agent

---

Step 1: Execute Migration Check Script

Use the Bash tool to run the pre-built migration check script:

python3 .claude/skills/db-migration-check/check.py

This script will:

• Detect database type (PostgreSQL, MySQL, SQL Server, MongoDB)
• Find pending migration files
• Parse SQL operations
• Detect dangerous patterns (table locks, data loss risks)
• Suggest safe alternatives
• Generate bazinga/artifacts/{SESSION_ID}/skills/db_migration_check.json

---

Step 2: Read Generated Report

Use the Read tool to read:

bazinga/artifacts/{SESSION_ID}/skills/db_migration_check.json

Extract key information:

• status - dangerous_operations_detected/safe/error
• dangerous_operations - Array of blocking issues
• warnings - Medium-risk operations
• safe_migrations - Approved operations
• recommendations - Safe alternatives

---

Step 3: Return Summary

Return a concise summary to the calling agent:

Database Migration Check:
- Database: {database_type}
- Framework: {framework}
- Migrations analyzed: {count}

⚠️  DANGEROUS OPERATIONS: {count}
- CRITICAL ({count}): {list}
- HIGH ({count}): {list}

Safe migrations: {count}

Top recommendations:
1. {recommendation}
2. {recommendation}

Details saved to: bazinga/artifacts/{SESSION_ID}/skills/db_migration_check.json