Migra – A schema diff tool for PostgreSQL

This fills a gap for me. I tend to think of a database schema in declarative terms ("table T has these fields"), whereas the SQL DDL statements are more akin to commands (ALTER table T, adding a column). This always felt bad to me, because in order to define the final state of your schema, you need to define the initial state plus the commands necessary to get to the new one. A diff tool frees you from this pain.

This tool is incredibly useful I would also like to share a very similar tool that is much less known: https://github.com/bikeshedder/tusker It's the same thing, except instead of requiring two DB URL's to do the diffing, you give it a "schema.sql" file and a folder path that has your migrations in it, and the path to the current DB. Then it introspects the DB, looks at "schema.sql" + the migration files, and figures out what you've changed in "schema.sql" that…

Out of curiosity, are you familiar with the fact that "migra" as in "la migra" is short/slang for inmigración, meaning the homeland security folks who detain and deport people in the U.S.?