Local Client Configuration
Table of contents
This article provides instructions on how to configure a local database client for use with DBeaver.
A local client refers to the database client software installed on your machine, allowing DBeaver to interact with your databases. This local installation is necessary for specific features like native backup and restore operations.
Key points to consider:
- In the Community Edition of DBeaver on Windows, local clients are downloaded from the internet when a remote client is selected in the Local Client options, typically during the first usage of database-specific tools such as backup, or restore functions.
- Windows users with the Enterprise, Ultimate, or Team editions enjoy a simplified process, as many local clients come pre-included with the software.
- Mac and Linux users may need to perform additional steps to configure the local client. The exact procedure will vary depending on the system setup.
Local Client configuration for Windows
Upon initial configuration, DBeaver will attempt to automatically identify the paths to local database clients in the Windows environment. If this process is unsuccessful, manual path configuration may be necessary.
Local Client configuration for Mac and Linux
On macOS, DBeaver actively tries to find local database tools automatically, covering a range of installations without requiring specific configurations from the user.
- For PostgreSQL on macOS: Installing the
libpqpackage may help DBeaver automatically detect the client. Use
brew install libpqin your terminal.
- For MySQL Users on macOS: To facilitate automatic client detection by DBeaver, consider adding the
mysql-clientpackage. This can be done using the command
brew install mysql-clientin the terminal.
If you encounter any issues with automatic detection, or if you're on a Linux system, follow the subsequent manual configuration steps below.
Find a database installation path
To find the installation path for the local client of a database in DBeaver, follow these general guidelines:
- For MySQL: Use
mysqldumpas a keyword in your search command. This utility is often located in the
bindirectory of the MySQL installation.
- For PostgreSQL: Substitute
pg_dumpwhen conducting your search. Like MySQL, this command should be in the
bindirectory of the PostgreSQL installation path.
These instructions are applicable to the most commonly used databases, MySQL and PostgreSQL.
Open your terminal.
findcommand to locate the MySQL installation:
find / -name "mysqldump" 2>/dev/null
Upon successful execution, the terminal will output the path to your MySQL installation. For example: -
Copy this path for use in the next steps of the configuration process.
Configure a local client in DBeaver on Mac and Linux
Right-click on the respective database and navigate to Edit Connection Settings.
Find the Local Client section and click on the Browse button that appears next to it.
Click the Add Home button to add a new client path.
For Mac users, press Command+Shift+G to open the prompt for path input. For Linux users, enter the path directly into the file selection dialog.
Input the MySQL path location found earlier and confirm. Make sure to input the path up to the database version folder, omitting
For example, if the path found is
After inputting the corrected path, click the Open button to select the path.
Click the OK button to finalize the local client configuration.