Here are the main things I wanted in a migration tool which I couldn&#x27;t find anywhere else (at least not all in one tool):<p>* Ability to create&#x2F;drop database (super helpful for test environments)<p>* Read database connection string from an environment variable so I don&#x27;t need to specify it on the command line or have a separate configuration file.<p>* Automatically load .env file if it exists.<p>* Write migrations in pure SQL<p>* Use dates for migration versions<p>Goose supports many of these use cases, but specifically it doesn&#x27;t support create&#x2F;drop database, requires a separate configuration file, and appears to require hacks if your migration files do not contain only simple SQL statements separated by semicolons (i.e. stored procedures &#x2F; triggers).