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
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.
A package of commands for manipulating flat-ASCII databases from shell scripts. JDB is useful to process medium amounts of data.
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.
Maatkit is a set of high-quality command-line tools for open-source databases, such as MySQL and PostgreSQL. The tools enable power users to do their work more safely and quickly by relying on tested software instead of scripting things themselves. Read more
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.