### Example Output for org.osgi.framework.storage

Source: https://dbeaver.com/docs/dbeaver/How-to-set-a-variable-if-dbeaver-ini-is-read-only

This example shows the typical output when searching for `org.osgi.framework.storage` in DBeaver's Installation Information, indicating the configuration directory path.

```text
org.osgi.framework.storage=file:/C:/Users/user/.eclipse/org.jkiss.dbeaver.product_22.0.5_1535670467_win32_win32_x86_64

```

--------------------------------

### DBeaver Windows Silent Install Command Example

Source: https://dbeaver.com/docs/dbeaver/Windows-Silent-Install

Use this command structure to install DBeaver silently for all users. Ensure you have administrator privileges.

```bash
C:\Program Files\DBeaver> installer.exe /S /allusers /D=C:\\Program Files\\DBeaver
```

--------------------------------

### Configure Predefined Drivers with dbeaver.ini

Source: https://dbeaver.com/docs/dbeaver/Admin-Manage-Drivers

This example shows how to configure a driver's JAR path using a custom XML file specified in the dbeaver.ini file. This is useful for automatically providing driver configurations to multiple DBeaver installations.

```xml
<?xml version="1.0" encoding="UTF-8"?>
<drivers>
  <provider id="generic">
    <driver id="netezza">
      <library type="lib" path="X:\jdbc-drivers\netezza-jdbc.jar"/>
    </driver>
  </provider>
</drivers>
```

--------------------------------

### Example Preference File Structure

Source: https://dbeaver.com/docs/dbeaver/Admin-Manage-Preferences

Preference files use a simple key-value pair format separated by '=' and newlines. Comments start with '#'.

```properties
# file org.jkiss.dbeaver.test.prefs
some.key=value1
some.other.key=value2

```

--------------------------------

### Tnsnames.ora Configuration Example

Source: https://dbeaver.com/docs/dbeaver/Connecting-to-Oracle-Database-using-JDBC-OCI-driver

Example of how to define an Oracle database connection alias, host, port, and service name in the tnsnames.ora file.

```text
MYDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = myhost.example.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mydbservice.example.com)
    )
  )


```

--------------------------------

### Example AI Query Suggestion Prompt

Source: https://dbeaver.com/docs/dbeaver/AI-query-suggestion

Use a comment above your SQL query to guide the AI in generating suggestions. Place your cursor where you want the query to appear.

```sql
-- find flight with flight_id equal or less then 1230
SELECT

```

--------------------------------

### Install libpq on macOS

Source: https://dbeaver.com/docs/dbeaver/Local-Client-Configuration

Use this command to install the libpq package on macOS, which may help DBeaver automatically detect PostgreSQL clients.

```bash
brew install libpq
```

--------------------------------

### Install mysql-client on macOS

Source: https://dbeaver.com/docs/dbeaver/Local-Client-Configuration

Use this command to install the mysql-client package on macOS, which can facilitate automatic client detection by DBeaver for MySQL.

```bash
brew install mysql-client
```

--------------------------------

### Run DBeaver after Debian Installation

Source: https://dbeaver.com/docs/dbeaver/Installation

Execute this command to launch DBeaver after installing it with a Debian package.

```bash
dbeaver &
```

--------------------------------

### Import Users from CSV Example

Source: https://dbeaver.com/docs/dbeaver/License-Management-in-the-User-Portal

This example shows the expected format for a CSV file when importing users into a group license. Each line represents a user with their email and name separated by a semicolon.

```text
alice@dbeaver.com;Alice Cooper
user-bob;Bob Bundy

```

--------------------------------

### Install DBeaver CE Snap Package

Source: https://dbeaver.com/docs/dbeaver/Snap-installation

Installs the dbeaver-ce snap package using the stable release channel.

```bash
snap install dbeaver-ce --stable
```

--------------------------------

### Install PostgreSQL Extension using SQL

Source: https://dbeaver.com/docs/dbeaver/PostgreSQL-Extensions

Use this SQL command to install a PostgreSQL extension directly via the SQL Editor. Ensure you have the necessary permissions.

