How febrifelis/migrasafe works
migrasafe is a SQL-migration safety checker: an engineer or CI job submits migration files, and the CLI scans them, reports risks and suggested fixes, and exits with a safety status. The main path parses SQL into statements, applies visitor-based checks with rule fallbacks, enriches findings, and builds scan-level risk and dependency results for output. The repository also documents dashboards, policy and approval workflows, plugin rules, coverage reporting, and an AI suggestion capability. Connections for unsampled features are included only where the README or indexed source references support them.
Main entry points: index.ts CLI commands · pipeline.ts Rule pipeline · checker.ts File and directory checks · risk.ts Scan risk scoring
Components 31
User interfaces
- CLI commands
src/index.ts
Migration scanning
- File and directory checks
src/checker/checker.ts - SQL parser
src/ast/parser.ts - SQL lexer
src/ast/lexer.ts - Rule pipeline
src/engine/pipeline.ts - Statement visitors
src/engine/visitors/alter.ts - Built-in rules
src/checker/rules.ts - Plugin rules
src/plugins/loader.ts - Configuration
src/config.ts
Risk analysis
- Semantic analysis
src/analysis/semantic.ts - Dependency graph
src/analysis/graph.ts - Scan risk scoring
src/engine/risk.ts - Lock analysis
src/analysis/lock.ts - Rollback analysis
src/analysis/rollback.ts - Cost analysis
src/analysis/cost.ts - Rewrite analysis
src/analysis/rewrite.ts - Affected objects
src/analysis/objects.ts
Reporting and policy
- Result formatting
src/output/formatter.ts - AI suggestions
src/ai/suggestions.ts - Dashboard generator
src/dashboard/generator.ts - Scan history
src/dashboard/history.ts - Policy evaluation
src/enterprise/policy.ts - Approval requests
src/enterprise/approval.ts - Notifications
src/enterprise/notifications.ts - Rule coverage report
src/coverage/index.ts - Rule catalog
src/catalog/index.ts
Editor integration
- VS Code extension
vscode-extension/src/extension.ts - Editor diagnostics
vscode-extension/src/diagnostics.ts - Scan runner
vscode-extension/src/runner.ts - Code actions
vscode-extension/src/codeActions.ts
Other components
- Engineer or CI
Connections 36
- Engineer or CI → CLI commands: runs checks
- CLI commands → File and directory checks: scans files
src/index.ts - File and directory checks → SQL parser: parses statements
src/checker/checker.ts - SQL parser → SQL lexer: tokenizes SQL
src/ast/parser.ts - File and directory checks → Rule pipeline: checks statements
src/checker/checker.ts - Rule pipeline → Statement visitors: dispatches visits
src/engine/pipeline.ts - Rule pipeline → Built-in rules: checks fallback rules
src/engine/pipeline.ts - File and directory checks → Plugin rules: loads plugin rules
src/checker/checker.ts - Plugin rules → Built-in rules: validates rules
src/plugins/loader.ts - File and directory checks → Semantic analysis: analyzes statements
src/checker/checker.ts - File and directory checks → Dependency graph: builds dependencies
src/checker/checker.ts - File and directory checks → Scan risk scoring: computes scan risk
src/checker/checker.ts - Rule pipeline → Lock analysis: analyzes locks
src/engine/pipeline.ts - Rule pipeline → Rollback analysis: assesses rollback
src/engine/pipeline.ts - Rule pipeline → Cost analysis: estimates cost
src/engine/pipeline.ts - Rule pipeline → Rewrite analysis: analyzes rewrites
src/engine/pipeline.ts - Rule pipeline → Affected objects: finds affected objects
src/engine/pipeline.ts - Scan risk scoring → Lock analysis: uses scores
src/engine/risk.ts - Scan risk scoring → Rollback analysis: uses scores
src/engine/risk.ts - Scan risk scoring → Cost analysis: uses estimates
src/engine/risk.ts - Scan risk scoring → Rewrite analysis: uses estimates
src/engine/risk.ts - CLI commands → Result formatting: formats results
src/index.ts - CLI commands → Configuration: loads settings
src/index.ts - CLI commands → Scan history: loads history
src/index.ts - CLI commands → Dashboard generator: generates dashboard
src/index.ts - Dashboard generator → Scan history: renders history
src/dashboard/generator.ts - CLI commands → Policy evaluation: evaluates policy
src/index.ts - CLI commands → Approval requests: generates requests
src/index.ts - CLI commands → Notifications: uses notifications
src/index.ts - CLI commands → AI suggestions: requests suggestions
src/index.ts - CLI commands → Rule coverage report: reports coverage
src/index.ts - CLI commands → Rule catalog: builds catalog
src/index.ts - VS Code extension → Editor diagnostics: registers diagnostics
vscode-extension/src/extension.ts - VS Code extension → Code actions: registers actions
vscode-extension/src/extension.ts - Editor diagnostics → Scan runner: runs scan
vscode-extension/src/diagnostics.ts - Engineer or CI → VS Code extension: uses editor