DBeaver – Universal database manager
Sponsored Link
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
Any JDBC compliant data source
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
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
Install DBeaver on ubuntu
Download deb package from here once you have deb package you can double click on it to install.