```sql
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

```

--------------------------------

### Install Eclipse Extensions using P2 Director

Source: https://dbeaver.com/docs/dbeaver/Command-Line

Install additional Eclipse-compatible extensions directly from the command line using the built-in P2 Director. This method does not require the graphical interface.

```bash
-application org.eclipse.equinox.p2.director -repository https://wakatime.com/eclipse/update-site/ -repository https://download.eclipse.org/releases/2025-06/ -installIU com.wakatime.eclipse.feature.feature.group -followReferences
```

--------------------------------

### MySQL REPLACE INTO Example

Source: https://dbeaver.com/docs/dbeaver/Data-Import-and-Replace

Demonstrates the MySQL 'REPLACE INTO' syntax to insert rows, replacing existing rows with duplicate keys.

```sql
REPLACE INTO language_insert(language_id, name, last_update)
VALUES(1, 'English', '2006-02-15 05:02:19.0');

```

--------------------------------

### Multiline Command Example

Source: https://dbeaver.com/docs/dbeaver/Client-Side-Scripting

Enclose multiline commands within '@@' delimiters to execute them as a single command.

```sql
@@set var = 'long multiline value' @@
```

--------------------------------

### SQLite INSERT OR IGNORE Example

Source: https://dbeaver.com/docs/dbeaver/Data-Import-and-Replace

Demonstrates the SQLite 'INSERT OR IGNORE' syntax to insert rows, skipping those with duplicate keys.

```sql
INSERT OR IGNORE INTO language_insert(language_id, name, last_update)
VALUES(1, 'English', '2006-02-15 05:02:19.0');

```

--------------------------------

### FireBird UPDATE OR INSERT INTO Example

Source: https://dbeaver.com/docs/dbeaver/Data-Import-and-Replace

Demonstrates FireBird's 'UPDATE OR INSERT INTO' syntax for handling duplicate keys during insertion.

```sql
UPDATE OR INSERT INTO language_insert(language_id, name, last_update)
VALUES(1, 'English', '2006-02-15 05:02:19.0');

```

--------------------------------

### Full drivers.xml Example for PostgreSQL

Source: https://dbeaver.com/docs/dbeaver/Admin-Manage-Drivers

A comprehensive drivers.xml configuration for the PostgreSQL provider, including multiple libraries and Maven artifact references.

```xml
<?xml version="1.0" encoding="UTF-8"?>
<drivers>

  <provider id="postgresql">
      <driver id="postgres-jdbc" custom="false" embedded="false" name="PostgreSQL" class="org.postgresql.Driver" url="jdbc:postgresql://{host}[:{port}]/[{database}]" port="5432" description="PostgreSQL standard driver">
          <library type="jar" path="maven:/org.postgresql:postgresql:RELEASE" custom="false" version="42.2.20">
              <file id="org.postgresql:postgresql" version="42.2.20" path="${drivers_home}/maven/maven-central/org.postgresql/postgresql-42.2.20.jar"/>
          </library>
          <library type="jar" path="maven:/net.postgis:postgis-jdbc:RELEASE" custom="false" version="2.5.0">
              <file id="net.postgis:postgis-jdbc" version="2.5.0" path="${drivers_home}/maven/maven-central/net.postgis/postgis-jdbc-2.5.0.jar"/>
          </library>
          <library type="jar" path="maven:/net.postgis:postgis-jdbc-jtsparser:RELEASE" custom="false" version="2.5.0">
              <file id="net.postgis:postgis-jdbc-jtsparser" version="2.5.0" path="${drivers_home}/maven/maven-central/net.postgis/postgis-jdbc-jtsparser-2.5.0.jar"/>
          </library>
      </driver>
  </provider>

</drivers>
```

--------------------------------

### Initiate GCP Login

Source: https://dbeaver.com/docs/dbeaver/GCP-SSO

This command is executed if no access token is found. It opens a web browser for the user to log in and select their Google account.

```bash
gcloud auth login
```

--------------------------------

