DBeaver

DBeaver Community is a free, open-source database management tool built for developers, analysts, and database administrators who work with relational databases daily. It runs on Windows, macOS, and Linux, and connects to a wide range of SQL databases out of the box.

The Community edition covers the essentials well:

• SQL Editor with autocomplete, syntax highlighting, and dialect-aware suggestions for global variables like SYSDATE and current_date
• Data Editor for browsing and editing table data directly, with filtering, quick search, and support for complex types like JSONB
• Database maintenance tools for routine tasks like schema inspection, object search, and metadata management
• Task management for organizing and running recurring database operations
• Data transfer supporting CSV import/export with multi-character delimiters and XML escaping for structured formats

DBeaver supports MySQL, PostgreSQL, SQL Server, SQLite, MariaDB, and a growing list of community-contributed drivers including Apache Doris, DuckDB, Timeplus, and CUBRID. Each database gets tailored handling rather than a generic JDBC wrapper where possible.

For teams that need more, the commercial PRO edition adds NoSQL support for MongoDB, Cassandra, and Redis, cloud database connections to Redshift and BigQuery, native AWS/GCP/Azure integration, a visual query builder, and an AI assistant for SQL generation. The companion web tool dbvr extends access through a browser with enterprise authentication (SSO, Kerberos, SSL) and secret management via AWS Secrets Manager, Vault, and CyberArk.