Patchi

Diff & migration tool like Git but for databases

Patchi connects to 2 of your databases and shows you the differences between them. Useful for migrating database environments. It also generates a migration SQL script for you.

Requirements

• Go 1.18 or higher

Build

go build -o patchi

Usage

Commands

1. Add a Connection

Adds a new connection to a local config file. You can add as many connections as you want. It prompts you to enter the connection details. All database information are stored locally in a config file. The config file is located at the equivalent of ~/.patchi/config.json on your OS.

./patchi add

2. List Connections

Lists all the connections in the config file.

./patchi list

3. Compare Two Connections

Shows the differences between 2 connections. It prompts you to select the connections you want to compare.

./patchi compare

4. Remove a Connection

Removes a connection from the config file. It prompts you to select the connection you want to remove. It takes an optional argument which is the name of the connection you want to remove. Otherwise it prompts you to select the connection you want to remove.

./patchi rm [optional-connection-name]

Contributing

Pull requests are always welcomed and encouraged. For major changes, please open an issue first to discuss what you would like to change.

License

This project is licensed under the MIT License. See the LICENSE file for details.