PM Report is a PHP/MySQL report generator. It creates customizable reports and is very simple to setup and use. You can select which database, table, and individual fields to use on your report. You can also select the order in which the fields should appear on the report, the field you would like to group by, the field you would like to sort by, and whether or not you would like a total for each column. Once the report has been generated, you can highlight individual rows and export the results to CSV.
The DataBrowser is a Java-based tool for browsing virtually any database. It has been tested with Oracle, SQL Server, PostgreSQL/Postgres, MySQL, DB2, and MS Access (among some others). It requires a Java 2 runtime environment. The DataBrowser allows you to execute dynamic SQL, import and export data, view the schema in a treeview, and view query results in a table view. It also logs all SQL executed with the SQLLog feature.
iSQL(IndependentSQL)-Viewer is a JDBC 2.0-compliant application that can take advantage of platform features such as transactions, running batch modes, and database abstraction. Even in heterogeneous database environments, it supports all database platforms with a JDBC 2.0-compliant driver, such as PostgreSQL, MySQL, and Oracle. It provides a variety of tools to carry out both simple and complex database activities.
SQL Uniform is a database comparison and SQL query program. It is a database client with a graphical user interface. It supports any kind of database and database servers to which there is an ODBC or JDBC standard driver. It has been tested on Access, Adabas D, DaffodilDB, dBASE, Excel, HSQL, IBM DB2, Interbase (Firebird), JDataStore, Linter (Relex), McKOI, Mimer, MSSQL, MySQL, Openlink Virtuoso, Oracle, Paradox, Pervasive (Btrive), Pointbase, PostgreSQL, Solid, SQLITE, Sybase, ThinkSQL, and Yard.
RedQueryBuilder fills the gap between a hand coded "quick search" and a full blown query language. A typical use is in an intranet Web application where experienced users need a quick ad-hoc way to find particular data. This means they don't have to use report frameworks or ask a techie. To use it in your app, you just need to drop in the JS, feed it the metadata for your database, then handle the change events to get the SQL and argument values.
Maccess helps to analyse data in databases; it is a Web interface to an SQL server. Its main features are user friendly query creation for SQL server; selective, grouped, and crosstab queries; various outputs (XML, HTML, TXT, graphs, and Europe map); data ungrouping in grouped queries; creation of Web links and definition of CSS styles for all values in output; ability to format numbers, dates, and times; and input and data update.
Uhura is a Web console for databases. It works with MySQL, PostgreSQL, and FirebirdSQL. It presents trees that let you browse databases, tables, columns, constraints, triggers, views, and procs. It has panels for history and fragments. Its editor features autocompletion and autoindenting. It is easy to install.