Given a MySQL connection string, pgloader query the catalogs to list your tables, constraints and indexes and know how to transform this schema into a PostgreSQL equivalent, applying advanced casting rules that you can edit in the command.
Migrate some tinyint to boolean and some others to smallint all from the same tool!
The current version of pgloader is up to ten times faster than the previous one. The new command syntax is really powerful, and as it's different enough from the previous version, pgloader includes a command line switch to upgrade your setup for you.
pgloader includes reformating modules allowing you to reformat your data, such as transforming a couple of integer columns into a single ip address, or a couple of floats into a single point. Of course, you can add any transformation you like and easily get to use it with pgloader loading your code!