Squawk vs MigrationPilot: PostgreSQL Migration Linters Compared

Squawk and MigrationPilot are both open-source PostgreSQL migration linters. Both analyze SQL files for dangerous operations and both integrate with CI. But they differ significantly in approach, rule depth, and what information they give you. This comparison is published on the MigrationPilot blog — take that into account and verify claims against the source code of both tools. Quick Comparison Feature Squawk MigrationPilot Language Rust TypeScript Safety rules 32 80 (77 free, 3 paid) Lock type classification No Yes Risk scoring No RED/YELLOW/GREEN Auto-fix No 12 rules GitHub Action Yes Yes (with PR comments) VS Code extension Yes Yes Config file .squawk.toml .migrationpilotrc.yml Output formats Text, TSV, JSON CLI, JSON, SARIF, Markdown Production context No Yes (paid, 3 rules) Community ~1,000 stars, 600K downloads/mo New project License Apache 2.0 MIT Price Free (100%) Free (97% of rules), $19/mo for production context Where Squawk Is Better Let's start with where Squawk wins. Bein