Linux command
dbeaver 命令
文本
复制后可按需替换文件名、目录或参数。
常用示例
Launch DBeaver
dbeaver
Open specific database
dbeaver -con "name=[connection_name]"
Connect with inline parameters
dbeaver -con "driver=postgresql|host=localhost|database=mydb"
Execute SQL file
dbeaver -con "name=[connection]" -f [script.sql]
Export data
dbeaver -export "name=[connection]|table=[tablename]|file=[output.csv]"
Run in headless mode
dbeaver-cli -con "name=[connection]" -f [script.sql]
说明
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.).
- -f _FILE_
- SQL script file to execute.
- -export _PARAMS_
- Export data with specified parameters.
- -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.
FAQ
What is the dbeaver command used for?
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.
How do I run a basic dbeaver example?
Run `dbeaver` in a terminal, then adjust file names, paths, flags, or remote targets for your system.
What does -con _CONNECTION_ do in dbeaver?
Connection parameters (name, driver, host, database, user, etc.).