DBeaver — Universal Database Tool for Developers, DBAs, and Analysts

What it is

DBeaver is a free, open-source universal database management tool. It connects to virtually any database: MySQL, PostgreSQL, SQL Server, Oracle, SQLite, MongoDB, ClickHouse, Snowflake, BigQuery, and 80+ others. One application replaces separate tools for each database vendor.

DBeaver targets developers, DBAs, and data analysts who work with multiple databases. Instead of switching between pgAdmin for PostgreSQL, MySQL Workbench for MySQL, and a web console for BigQuery, you use DBeaver for everything.

How it saves time or tokens

DBeaver provides a consistent interface across all databases. SQL editing, schema browsing, data export, and ER diagram generation work the same regardless of the underlying database. This eliminates the learning curve of vendor-specific tools.

The SQL editor includes auto-completion, syntax highlighting, query formatting, and execution plan visualization. These features reduce query writing time and catch errors before execution.

How to use

1. Install DBeaver:

# macOS
brew install --cask dbeaver-community

# Linux
sudo snap install dbeaver-ce

# Or download from https://dbeaver.io/download/

1. Create a new connection: Database > New Database Connection > Select your database type > Enter credentials.

1. Browse schemas, write queries, and export data:

-- DBeaver's SQL editor supports auto-completion
SELECT
    u.name,
    u.email,
    COUNT(o.id) AS order_count
FROM users u
LEFT JOIN orders o ON u.id = o.user_id
WHERE u.created_at > '2026-01-01'
GROUP BY u.name, u.email
ORDER BY order_count DESC
LIMIT 100;

Example

Exporting query results to CSV from the command line:

# DBeaver CLI for scripted exports
dbeaver-cli -con "driver=postgresql|host=localhost|database=mydb|user=dev" \
  -script "SELECT * FROM users WHERE active = true" \
  -output users_export.csv

DBeaver also supports scheduled data transfers for regular exports.

Related on TokRepo

• AI tools for database -- Database management and query tools
• AI tools for coding -- Development tools and editors

Common pitfalls

• Running large queries without LIMIT. DBeaver loads query results into memory. A SELECT * on a million-row table can freeze the application. Always use LIMIT during exploration.
• Not configuring connection pooling. DBeaver creates a new connection for each editor by default. For databases with connection limits, enable connection pooling in the connection settings.
• Ignoring the ER diagram feature. DBeaver generates entity-relationship diagrams from your schema automatically. This is the fastest way to understand an unfamiliar database.