Quick summary
DBeaver is a free, cross-platform database manager designed for people who work with databases professionally. It combines a spreadsheet-style data grid with powerful schema inspection and a full-featured SQL editor, letting you view, edit, export and report on data from a variety of engines.
Supported engines and connections
When you open the application it detects any existing database connections on the machine and lists them automatically. You can add new connections by selecting the database type, entering credentials, and (if necessary) specifying ODBC drivers. The tool works with multiple back ends such as MySQL, SQLite, Microsoft SQL Server and Firebird, and it can manage several simultaneous connections.
- Manage many database types simultaneously
- Add connections by choosing the engine and supplying login details
- Optionally point to required ODBC drivers for non-standard setups
Navigating projects and schema
A Projects area gives fast access to database objects and their contents. Clicking a table opens detailed information in the right-hand pane: column lists, triggers, index definitions, foreign keys and other constraints are all visible. The interface also provides the CREATE DDL for objects so you can review or recreate structures easily.
- View table columns, triggers, indexes and references at a glance
- Inspect constraints and automatically generated CREATE statements
- Open and switch between database objects from the Projects pane
Working with data
The data viewer behaves much like a spreadsheet, so editing rows, sorting and filtering feels familiar. You can export query results or table contents into the formats you need and build simple analytical reports directly from retrieved records.
- Edit rows inline in a spreadsheet-like grid
- Export results and build basic reports from record sets
- Sort and filter data without leaving the main viewer
SQL editing and script execution
For advanced tasks, DBeaver includes a robust SQL editor. You can open saved scripts, validate or analyze SQL fragments, and execute statements or entire scripts. Use the toolbar controls or the CTRL+Enter shortcut to run the currently selected query quickly.
- Run selected queries with toolbar options or CTRL+Enter
- Load, validate and analyze stored SQL scripts
- Execute both individual statements and multi-statement scripts
Why it’s a strong choice
DBeaver bundles a useful set of editors and utilities to simplify administration of multiple databases, from user accounts and indexes to views and stored procedures. It handles simple and complex SQL alike, making it suitable for small projects or managing large, enterprise-scale datasets.
- Useful toolset for handling users, procedures and schema objects
- Capable of executing simple queries and complex scripts
- Scalable enough for large database environments
Bottom line
If you need a free, multi-platform database manager that combines an approachable data grid with advanced SQL tools and comprehensive schema inspection, DBeaver is a solid option for developers and DBAs alike.
Technical
- Windows
- Mac
- Free