pyxmdb is a database utility for exporting and importing data between a delimited text file (e.g. CSV) and virtually any DBMS. It has been tested with SQLite, MySQL, PostgreSQL, Oracle, and DB2. It supports running SQL statements before and after performing the import or export. Also allows for any of the SQL statements to be read from a file or provided on the command line. It supports reading and writing of compressed files, in addition to standard input and standard output.
OilCan is a native Universal Binary multithreaded query tool for PostgreSQL. It supports multiple query windows and multiple queries in one window, and includes a basic schema browser. Each query window gets its own connection. All queries run in their own thread, allowing other operations to continue while a long running query is running.
GWT Pleso Framework (gwt-pf) is a high-level framework based on Google Web Toolkit (GWT) for creating visual AJAX database front-end user interfaces. It lets you create an automatically generated user interface based on business-logic classes. It provides control panel solutions for Web site management, database enterprise projects, and other relation-based projects. It has a set of components for manipulating user data such as DataGrid, DataTextBox, and DataComboBox.
JSqsh is a Java reimplementation of a console based (i.e. non-graphical) database query tool called sqsh. Jsqsh combines the ability to run SQL queries against any database with a JDBC driver along with much of the functionality of a Unix shell, such as piping the results of queries out to external programs (grep, more, etc.), expanding variables, redirecting output to files, command line editing, tab-completion of object names, and more.
PHPMyVersion is designed to keep track of schema changes and row changes to specified tables. Developers can use it to keep track of changes to development databases that need to be passed on to live databases, e.g. through upgrade scripts. It is able to tag changes with a version number, and produce the SQL needed to upgrade a database from one version to another, which is very useful for upgrade scripts.
The SPT Relational Database Web Tool (RWT) is a simple application that can help developers connect to databases configured as a DataSource in the application server or directly through JDBC. The RWT application attempts to replicate basic features found in the popular Aqua Data Studio application. Per user settings (saved connection parameters, saved queries), single and batch query processing, a history browser, multiple query browsers, a tree view of database metadata, and other features are supported. Full source code is available.