LinuxCommandLibrary
GitHubF-DroidGoogle Play Store

dbeaver

universal database tool and SQL client

TLDR

Launch DBeaver GUI
$ dbeaver
copy
Open specific database connection
$ dbeaver -con "name=[connection_name]"
copy
Connect with inline parameters
$ dbeaver -con "driver=postgresql|host=localhost|database=mydb"
copy
Open a SQL file and connect it to a datasource
$ dbeaver -con "name=[connection]" -f [script.sql]
copy
Run a saved task (e.g. a data export task)
$ dbeaver -runTask "@[project]:[task]"
copy
Stop a running DBeaver instance
$ dbeaver -stop
copy

SYNOPSIS

dbeaver [options]

DESCRIPTION

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's command line can open connections and files in the UI and execute saved tasks (such as data export or backup tasks) via -runTask, which is the supported way to automate DBeaver operations.

PARAMETERS

-con CONNECTION

Connection parameters (name, driver, host, database, user, etc.).
-f FILE
Open the file in the DBeaver UI; with -con, connect it to the datasource.
-runTask @PROJECT:TASK
Execute a saved task; returns an exit code indicating success or failure.
-var NAME=VALUE
Set a variable for -runTask (repeatable).
-stop
Quit a running DBeaver instance.
-nosplash
Start without splash screen.
-data DIR
Workspace directory location.
-nl LOCALE
Override system locale.
-clean
Clear cached data and start fresh.
--help
Display help information.

INSTALL

sudo pacman -S dbeaver
copy

CAVEATS

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.

HISTORY

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.

SEE ALSO

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

RESOURCES

Copied to clipboard
Kai