Utilitarian cross-platform MySQL GUI client
- No auto-commit
- Basic autocomplete of databases and tables
- Export output of queries to other programs - using
-- !program
, eg:SELECT * FROM table -- !cat > output.txt
will save the output of the select query to output.txt - Change existing values using GUI
- Cmd/Alt + Click on a foreign key opens the referenced row
- Cmd/Alt + Click on a table shows column details of the table
- GUI Connection manager
- AUR package
dibi-git
Connection parameters can be passed through as CLI parameters:
dibi --host 127.0.0.1 --user root --password password --port 3306
Otherwise connections can be configured with a config file at: ~/.dibi.conf
. An example of the config file:
[connection_label]
host=127.0.0.1
user=root
port=3306
password=password # optional if password_cmd is given
password_cmd=echo mypassword # optional command that is ran to get connection password
ssh_host=ssh.tunnel.com # optional host to use for creating ssh tunnel
ssh_user=root # optional ssh user for the tunnel
[another_connection]
...
GUI interface can also be used to configure connections.
- Commit/Rollback
- List columns of a table
- Basic Documentation
- Better gfx
- Nicer editing experience
- Export results
- MacOS and windows distribution
- Simple scripting options