How to Install and Run DBeaver Portable from a USB Drive
What you’ll need
- A USB drive with at least 500 MB free (32 GB recommended if you’ll store multiple databases or exports)
- A Windows PC (portable build instructions here assume Windows; macOS/Linux require different steps)
- Internet access to download DBeaver Portable
Step 1 — Download DBeaver Portable
- Open your browser and go to DBeaver’s official download page.
- Choose the “Portable” (ZIP) package for Windows.
- Save the ZIP file to your PC.
Step 2 — Prepare the USB drive
- Insert the USB drive and ensure it’s formatted with NTFS or exFAT for large files and better compatibility.
- Create a folder on the USB drive named “DBeaver-Portable” (or a name you prefer).
Step 3 — Extract DBeaver Portable to the USB drive
- Right-click the downloaded ZIP and choose “Extract All…” or use your preferred unzip tool.
- Extract the ZIP contents directly into the “DBeaver-Portable” folder on the USB drive. The folder should contain an executable like dbeaver.exe and related files/folders (plugins, configuration).
Step 4 — Configure portable settings (optional but recommended)
- In the DBeaver folder, create a folder named “data” to hold workspace and configuration. This ensures DBeaver uses the USB drive for settings rather than the host PC.
- If a dbeaver.ini or dbeaver.conf file exists, you can add or confirm the workspace path:
- Add a line with: -data
- Followed by the relative path to the data folder, e.g., ./data/workspace
- To keep drivers and extensions on the USB, ensure plugin and dropsins folders remain on the drive.
Step 5 — Run DBeaver from the USB drive
- Safely eject and reinsert the USB on any Windows machine you want to use.
- Open the “DBeaver-Portable” folder and double-click dbeaver.exe.
- On first run, DBeaver may download database drivers when you connect to a database; allow it to download into the USB folder if prompted.
Step 6 — Connect to databases
- Click “Database” → “New Database Connection” (or use the “New Connection” toolbar button).
- Select the database type (MySQL, PostgreSQL, SQLite, SQL Server, etc.).
- Enter connection details (host, port, username, password). For security, avoid saving passwords on public USB drives; instead use the “Save password” option only on trusted drives.
- Test the connection, then finish.
Step 7 — Best practices and troubleshooting
- Backup: Keep a second backup of the USB contents to avoid data loss.
- Performance: USB performance affects DBeaver speed; use a USB 3.0 drive on USB 3.0 ports.
- Drivers: If driver downloads fail due to host machine restrictions, download drivers in advance and place them in the drive’s driver folder.
- Permissions: Run DBeaver as administrator if the host machine restricts execution from external drives.
- Antivirus: Some antivirus software blocks executables from USB drives; whitelist dbeaver.exe on trusted machines.
- Workspace issues: If DBeaver uses the host PC profile instead of USB, double-check the -data path in dbeaver.ini.
Quick checklist
- USB formatted NTFS/exFAT
- DBeaver Portable ZIP extracted to USB
- data folder created and dbeaver.ini configured (optional)
- Drivers present or allow downloads on first run
- Backup of USB contents
Following these steps, you can carry DBeaver and your database workflows on a USB drive and run it on compatible Windows machines without installing it on each host.
Leave a Reply