WebSQL. Freeware

Web based database administrator tool: "WebSQL wants to run on every DBMS and wants to give you the chance to have a unique tool to access and manage a DB...through a simple web interface. * User can: browse database structure as tables, views, keys, indices etc. * create, edit, and execute SQL scripts * save and reload queries * browse and edit table's content in a 'GridView' (excel-like) * view database structure as ER diagram It works with any JDBC compliant database (Oracle, MS SQLServer, MySQL, DB2, Sybase, Firebird, HSQLDB, PostgreSQL, Apache Derby, Mckoi SQL)"

Oracle database development and testing tool. GPL

GTKO 2.16
Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting. For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository in Oracle version 10g, and full AWR reports.

Collection of scripts to ease the daily maintenance work of Oracle database administrators. GPL

DBAHelper 0.2.0
Examples are moving objects between tablespaces, analyzing schemata, and rebuilding invalid indices. Also included is a little framework to simplify the use of RMAN (this framework depends on the use of Oracle 10g with the Recovery Area enabled and properly sized, so all backups go there).

ETL (Extract, Transform, and Load) tool. GPL

Talend Open Studio 2.2.0M1 can perform jobs that range from datawarehouse feeding to database synchronization, as well as file format transformations. Its graphical interface is made with Eclipse RCP, and data related scripts are generated in Perl. The application was designed to be extended with components written by users.

ETL (Extract, Transform, and Load) tool. GPL

Talend Open Studio 2.1.0 can perform jobs that range from datawarehouse feeding to database synchronization, as well as file format transformations. Its graphical interface is made with Eclipse RCP, and data related scripts are generated in Perl. The application was designed to be extended with components written by users.

PL/SQL snippet (embedded in a shell script). GPL

OraRep 0.4.1 creates a well-formatted HTML report on a given database instance, providing you with an overview on your instance(s), some hints for performance tuning, and more. It has been tested with Oracle 8.1.7, 9.0.1, and 9.2. The script easily fits into a cron task to be run on a regular basis. Sample output (HTML) is included. OSPRep does the same job for Oracle StatsPack Reports based on SnapShot Levels up to 7, and provides additional "plugins" for more detailed reporting on special issues. It also optionally creates a separate page with charts to visualize the results and more.

Web client interface for the MySQL database. GPL

MyClient 3.1.4 runs with PHP's register_globals off and outputs validated XHTML and CSS. Features include support for standard and persistent MySQL connections and PHP5's MySQLi interface. It also supports unlimited multiple tabbed interfaces, connection to multiple databases, one-button table descriptions, one-button database switching, query saving and loading, query results saving, and localization. It is not a full featured administration tool, but rather a multiple interface command client that improves upon the command line interface using a Web-based implementation.

Oracle database development and testing tool. GPL

GTKO 2.03
Its features include a schema browser, multiple SQL work areas, SQL syntax highlighting, bind variable entry widgets in the command window, and SQL*Plus-style command scripting. For SQL statement analysis and tuning there is a tree-style SQL statement "explain plan" facility and the ability to load SQL statements from the runtime cursor cache (V$SQL table), Oracle Statspack repository, the Oracle Automatic Workload Repository in Oracle version 10g, and full AWR reports.

PHP-based administration package for PostgreSQL. GPL

phpPgAdmin 4.1.2 has all the basic functionality you need to completely administer a PosgreSQL server and/or database, including the ability to administer views, sequences, stored procedures, and triggers. Features include the ability to create and drop databases; create, copy, drop, and alter tables/views/sequences/functions/triggers; edit and add fields (to the extent Postgres allows); execute any SQL-statement, even batch-queries; manage keys on fields; create and read dumps of database and tables; and administer one single database, multiple servers, and Postgres users/groups.

PHP/MySQL report generator. GPL

PM Report 4.1 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.

