measure the impact of database changes before you merge.
When database schemas change, code has to catch up. Too much of that code is out of sight and out of mind -- in other modules, other systems, other repositories -- and gets left behind. After migration that code still expects the old structure and breaks. Chaos ensues.
ectomigo is a first line of defense against the risks inherent to schema migration. Once enabled on a repository, it indexes your data access code on every push: script files, inline SQL strings, and higher-level patterns in languages like JavaScript and Python. When you submit schema changes for review, it matches the affected database structures against your entire organization's code. If it finds any current references, in any covered repository, you'll get review comments linking directly to that code.
ectomigo is free for up to two private repositories (subject to some restrictions). Add it to your GitHub repositories now!
languages
migration formats
Migration scanning at launch covers SQL scripts only. ectomigo is tested against PostgreSQL, but the relevant differences between that and other SQL dialects are mostly minor.