phpMyAdmin is a tool intended to handle the administration of MySQL over the Web. It can create, rename, and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, create dumps of tables and databases, export/import CSV data, and administrate one single database and multiple MySQL servers.
Cego implements a relational and transactional database system with support for the SQL query language. The current release contains the most common database features for basic table manipulation and data retrieval. Indexes, foreign keys, views, and stored procedures are also implemented. Future releases (2.0 and above) will support a multi-node database concept with log file shipping for an automatic database application failover.
BaseX is a light-weight, high-performance, and scalable XML database system and XPath/XQuery processor, including full support for the W3C Update and Full Text extensions. An interactive and user-friendly GUI frontend gives you great insight into large XML data instances. It is platform independent and works out of the box.
DbWrench is multi-vendor, multi-platform database design and synchronization software. Features include a syntax highlighting SQL query editor, support for many of today's most popular databases, a graphic entity relation diagram (ERD) designer, and the ability to forward and reverse engineer databases. Its multi-vendor and multi-platform functionality makes it ideal for heterogeneous database environments.
MyJSQLView provides an easy-to-use Java based GUI frontend for viewing, adding, editing, or deleting data in the Apache Derby, H2, HSQL, Microsoft SQL, MSAccess, MySQL, Oracle, PostgreSQL, and SQLite databases. A query frame allows the building of complex SQL statements and SQL Query Bucket for saving such. The application allows easy sorting, searching, and import/export of table data. A plug-in framework allows inclusion of tools to visually build queries, profiles, and plot data for analysis.
DBeaver is a universal database manager and SQL Client. It supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, SQLite, Derby, and any database that has a JDBC driver. It is a GUI program that allows you to view the structure of a database, execute SQL queries and scripts, browse and export table data, handle BLOB/CLOB values, modify database meta objects, etc. It has a native UI (provided by the Eclipse SWT library), great performance, and relatively low memory consumption.
Talend Open Studio for Data Quality helps you to profile your data. The ergonomic interface allows you to define metrics (indicators) and collect statistics on your data in a few clicks. It comes with a set of regular expressions that helps you to identify bad data. You can create your own regular expressions and use them in data profiling analyses. A lot of options exist for each indicator, which change the behavior of the indicator so that it gives you more pertinent information. Data quality options on indicators alert you when your data quality is not what you expected.