Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting. hot
Abstract Data Base Connector is an abstact OOP way to connect to several databases.
Acquired Virtual Distribution
AVD is a continuation of the swim project. The goal is to create a suitable SQL server from swim's not-installed DB, and to maintain the swim client. AVD will be used as a gBootRoot method.
auth postgresql would provide the capability to keep all users info in a PostgreSQL database instead than in plain text files (as usually) and even more have a more performant system than NIS+.
BabelQL is a C preprocessor script that allows many different SQL dialects to be generated from a single source file.
Barman (backup and recovery manager) is an administration tool for disaster recovery of PostgreSQL servers written in Python. It allows to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase.
Broadcast Oracle Sql
A Python/Perl/Ruby script useful to submit a SQL statement to several Oracle instances.
Cacti is a complete frontend to RRDTool, it stores all of the necessary information to create graphs and populate them with data in a MySQL database. The frontend is completely PHP driven. Along with being able to maintain Graphs, Data Sources, and Round Robin Archives in a database, cacti handles the data gathering. There is also SNMP support for those used to creating traffic graphs with MRTG. Read more
cliPSafe is a command line interface (CLI) to Password Safe databases. cliPSafe only works with version 3 databases and it currently only operates in read-only mode.
Contains a number of Python scripts that handle Oracle DBA tasks in a cross platform manner.
Database Modeller is a simple tool for drawing entity-relationship (database schema) diagrams using Crow's Foot or Visio's Relational notation.
DataDiff is a utility for comparing the contents of two identical sets of tables in MySQL and returning the rows that differ between the two.
A dialog interface to the four major RDMS (Oracle, DB2, PostgreSQL and MySQL). It is written in bash, and uses the dialog and Xdialog facility to let a DBA perform various administration tasks.
dbauth is a command-based utility used for creating, updating, removing and/or importing user's authenticated information such as: user IDs, passwords, groups and optionally comments, in a DB or DBM database format. dbauth supports three types of password encryption method and all types of Apache Limit directives.
DBConsole is a database shell that currently supports SQLite, PostgreSQL, and MySQL.
A DBI driver for InterBase, written using InterBase C API.
A database schema update and porting tool. dbischema is written in perl, it requires DBI, XML::Parser, and DBD::mysql, DBD::Pg or both.
dbo is a database object relational mapper (ORM) written entirely in Python. Tables are represented using a straightforward python class and row instances are encapsulated as python instances. Joins, views, transactions, and more.
DBOW is a database compiler-compiler or front-end. It takes table definitions in a meta language and prepares C, C++, PHP, Perl (etc) functions for manipulating the database. It will also produce SQL table data for MySQL.
DBTCP is a proxy server for ODBC connection.
It allows you to make a query from a linux machine to a database in a Windows machine through ODBC.
dbtool can be used to store and retrieve data in a key/value format in a hash database. Perl compatible regular expressions are supported both for storing and retrieving of data. It's main advantages are the ability to maintain huge amounts of data and speed. As of version 1.4 dbtool supports encrypted databases using the RIJNDAEL cipher algorithm.
A collection of tools for IBM's DB2 UDB
DiaDbDesigner is a standalone module for constructing databases with the help of the diagram creation program Dia. In an easy to use environment you can join multiple diagrams together to form one model of interconnected tables.
Dumpgdbm is a batch or interactive tool which can dump keys and data from a GNU DBM file. It can display data in ASCII, decimal, hex, and octal formats. Posix regexp search functions are also provided.
ElyCA is a certification authority (as well known as CA) written in Python released the General Public License (GPL) which provides an easy to use web interface to generate private keys, certificates, pkcs#12 and CRLs.
Emacs Photo Database
Emacs Photo Database provides functions for managing a collection of photographic films, negatives, and prints stored in a SQL database. It is targeted at fine-art photographers and other people who use a wet-process workflow instead of digital imaging.
EMS MySQL Manager
(commercial) EMS MySQL Manager is a powerful tool for MySQL® Database Server administration and development. MySQL Manager works with any MySQL versions from 3.23 to 5.02 and supports all of the latest MySQL features including views, stored procedures and functions, InnoDB foreign keys and so on. It offers plenty of powerful tools for experienced users to satisfy all their needs. MySQL Manager has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
EMS MySQL Utils
(commercial) Provides powerful data management utilities for MySQL Server, which make your work with the server much easier and faster. Currently MySQL Utils include MySQL Export - a powerful tool for MySQL data export, and MySQL Import - an utility for quick importing data to MySQL tables.
EMS PostgreSQL Utils
(commercial) Powerful data management utilities for PostgreSQL Server, which make your work with the server much easier and faster. Currently PostgreSQL Utils include PostgreSQL Export - a powerful tool for PostgreSQL data export, and PostgreSQL Import - an utility for quick importing data to PostgreSQL tables.
FileExtender is a Perl script to evaluate embedded SQL statements in any kind of text file (incl. HTML files) and extends these files with results from the database queries.
Freedbtool is a component of the Cjukebox music management system. It is a commandline tool for accessing the freedb.org database. It supports both download and upload of database files via the http version of the protocol. It also includes a modified version of Jeremy D. Zawodny's discid program
Fsdb, the flatfile streaming database, is a package of commands for manipulating flat-ASCII databases from shell scripts. Fsdb is useful to process medium amounts of data (with very little data you'd do it by hand, with megabytes you might want a real database). Fsdb was known as as Jdb.
GTK Entry: a program to do data entry into a MySQL database using an GTK GUI application.
Graffiti is an RDF store based on dynamic translation of RDF queries into SQL. It allows you to map any relational database schema into RDF semantics and vice-versa, and to store any RDF data in a relational database.
GreenSQL is a database firewall used to protect databases from SQL injection attacks. GreenSQL works in a proxy mode and has built-in support for MySQL. The logic is based on evaluation of SQL commands using a risk scoring matrix as well as blocking known DB administrative commands (such as DROP and CREATE).
GTK DBF Editor
GTK DBF Editor is a simple DBF editor built with GTK+. It allows basic editing of DBF (dBase) files.
HandySQL is a perl interface for MySQL. It connects directly to MySQL server, not using DBI/DBD and Mysql-msql modules. The main routines are written in C, and the top-level object-oriented interface is done in perl.
HashMan Database Tool
A tool for managing GDBM, traditional DBM and Berkeley/Sleepycat DB hashfiles. Database through a command line interface or an interactive terminal based interface.
IMDbPY is a Python package useful to retrieve and manage the data of the IMDb movie database about both movies and people. Platform-independent and written in pure Python (and few C lines), it can retrieve data from both the IMDb's web server and a local copy of the whole database.
InnoInfo is a small command-line utility to analyze and dump data from innodb databases. It works completely seperate from MySQL and accesses the innodb data files directly. It can also be used to recover data from broken innodb stores.
JasperETL is a complete and ready-to-run data integration platform for organizations of all sizes, providing high performance data extract-transform-load (ETL) capabilities. JasperETL is appropriate for all analytic and operational data integration needs, regardless of complexity. When used as part of the JasperSoft BI Suite, organizations can develop, manage, and document data integration processes for more accurate, more comprehensive reporting and online analytical processing (OLAP) with JasperReports, JasperServer, and JasperAnalysis.
KESI is a tool to easily import CSV files into your SQL database tables. CSV files can be created using almost every spreadsheet and lots of other applications (E.g. KSpread). KESI can be configured to understand almost every possible CSV format. Additionally it is very easy to use, because of its KDE GUI.
KFreeDB is a KDE interface to the FreeDB CD information database. It allows you to query the FreeDB disc database and also submit discs yourself. It is one of the very few applications that supports submitting by HTTP protocol.
The KSqlAnalyzer is a tool for easy accessing the data of a MS-SQL-Database. It is made for developing and testing new SQL-Query's direclty on the Server. The functionality and the look&feel are similar to the program 'SQL-Query-Analyzer' written by Microsoft.
(commercial) Lantica Sesame is a cross-platform database manager. It features a form and report designer, query by example, Symantec Q&A compatibility and translator, client/server operation, and an embedded programming language.
Libdejector is a database tool which defeats SQL injection attacks by performing context-free validation of queries. While written in C, SWIG wrappers exist for Python and other languages will be following soon.
Manqod is a desktop application for small companies to organize their data
on an interface customised for them by themselves
MDB Tools is a set of libraries and utilities for reading Microsoft Access database (MDB) files.
MTK-MYB provides a MySQL backup tool. This application was written with a focus on logging and monitoring. It comes with several addons for monitoring and reporting as well as backup integrity checks.
mtop (MySQL top) monitors a MySQL server showing the queries which are taking the most amount of time to complete. Features include 'zooming' in on a process to show the complete query, 'explaining' the query optimizer information for a query and 'killing' queries. In addition, server performance statistics, configuration information, and tuning tips are provided.
Mycli is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.
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 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.
Vitess is a storage platform for scaling MySQL. It is optimized to run as effectively in cloud architectures as it does on dedicated hardware. It combines many important features of MySQL with the scalability of a NoSQL database.
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. Read more
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
A python module needed as an interface between Zope and Kinterbasdb to access Firebird databases.