DBeaver – Universal database manager
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:
Microsoft SQL Server
Java DB (Derby)
SAP MAX DB
Any JDBC compliant data source
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)
Data (tables, query results) export
Database objects (tables, columns, constraints, procedures) search
Database object bookmarks
SQL scripts management
Projects (connections, SQL scripts and bookmarks)
MySQL plugin features:
Metadata DDL view
Advanced metadata editor
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.