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

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

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

🦁 由 KingAI.Work 出品 — 智能进化｜[e-mail]

---

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