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.

Compared to alternatives like Beekeeper Studio or TablePlus, DBeaver's Community edition goes deeper on database-specific features and driver coverage. It's not the most minimal tool available, but for anyone managing multiple database types across different environments, the breadth of support is hard to match without paying for a commercial product.

Security is taken seriously: the project actively patches CVEs and has fixed XML external entity and SQL injection vulnerabilities in recent releases.