Toolkit for Oracle. GPL

freshmeat.net: "TOra helps the DBA or developer of a database application. It features an SQL worksheet with PL/SQL block parsing, a PL/SQL debugger and editor with syntax highlighting, a Schema browser, Unicode support, printing, and a full suite of DBA management tools."

sqlDoInstall will help you to install new SQL scripts and keep track of the versions applied to your Oracle database. Freeware

sqlDoInstall 1.7 allows you to rerun a failed script and restart from the point where it has failed in a previous run. It does not apply a driver+script combination that has been installed successfully. The "driver" and the supplied SQL uniquely identifies your script across the database. It'll create two tables: driverinst contains details, and driverinst_head contains a summary of the installation process. SQL installation, schema upgrades, and version tracking are easy.

sqlDoInstall will help you to install new SQL scripts and keep track of the versions applied to your Oracle database. Freeware

sqlDoInstall 1.6 allows you to rerun a failed script and restart from the point where it has failed in a previous run. It does not apply a driver+script combination that has been installed successfully. The "driver" and the supplied SQL uniquely identifies your script across the database. It'll create two tables: driverinst contains details, and driverinst_head contains a summary of the installation process. SQL installation, schema upgrades, and version tracking are easy.

Distribution of PostgreSQL. GPLv2

Postgres Plus 8.3.3 is a distribution of PostgreSQL that contains the following additional features integrated in a convenient installation package: Postgres Studio for administration, Procedural Language Debugger, Geospatial extensions, GridSQL Parallel Query, MySQL Migration utility, Slony-II for replication, and pgmemcache for application scaling. The package contains both BSD and GPLv2 licensed software.

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

Talend Open Studio 2.4.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 RC P, and data related scripts are generated in Perl or Java. The application was designed to be extended with components written by users.

PL/SQL snippet (embedded in a shell script) which creates a well-formatted HTML report on a given database instance. GPL

OraRep 0.4.3 is a PL/SQL snippet (embedded in a shell script) which 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.

GUI (graphical user interface) for MySQL. GPL

MyJgui 0.6.1 aims to be easy to use for new users as well as experts. You can store multiple connections that can be used simultaneously. Stored passwords are encrypted using symmetric encryption. Underlying databases and tables are displayed in a tree structure with the connections being the first level nodes. MyJgui is capable of easy data manipulation through a grid. It has a unique feature of bookmarking parametrical queries (sqlmarks). The documentation (user guide) is quite comprehensive and kept up-to-date.

SQL Server monitoring tool. Freeware, Windows

Simtel.net: "xSQL Profiler is an easy to install, easy to use, agent-less SQL Server monitoring tool that can be utilized for performance, auditing and compliance related tasks. Its simple yet powerful interface allows the user to define custom events by combining low level SQL Server events and applying filters to get exactly what the user wants. The user can then define traces by selecting the events, the servers and/or databases to be monitored and applying additional filters to fine tune the results. The xSQL Profilers scheduling capability allow the user to schedule the traces to run at certain intervals every day, every week or every month on all the selected servers. Finally, xSQL Profilers automatically collects the trace data into a central repository and provides a flexible reporting interface that allows the user to quickly zero in on the data of interest.
xSQL Profiler's powerful filtering capability, advanced scheduling and flexible reporting interface make it a must have tool for SQL Server database administrators.
xSQL Profiler supports SQL Server 2008, SQL Server 2005 and SQL Server 2000."

Oracle database development and testing tool. GPL

GTKO 2.28
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.

Program for browsing MySQL databases. GPL

Entrance 1.2.87 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.

PHP-based administration package for PostgreSQL. GPL

phpPgAdmin 4.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.

Source code generator whose input is an SQL statement. LGPL

SPWrapper 0.9 is a source code generator whose input is an SQL statement, or with some limitations the name of a stored procedure. Each SQL statement become a Java class, iterable to fetch results if the statement is a SELECT. It is possible to generate Python classes for the cx_Oracle module. SPWrapper is designed to require little configuration: it tries to automatically guess input parameters form SQL code, and output parameters from the SQL result set fetched. All the SQL statements can be translated to source code, even those with proprietary syntax. It currently supports 4 databases for Java (Oracle, PostgreSQL, MySQL and SQL Server) and Oracle with Python. A Netbeans plugin is also available (for stored procedures only).

Code Generator. GPL

PHP or Java Class Code Generator 1.1.0 is meant is automate the generation of classes to access databases in the style of Java beans. It uses the Fast Template engine to process template files that define the skeleton of functions and variables of classes that store and retrieve data object property values from a given database table, getter and setter functions to access those properties, and a function to delete a data object row from the respective database table.

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

DBAHelper 0.2.3
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).

GUI (graphical user interface) for MySQL. GPL

MyJgui 0.5.7 aims to be easy to use for new users as well as experts. You can store multiple connections that can be used simultaneously. Stored passwords are encrypted using symmetric encryption. Underlying databases and tables are displayed in a tree structure with the connections being the first level nodes. MyJgui is capable of easy data manipulation through a grid. It has a unique feature of bookmarking parametrical queries (sqlmarks). The documentation (user guide) is quite comprehensive and kept up-to-date.

Data synchronization/replication software. LGPL

SymmetricDS 1.2.0 is Web-enabled, database independent, data synchronization/replication software. It uses Web and database technologies to replicate tables between relational databases in near real time. The software was designed to scale for a large number of databases, work across low-bandwidth connections, and withstand periods of network outage. It includes support for Oracle, MySQL, PostgreSQL, and MS SQL Server databases.

Program for browsing MySQL databases. GPL

Entrance 1.2.18 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.

Extract, Transform, and Load. GPL

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