### Install WebView2 Runtime

Source: https://dbeaver.com/docs/dbeaver/Troubleshooting-Missing-WebView2

Use this PowerShell script to download and silently install the Microsoft Edge WebView2 runtime. Ensure you reboot the machine after installation.

```powershell
Invoke-WebRequest -Uri "https://go.microsoft.com/fwlink/p/?LinkId=2124703" -OutFile "C:\Windows\Temp\MicrosoftEdgeWebview2Setup.exe"
Start-Process "C:\Windows\Temp\MicrosoftEdgeWebview2Setup.exe" -ArgumentList "/silent /install" -Wait

```

--------------------------------

### Install DBeaver via RPM Package

Source: https://dbeaver.com/docs/dbeaver/Installation

Use this command to install DBeaver on RPM-based Linux distributions.

```bash
sudo rpm -ivh dbeaver-<version>.rpm
```

--------------------------------

### Example AI Command Usage

Source: https://dbeaver.com/docs/dbeaver/AI-command

To use the AI command, open the SQL Editor and type your request prefixed with '@ai'. The generated SQL will be executed, and results will appear in the Result panel.

```text
@ai show all customers with invoices in the last month
```

--------------------------------

### Install DBeaver via Debian Package

Source: https://dbeaver.com/docs/dbeaver/Installation

Use this command to install DBeaver on Debian-based Linux distributions.

```bash
sudo dpkg -i dbeaver-<version>.deb
```

--------------------------------

### DBeaver Windows Silent Install for Current User

Source: https://dbeaver.com/docs/dbeaver/Windows-Silent-Install

This command installs DBeaver silently for the current user only. No administrator privileges are required.

```bash
C:\Program Files\DBeaver> installer.exe /S /currentuser /D=C:\\Users\\<username>\\AppData\\Local\\DBeaver
```

--------------------------------

### Import DataGrip/JetBrains IDE Connection Configuration

Source: https://dbeaver.com/docs/dbeaver/How-to-import-Connections-from-External-Tools

Paste connection configuration details copied from DataGrip or IntelliJ IDEA. DBeaver will parse the content and allow you to select which connections to import.

```text
#DataSourceSettings#
#LocalDataSource: example@127.0.0.1
#BEGIN#
<data-source source="LOCAL" name="example@127.0.0.1" uuid="...">
  <database-info dbms="MYSQL" version="8.2.0"/>
  <driver-ref>mysql.8</driver-ref>
  <jdbc-url>jdbc:mysql://127.0.0.1:3306</jdbc-url>
  <user-name>example</user-name>
</data-source>
#END#

```

--------------------------------

### Folder Structure Example for Multi Source Driver

Source: https://dbeaver.com/docs/dbeaver/Database-driver-Files-MultiSource

Illustrates how DBeaver organizes files from a given folder structure into schemas. Files in the root are in the 'Default' schema, subfolder files are in schemas named after the subfolder, and files in deeper folders are ignored.

```text
Data/
├── employees.csv
├── sales.json
└── Reports/
    ├── monthly.xml
    ├── yearly.parquet
    └── summary.xlsx

DBeaver will create:
  * `Default` schema: `employees`, `sales`
  * `Reports` schema: `monthly`, `yearly`, `summary`
```

--------------------------------

### SQLite INSERT OR REPLACE Example

Source: https://dbeaver.com/docs/dbeaver/Data-Import-and-Replace

Demonstrates the SQLite 'INSERT OR REPLACE' syntax to insert rows, replacing existing rows with duplicate keys.

```sql
INSERT OR REPLACE INTO language_insert(language_id, name, last_update)
VALUES(1, 'English', '2006-02-15 05:02:19.0');

```

--------------------------------

### Install PostgreSQL Debugger on Ubuntu

Source: https://dbeaver.com/docs/dbeaver/PGDebugger

Installs the PostgreSQL debugger extension on Ubuntu-based systems using apt. Requires restarting the PostgreSQL service.

```bash
sudo apt install postgresql-12-pldebugger
sudo service postgresql restart

```