Caché Monitor is an SQL development tool for InterSystems database Caché. It features an advanced SQL query editor with SQL syntax highlighting, SQL code completion with context sensitive information about database objects (also known as Intellisense), an SQL history buffer for executed SQL commands, SQL code formatting, parallel queries, graphical SQL execution plan with index and selectivity information, SQL abbreviations, and much more. Database diagrams graphically show the structure of the database.
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.
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.
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.
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.
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.