DBeaver

The DBeaver is a universal database administration tool and SQL client. Generally it uses JDBC drivers to allow users to work with databases. It provides an SQL editor that offers code completion and syntax highlighting for standard SQL and database metadata browser which allows to view database structure and settings. Also it has a set of tools and plugins which allows to view/edit ER diagrams, perform export and import of tables and databases, etc. DBeaver has a plugin architecture that allows to create custom plugins for certain databases to provide non-standard database features (like tablespaces, stored procedures, security management, etc).
As DBeaver is written entirely in Java with SWT UI components, it has to run on any platform that has a JVM.
DBeaver is freeware and open-source. It is released under terms of GPL license.
Feature Summary
* Database metadata browse - allows for browsing database objects such as catalogs, schemas, tables, view, triggers, sequences, procedures, indexes,
security objects, etc
* Metadata editor - allows for editing database objects.
* SQL statements/scripts execution
* SQL highlighting (specific for each database engine)
* Autocompletion and metadata hyperlinks in SQL editor
* Result set/table edit
* BLOB/CLOB support (view and edit modes)
* Scrollable resultsets
* Data (tables, query results) export
* Transactions management
* Database objects search (tables, columns, constraints, procedures)
* ERD (Entity Relational Diagrams)
* Database object bookmarks
* SQL scripts management
* Projects support (connections, SQL scripts and bookmarks)
History
The DBeaver project was started by Serge Rieder in 2011 and became an open source in June 2012.
Supported operation systems
* Microsoft Windows
* Linux
* Mac OS
* Solaris
* AIX
* HPUX
Supported databases
* Apache Derby
*
* Firebird with the JayBird JCA/JDBC Driver
* FrontBase
* HSQLDB
*
* IBM DB2
* Informix
* Ingres (and OpenIngres)
* InterBase
* Linter SQL RDBMS
* Mckoi SQL Database
* Microsoft Access with the JDBC/ODBC bridge.
* Microsoft SQL Server
* Mimer SQL
* MySQL
* Oracle Database
* PostgreSQL
* MaxDB / SAPDB
* SQLite
* Sybase
* Teradata
* Windows Management Instrumentation (WMI) interface

Main Menu

See Also

Main Menu