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

> DBeaver is a free universal SQL client that speaks MySQL, PostgreSQL, SQL Server, Oracle, SQLite, MongoDB, ClickHouse, Snowflake, BigQuery, and 80+ other databases. One IDE for every datastore you touch.

## Install

Save in your project root:

# DBeaver — Universal SQL Client

## Quick Use
```bash
# macOS
brew install --cask dbeaver-community
# Ubuntu/Debian
sudo snap install dbeaver-ce
# Windows
winget install dbeaver.dbeaver
```

## Introduction
DBeaver is the most-used free database IDE. Built on Eclipse, it connects to 80+ databases and data stores, parses SQL with proper context-aware autocomplete, visualizes schemas as ER diagrams, and lets you query NoSQL stores with the same interface as relational ones.

With over 50,000 GitHub stars (Community Edition), DBeaver is used daily by hundreds of thousands of developers and DBAs. The paid Enterprise edition adds extra drivers (Snowflake, Vertica, Teradata), visual query builders, and team features.

## What DBeaver Does
DBeaver loads a JDBC driver per database (or native protocol for NoSQL), exposes a tabbed SQL editor with autocompletion, schema browser, data editor (edit rows like a spreadsheet), ER diagram, and query history. It handles connections via SSH tunnel, IAM, Kerberos, Kubernetes port-forwarding — whatever your infra needs.

## Architecture Overview
```
[DBeaver GUI (Eclipse RCP)]
      |
[Driver Manager]
  JDBC drivers for SQL databases
  Native drivers for MongoDB, Cassandra, Redis
      |
  +------+------+------+
  |      |      |      |
SQL    ER      Data   NoSQL
editor diagram editor views
      |
[Session Layer]
  SSH tunnel / TLS / IAM auth / Kerberos
      |
[Database] (80+ supported)
  Postgres, MySQL, Oracle, SQL Server,
  MongoDB, Redis, Cassandra, ClickHouse,
  Snowflake, BigQuery, Databricks, DuckDB, ...
```

## Self-Hosting & Configuration
```text
# Connection manager (UI: Database -> New Database Connection)
- Server host: db.example.com
- Port: 5432
- Database: production
- User: analytics_ro
- Password: ********
- SSH tunnel: (optional)
    Host: bastion.example.com
    User: deploy
    Auth: key / ssh-agent
- SSL: Prefer / Require
```

```sql
-- Writing SQL with autocomplete, execute with Ctrl+Enter
SELECT
  date_trunc('day', created_at) AS day,
  COUNT(*)                     AS orders,
  SUM(amount)                  AS revenue
FROM orders
WHERE created_at >= NOW() - INTERVAL '30 days'
GROUP BY 1
ORDER BY 1 DESC;

-- Right-click -> Export -> choose CSV/JSON/Excel/SQL INSERT
```

## Key Features
- **80+ databases** — one client for every datastore
- **SSH tunneling** — connect through bastion hosts without extra ports
- **Data editor** — edit query results like a spreadsheet, commit with one click
- **ER diagrams** — auto-generate schema diagrams, print or export
- **Visual query builder** — drag-and-drop table joins (Enterprise Edition)
- **Import/Export** — CSV, JSON, XML, Excel, SQL — to/from any database
- **Encrypted project files** — master password protects connection data
- **Rich SQL editor** — autocomplete, formatting, templates, execution plans

## Comparison with Similar Tools
| Feature | DBeaver CE | DBeaver PE | DataGrip | TablePlus | Beekeeper Studio |
|---|---|---|---|---|---|
| Free | Yes | $210/yr | $99/yr | $90 one-time + $49/yr | Free (community) / paid |
| Databases | 80+ | 90+ (SF, Teradata) | 30+ | 15+ | 15+ |
| Data editor | Yes | Yes | Yes | Yes | Yes |
| ER diagrams | Yes | Yes (advanced) | Yes | Read-only | No |
| Visual query builder | No | Yes | Yes (Diagram) | No | No |
| Platform | macOS/Win/Linux | Same | Same | macOS/Win | macOS/Win/Linux |
| Best For | Most devs | Enterprises (Snowflake/Teradata) | JetBrains shops | macOS polish | Lightweight / OSS |

## FAQ
**Q: DBeaver CE vs Enterprise?**
A: Community covers 95% of common databases. Enterprise adds native Snowflake, Teradata, Vertica, SAP HANA drivers, visual query builder, and mock data generator. Most devs are fine on CE.

**Q: Does it work with cloud databases?**
A: Yes. RDS, Aurora, Cloud SQL, Azure SQL, Snowflake, BigQuery (Enterprise or via JDBC driver), Databricks — all first-class. SSH tunneling handles private network databases.

**Q: Is it slow?**
A: Being Java/Eclipse-based, DBeaver is heavier than native tools like TablePlus. Startup ~5s; once running, it's responsive. For ultra-fast single-DB use, TablePlus/Beekeeper may feel snappier.

**Q: Can teams share connections securely?**
A: Yes via CloudBeaver (browser-based multi-user DBeaver). Or use Dbeaver CE with a shared encrypted .dbeaver folder in git (less elegant but works).

## Sources
- GitHub: https://github.com/dbeaver/dbeaver
- Website: https://dbeaver.io
- Company: DBeaver Corp
- License: Apache-2.0 (Community)

---
Source: https://tokrepo.com/en/workflows/8e5054fc-3814-11f1-9bc6-00163e2b0d79
Author: AI Open Source