mydbdoc is a command-line tool for auto-documenting MySQL schemas. Output formats include XML, HTML, and TXT. mysqldoc takes COMMENT arguments and translates them into useful formats.
A patch to MySQL that allow users to write procedures in a scripting language called LUA.
mylvmbackup is a Perl script for quickly creating backups of MySQL server's data files. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, makes an LVM snapshot of the volume containing the MySQL data directory, and unlocks the tables again.
MySQL Activity Report
The MySQL Activity Report package is a tool to help MySQL database administrators to collect several database parameters and variables. These collected values can be used for server monitoring or performance tuning purposes.
MySQL Cluster Administration Tools
The MyCAT project is a toolset for managing MySQL/Linux servers, and could be helpful for anyone managing a network of *nix servers whether running MySQL Cluster, standard replication, or not running MySQL at all.
MySQL Connector/Python implements the MySQL client/server protocol in pure Python.
An authentication module for the Squid proxy server to authenticate users on an mysql database. The database is a single table, and the table is a very simple user-password pair, with plain or encrypted passwords.
A script that check, periodically the tables of a MySQL Server. Using the BACKUP, CHECK, OPTIMIZE and ANALYZE, the script checks if everything is ok and alert you if anything is wrong.
mysqlconf is a Linuxconf module to help you configure MySQL database. It currently supports basic configuration like creating/destroying databases and users. It also allows to configure a few parameters in the my.cnf file.
mysqldiff is a Perl script front-end to the CPAN module MySQL::Diff which compares the data structures (i.e. table definitions) of two MySQL databases, and returns the differences as a sequence of MySQL commands suitable for piping into mysql which will transform the structure of the first database to be identical to that of the second (c.f. diff and patch).
A command line utility for fast binary searching sorted flat file constant databases. Partial key searches and files with tab delimited fields are supported. The archive, ndex.tar.gz, consists of the ANSI Standard C sources for the ndex program, and the rename, program that can be used to update a database, without locking, in a multiuser environment.
Object Relational Membrane
The Object Relational Membrane is a Python package that provides the functionality of an object relational layer like EJB or other persistence storage systems. It is a thin compatibility layer between SQL table layouts and Object Oriented Python. While providing a good deal of functionality, it tries to be as small and simple as possible. It currently works with PostgreSQL, Firebird and MySQL.
OpenLink ODBC Bench is an open-source ODBC Benchmarking tool providing real-time comparative benchmarking for ODBC Drivers, Database Engines, and Operating Systems combinations.
OpenFTS (Open Source Full Text Search engine) is an advanced PostgreSQL-based search engine that provides online indexing of data and relevance ranking for database searching. Close integration with database allows use of metadata to restrict search results.
PEAR MDB is a merge of the PEAR DB and Metabase php database abstraction layers.
It provides a common API for all support RDBMS. The main difference to most other DB abstraction packages is that MDB goes much further to ensure portability.
pgBadger is a PostgreSQL log analyzer build for speed with fully detailed reports from your PostgreSQL log file. It is a small Perl script that aims to replace and outperform the old php script pgFouine.
pgdiff compares the structures of two PostgreSQL databases and returns the differences as a sequence of SQL commands which can be fed to psql to transform the structure of the first to be identical to the second (analagous to diff and patch).
pgmp is a PostgreSQL extension to add the GMP data types and functions directly into the database.
pgnotifyd connects to a PostgreSQL database, listening for the named asynchronous notification. When notification is received, it executes the given command.
PgSqlClient is an ADO.NET Data provider for PostgreSQL 7.4+ written in C#, 100% managed code, for use with MS .NET and Mono:: platforms, with support for the 3.0 protocol of PostgreSQL.
PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension.
Postgresql AutoDoc is a utility which will run through PostgreSQL system tables and returns HTML, Dot, Dia and DocBook XML which describes the database.
PostgreSQL Table Log
PostgreSQL Table Log allows to track changes on a specific table.
A "data server prototype". It supports several data sources, such as XML and SQL databases and the communication protocol is highly configurable too.
psycopg is a PostgreSQL database adapter for the Python programming language. It was written from scratch with the aim of being very small and fast, and stable as a rock. The main advantages of psycopg are that it supports the full Python DBAPI-2.0, being thread safe at level 2 and providing some very usefull extensions like the user-defined type casters.
pxview is a program to read Paradox DB files. It is based on the pxlib library. pxview allows to output csv for reading with spread sheets, sql to import into a relational database, html and sqlite.
Python Schema Diff
Python Schema Diff is a python-based tool which permits to give the differences between two database schema. Its HTML rendering makes it easy for sharing this useful information among a team.
Querylog is a console tool for performing SQL queries on a (log) files. Lines from one or more text files or stdin are matched, using regular expressions to an in memory database on which SQL queries can be performed.
RecDB is a recommendation engine built entirely inside PostgreSQL 9.2. RecDB allows application developers to build recommendation applications in a heartbeat through a wide variety of built-in recommendation algorithms like user-user collaborative filtering, item-item collaborative filtering, singular value decomposition.
Round Robin SQL (RRS) is a SQL implementation of a round robin database.
Ruby Dataquery Shell
RDQS is a shell for querying various datasources such as SQL from a common interface. It does/should offer different data outputs, syntax highlighting, (grammatical) completion, shell interaction (e.g. backticks) and programmability.
SCRMGR is a curses-based (text screen or 'console') screen manager and data entry system. It makes heavy use of "softkey labels" and "softkeys" (a.k.a. function keys F1-F10) to guide the user.
ShellSQL is a suite of programs designed to enable LINUX/UNIX shell scripts to connect to SQL engines and execute SQL queries and commands in a simple way enabling intergration with the rest of the script.
The general idea of simple-db is to wrap the native client API of the database system into as thin a layer as possible and to provide the simple and uniform API to the upper levels.
Skeleton Engine for MySQL
Skeleton Engine for MySQL is a full framework to plug in a new storage engine. It comes with prebuild autoconf files, and a full framework to plug in your own design. The AWS, HTTP, Memcache, Nitro, PBXT, and many other engines were put together from the skeleton engine.
SkunkDB is a collection of tools to deal with skunk databases. The aim is to create a library, support tools, and a format suitable for high-speed data retrieval. The database is a static key -> value mapping. The databases cannot be inserted into, or deleted from. They are designed to be created once and queried many times.
SQLIer takes an SQL Injection vulnerable URL and attempts to determine all the necessary information to build and exploit an SQL Injection hole by itself, requiring no user interaction at all (unless it can't guess the table/field names correctly). By doing so, SQLIer can build a UNION SELECT query designed to brute force passwords out of the database.
sqlmap is an automatic blind SQL injection tool, developed in python, capable to enumerate entire remote database, perform an active database fingerprint and much more. The aim of this project is to implement a fully functional database mapper tool which takes advantages of web application programming security flaws which lead to sql injection vulnerabilities.
The MySQL Sandbox
MySQL Sandbox is a tool for installing one or more MySQL servers in isolation, without affecting other servers.
A DBMS for UNIX-like systems. It has isam-like access, transaction control, rollback, commit, exclusive lock, access control by client IP address, and user authentication. If you like old but simple database programming environments like COBOL+VSAM(KSDS) or C+C-ISAM, you will like Tyserv.
umbrello2sql reads a umbrello entity relationship diagram and generates the correspondent SQL instructions to create a PostgreSQL database.
Universal Data Access Driver Suite
A collection of utlities for ODBC and JDBC Driver benchmarking, and Data Access API implementation diagnostics.
visual-db is a tool for the visualization of a PostgreSQL database as tables with relations between them.
XQuare Bridge expands existing relational database functionalities with advanced XML import/export capabilities. It supports flexible extraction and publishing of relational data into any target XML format, using the XQuery language. Using a powerful mapping language, it can also perform efficient insertion of structured XML data into existing relational tables, while taking into account the database integrity constraints and transforming the implicit relations appearing in the XML document into explicit ones in the database.
XQuare Fusion is a powerful information integration engine for querying in real-time multiple, heterogeneous and distributed data sources. Using XML-based data sources federation, it presents to applications a single, uniform XML view of all business information, which can then be queried with XQuery to produce XML documents.
XtraBackup an open-source, free MySQL backup software that performs non-blocking backups for InnoDB, XtraDB, and MyISAM databases. It works with all versions of Percona Server, MySQL, and MariaDB. It performs streaming, compressed, and incremental backups.
The main ZeosLib product is a set of native datasets and database components for MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle, DB/2 for Borland compilers such as Delphi, C++ Builder and Kyli