Web interface on top of a relational database (MySQL, PostgreSQL, SQLite, and MonetDB. GPL

Cubulus OLAP 0.52 is an analytic engine and a slice and dice Web interface on top of a relational database (MySQL, PostgreSQL, SQLite, and MonetDB at the moment). It caches calculated cells and is able to parse basic MDX queries, with a maximum of two dimensions cross-join on rows and/or on columns.

Free Informix-4GL compatible compiler. GPL

Aubit 4GL compiler 1.00-40 compiler is a project to make a free Informix-4GL compatible compiler. It translates 4GL source into executable programs, enabling fast creation of screen/form-based applications. With support for SQL statements forming an intrinsic part of the language, it's especially suitable for developing database-oriented applications. Database connectivity is provided for PostgreSQL, Informix, and ODBC. It supports both ncurses (console mode) and GTK+ (GUI mode) output.

Integrated database and Web environment. LGPL

MyOODB 2.0.0 is an integrated database and Web environment that provides true distributed objects, implicit/explicit multi-concurrent nested transactions, seamless Web tunneling, and database self-healing. MyOODB is one part of a two part SDK solution. Together with MyOOWEB, MyOOSDK provides a development environment for people who desire small, fast, but powerful applications.

Program for browsing MySQL databases. GPL

Entrance 0.77.5 includes a "match box" search facility that is simlar to the Mac's Spotlight. Entrance can create charts based on query results, and these charts can be zoomed and panned. Entrance also supports an innovative feature called "data painting" that allows users to select and paint data points interactively.

API for software developers to different database management systems. LGPL

OpenDBX 1.2.3 library provides a unified and consistent API for software developers to different database management systems. The function library is written in the C programming language and aims at implementing access to the native database interfaces efficiently via a thin abstraction layer. It consists of a basic set of functions that are part of all vendor database libraries and can be extended by additional function blocks. Currently, Firebird/Interbase, MS SQL Server, MySQL, Oracle, PostgreSQL, SQLite 2 and 3, and Sybase ASE are supported.

Program for browsing MySQL databases. GPL

Entrance 0.75.0 is a program for browsing MySQL databases. It includes a "match box" search facility that is simlar to the Mac's Spotlight. Entrance can create charts based on query results, and these charts can be zoomed and panned. Entrance also supports an innovative feature called "data painting" that allows users to select and paint data points interactively

Frontend for MySQL. GPL

Gequel 1.15 is a GTK/C based frontend for the popular MySQL database engine. It was loosely derived from an old program by the same author (xsqlmenu). It can retrieve data from MySQL databases, present them in nice browsers, and allows for update, delete, insert, search, query, and copy operations.

Applications on more than one database management system (DBMS). GPL

dbmstools 0.4.2 module exists mainly for developers who need to support applications on more than one database management system (DBMS). It's intended to allow all the database information (schema and base data) to be kept in one single place, and to have DBMS-specific scripts (for creating and populating the database schema, and upgrading from one version to the next) generated from that data. It can generate schema documentation for any DBMS (including diagrams), and can export data from a database in several formats. It also has wrappers for several tools so that they can be run from within Apache Ant. It supports PostgreSQL 7 and 8, Oracle, SQL Server, MySQL, and Hypersonic (limited support).

Database development framework for rapidly creating applications. GPL

building object network databases 2.4.2 is database development framework for rapidly creating applications. It creates live forms for the Web with AJAX and desktop applications using GTK. Using XML to define widget layouts, it drives the live forms to which SQL statements and methods can be attached.

API for software developers to different database management systems. LGPL

OpenDBX 1.3.1 library provides a unified and consistent API for software developers to different database management systems. The function library is written in the C programming language and aims at implementing access to the native database interfaces efficiently via a thin abstraction layer. It consists of a basic set of functions that are part of all vendor database libraries and can be extended by additional function blocks. Currently, Firebird/Interbase, MS SQL Server, MySQL, Oracle, PostgreSQL, SQLite 2 and 3, and Sybase ASE are supported.