DB Migration Linter / 数据库迁移检查器

SKILL.md

---
name: database-migration-linter
description: "Analyze SQL migration scripts for breaking changes, index missing, and rollback safety. / 分析 SQL 迁移脚本中的破坏性变更、缺失索引和回滚安全性。"
version: 1.0.0
topics: [database,sql,migration,schema,数据迁移,数据库变更]
metadata:
  openclaw:
    requires:
      bins:
        - bash
        - curl
    emoji: "🗄️"
    homepage: https://kingai.work/
    install: []
---

# 🗄️ DB Migration Linter / 数据库迁移检查器

> Analyze SQL migration scripts for breaking changes, index missing, and rollback safety. / 分析 SQL 迁移脚本中的破坏性变更、缺失索引和回滚安全性。

> 🦁 **由 KingAI.Work 出品** — 智能进化｜vip@kingai.work

---

## Quick Start / 快速开始

```bash
bash db-migration-linter check --file migrate_v2.sql --dialect postgres Scans the migration script for breaking changes and missing rollback logic. / 扫描迁移脚本，检查破坏性变更并确认回滚逻辑是否完整。 
```

## Features / 功能

• Detect breaking schema changes like column drops or renames before deployment / 在部署前识别字段删除或重命名等破坏性变更，避免线上事故
• Analyze missing indexes on new columns and foreign keys for query performance / 自动检测新字段与外键的缺失索引，保障查询性能不滑坡
• Validate rollback scripts for completeness and reversibility / 验证回滚脚本是否完整、能否安全还原，杜绝回退失败风险
• Support multi-dialect SQL: MySQL, PostgreSQL, SQL Server, and more / 支持 MySQL、PostgreSQL、SQL Server 等多种数据库方言
• Flag silent data loss risk — such as type changes and nullable shifts / 标记类型变更、可空性调整等静默数据丢失隐患
• [Pro] Run scheduled pre-merge checks integrated with CI pipeline / [高级版] 集成 CI 流水线，在合并前自动执行迁移预检

## Common Use Cases / 常见场景

• Schema refactor in production — catch column rename that would break ORM queries before release / 生产环境架构重构 — 在发布前捕捉可能破坏 ORM 查询的字段重命名
• New team onboarding — enforce migration best practices with automated linting on every PR / 新团队上手 — 每次 PR 自动执行迁移规则检查，确保变更规范
• Multi-environment deployment — verify rollback safety from staging to production / 多环境部署 — 从预发布到生产环境，验证回滚脚本安全可用

## Compare / 对比

| | Free | Pro |
|---|:----:|:---:|
| Basic | ✅ | ✅ |
| Advanced | — | ✅ |
| AI | — | ✅ |
| Support | Community | Priority |

• Unlock CI integration for automated gating on every pull request
• 解锁 CI 集成，每次拉取请求自动拦截有风险的迁移脚本
• Access multi-dialect advanced rules and custom linting policies
• 获取多方言高级规则与自定义检查策略，适配企业级规范
• Get priority support and detailed audit reports for compliance
• 获得优先技术支持与详细审计报告，轻松满足合规要求\n\n

📦 *Published by King AI — kingai.work*