Overview
DBeaver is free and open source (GPL) universal database tool for developers and database administrators.
Usability is the main goal of this project, program UI is carefully designed and implemented.
It is freeware.
It is multiplatform.
It is based on opensource framework and allows writing of various extensions (plugins).
It supports any database having a JDBC driver.
It may handle any external datasource which may or may not have a JDBC driver.
There is a set of plugins for certain databases (MySQL and Oracle in version 1.x) and different database management utilities (e.g. ERD).
Supported (tested) databases:
MySQL
Oracle
PostgreSQL
IBM DB2
Microsoft SQL Server
Sybase
ODBC
Java DB (Derby)
Firebird (Interbase)
HSQLDB
SQLite
Mimer
H2
IBM Informix
SAP MAX DB
Cache
Ingres
Linter
Teradata
Vertica
Any JDBC compliant data source
Supported OSes:
Windows (2000/XP/2003/Vista/7)
Linux
Mac OS
Solaris
AIX
HPUX
General features:
Database metadata browse
Metadata editor (tables, columns, keys, indexes)
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 (tables, columns, constraints, procedures) search
ER diagrams
Database object bookmarks
SQL scripts management
Projects (connections, SQL scripts and bookmarks)
MySQL plugin features:
Enum/Set datatypes
Procedures/triggers view
Metadata DDL view
Session management
Users management
Catalogs management
Advanced metadata editor
Oracle plugin features:
XML, Cursor datatypes support
Packages, procedures, triggers, indexes, tablespaces and other metadata objects browse/edit
Metadata DDL view
Session management
Users management
Advanced metadata editor
Other Benefits:
DBeaver consumes much less memory than other popular similar software (SQuirreL, DBVisualizer)
Database metadata is loaded on demand and there is no long-running “metadata caching” procedure at connect time
ResultSet viewer (grid) is very fast and consumes very little ammount of memory
All remote database operations work in non-blocking mode so DBeaver does not hang if the database server does not respond or if there is a related network issue
License
DBeaver is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.
DBeaver is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
License full version
Contacts
Technical support – support@jkiss.org
Technical support, feature suggestions and any other questions – serge@jkiss.org
dbeaver.jkiss.org