dbeaver

Launch DBeaver GUI

$ dbeaver

$ dbeaver -con "name=[connection_name]"

$ dbeaver -con "driver=postgresql|host=localhost|database=mydb"

$ dbeaver -con "name=[connection]" -f [script.sql]

$ dbeaver -export "name=[connection]|table=[tablename]|file=[output.csv]"

$ dbeaver-cli -con "name=[connection]" -f [script.sql]

dbeaver [options]

DBeaver is a free, universal database tool and SQL client for developers and database administrators. It supports a wide range of databases including PostgreSQL, MySQL, MariaDB, SQLite, Oracle, SQL Server, and many others through JDBC drivers.
The application provides a graphical interface for database management including SQL editing with syntax highlighting and autocomplete, visual query builder, ER diagrams, data export/import, and schema comparison. It also supports NoSQL databases like MongoDB and Cassandra.
DBeaver includes a command-line interface for automation tasks such as running SQL scripts, exporting data, and managing connections without the GUI.

-con CONNECTION

Connection parameters (name, driver, host, database, user, etc.).

SQL script file to execute.

Export data with specified parameters.

Start without splash screen.

Workspace directory location.

Override system locale.

Clear cached data and start fresh.

Display help information.

Requires Java Runtime Environment. Some enterprise features require the paid Enterprise Edition. Large result sets may consume significant memory. Connection configurations are stored in workspace and may need migration between versions.

DBeaver was created by Serge Rider and first released in 2010. It started as a simple database viewer and evolved into a comprehensive database management tool. The project is maintained by DBeaver Corp with both community and enterprise editions.

mysql(1), psql(1), sqlite3(1)