MySQL Database Tools - Data Administration, Migration, Business Intelligence, ORM

 

Open Source MySQL Tools

 

Adminer

Adminer (formerly phpMinAdmin) is a full-featured MySQL management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server.


Bristlecone

Bristlecone provides tools for testing database performance. There are two main tools included in the package. * Evaluator generates mixed loads of inserts, updates, deletes, and selects. Output can be built-in graphics, HTML, XML, or CSV. * Benchmark runs performance test cases with systematically varying parameters. Output can be HTML or CSV. The Bristlecone tools were designed for comparative evaluations of database clusters. They include built-in support for threading, ability to generate new tests quickly with simple configuration file changes, and the ability to do systematic tests across different database implementations. Bristlecone is written in Java. It has mostly run on Linux but is easily adaptable to other platforms. Bristlecone has been tested against the following database types: PostgreSQL, MySQL, and HSQLDB (Hypersonic).


datascooter

This is not only ORM tool but much more: small, fast, modular software purposed for interaction with any database. You may to work with any database just to put wright plugin into plugins directory of you application. Now available plugins for Oracle,DB2,MSSQl, MySql, PostgreSql.


DB Designer Fork

DB Designer Fork is a fork of the fabFORCE DBDesigner 4. DBDesigner is a visual database design system that integrates entity relationship design and database creation. DB Designer Fork generates SQL scripts for Oracle, SQL Server, MySQL and FireBird.


dbdeploy

dbdeploy is a Database Change Management tool. Its for developers or DBAs who want to evolve their database design - or refactor their database - in a simple, controlled, flexible and frequent manner.


DBEdit

DBEdit is a database editing tool, written in Java, which is suitable as a front-end GUI for your Oracle, DB2 or MySQL database. DBEdit's core functionalities provide aid to common data editing tasks and reporting, as well as database synchronization.


DbLinq

DbLinq is THE LINQ provider that allows to use common databases with an API close to Linq to SQL. It currently supports (by order of appearance): MySQL, Oracle, PostgreSQL, SQLite, Ingres, Firebird... And still SQL Server.


DbMaintain

DbMaintain enables automatic roll-out of updates to a relational database. It brings database scripts into version control just like regular source code and can be used to transparently deploy databases from development to production. DbMaintain automates the part of the deployment which is most difficult to automate, opening the door for fully automated deployments in all stages of development.


deltasql

deltasql is an advanced Schema Version Control. It is like cvs, but for databases. It allows a team to commonly develop a data model on the fly, while the source code is growing. Branches for production schemas / mySQL, postgreSQL and Oracle supported


Drizzle

Drizzle is a High-Performance Microkernel DBMS for Scale-Out Applications. Drizzle is a community-driven project based on the popular MySQL DBMS that is focused on MySQL's original goals of ease-of-use, reliability and performance.


Eclipse SQL Explorer

Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases. The application is available as a standalone client or as a plugin for Eclipse


EclipseLink

The Eclipse Persistence Services Project (EclipseLink) project's goal is to provide a complete persistence framework that is both comprehensive and universal. It will run in any Java environment and read and write objects to virtually any type of data source, including relational databases, XML, or EIS systems.


Enhydra Octopus

Enhydra Octopus is a Java-based Extraction, Transformation, and Loading (ETL) tool. It may connect to any JDBC data sources and perform transformations defined in an XML file. DODS data models are supported by generating oid's for new objects. Natural keys can be used to insert/update existing data and create relationships with oid's. A loadjob-generator is provided to generate Octopus loadjob skeletons from an existing database. Many different types of databases can be mixed (MSSQL, Oracle, DB2, QED, JDBC-ODBC with Excel and Access, MySQL, CSV-files, XML-files,...) Four special JDBC drivers come with Octopus to support JDBC access to CSV-files (CSV-JDBC), MS-SQL (FreeTDS), XML (XML-JDBC) and property files (i18n-JDBC). Octopus supports Ant and JUnit to create a database / tables and extract /load data during a build or test process.


ERDesigner

Entity Relationship Designer written totally in java and based on Mogwai ER Designer. Includes ability to connect to several data sources including mySQL.


ERmodeller

Application Ermodeller is a free CASE tool for data modelling which is built in Java. This tool supports conceptual and logical data modelling and in the final step, it allows to create physical model that is specific for particular DBMS. Basic features: Three levels of data modelling: Conceptual, Logical & Physical Support of multiple DBMS SQL generation to file or directly to database via JDBC Reverse engineering from DB Model validation


Friendly

NoSQL with MySQL in Ruby


google-mysql-tools

Various tools for managing, maintaining, and improving the performance of MySQL databases, originally written by Google.


Habanero Pro

Habanero is an object-relational mapping (ORM) architecture for .Net that maps object-oriented code to relational databases. It persists data to and from the database and generates user interfaces to edit the object's properties. Habanero can read class design from the database and generate code for the business objects to be mapped.


HeidiSQL

HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows interface.


innotop

innotop is a powerful monitor for MySQL queries and status information. It is designed to monitor InnoDB transactions and internals, replication status, deadlocks, general queries and status values, and much more.


Jailer

Jailer simplifies the extraction of referentially intact data. Once you have defined an extraction model, it can be used to extract data from the production database fast and easy whenever up-to-date test data is required. Features * Exports consistent and referentially intact row-sets from your productive database and imports the data into your development and test environment. * Improves database performance by removing and archiving obsolete data without violating integrity. * Mass data export to XML and SQL. * Generates hierarchically structured XML and topologically sorted SQL-DML. * Open Source. Entirely written in Java. Platform independent. DBMS agnostic.


LiquiBase

LiquiBase is an open source (LGPL), DBMS-independent library for tracking, managing and applying database changes. It is built on a simple premise: All database changes (structure and data) are stored in an XML-based descriptive manner and checked into source control.


Maatkit

Maatkit makes MySQL easier and safer to manage. It provides simple, predictable ways to do things you cannot otherwise do. It would be nice if these features were included with MySQL, but they are not. That's why Maatkit is now shipping by default with many GNU/Linux distributions such as Debian and CentOS. You can use Maatkit to prove replication is working correctly, fix corrupted data, automate repetitive tasks, speed up your servers, and much, much more.


MariaDB

MariaDB is a community developed branch of the MySQL database that uses the Maria engine by default.


MIGRATEdb

MIGRATEdb will parse an XML file of database changes and load them to the targeted database if they are not already there. A database change consists of tests to determine whether the change has already been applied and a set of change actions.


MyGeneration

The Free Code Generator / OR Mapping Tool: * MyGeneration's dOOdads Architecture Included for Both C# and VB.NET (Quickstart) * Supported Architectures - dOOdads, EntitySpaces, EasyObjects.NET/EntLib, Gentle.NET, Opf3, NHibernate, Microsoft's DAAB, DotNetNuke, iBatis * Support for Twelve Different Database Systems. Microsoft SQL, Oracle, IBM DB2, PostgreSQL, Microsoft Access, FireBird, Interbase, VistaDB, SQLite, MySQL, Advantage and Pervasive * Template Based Code Generator Supporting Four Template Languages - JScript, VBScript, C# and VB.NET


MySQL

Open source database


MySQL Control Center

MySQL Control Center is an excellent GUI front end for MySQL database creation and administration. It allows multiple concurrent MySQL server connections, MDI (or not under Linux), stored login credentials, point and click dump file imports and more.


MySQL Workbench

MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.


Open ModelSphere

Open ModelSphere is a powerful data, process and UML modeling tool. It covers conceptual and logical data modeling as well as physical design. It supports several notations, e.g. Entity-Relationship, DATARUN and Information Engineering. Conceptual models can be converted to relational models and vice versa. Open ModelSphere provides the functionality of a rich UML modeling software. You can create Activity, Class, Collaboration, Component, Deployment, Package, Sequence, Statechart and Use Case diagrams.


phpMyAdmin

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats and is available in 50 languages. GPL License information.


Sequel Pro

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.


SQL Buddy

Web based MySQL administration tool


SQL Relay

SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix and Linux.


SQLObject

SQLObject is an object-relational mapper for Python. It supports MySQL, PostgreSQL, SQLite, Firebird, MaxDB/SapDB, MS SQL and Sybase. It supports Python versions back to 2.4


Super Smack

Super Smack is a benchmarking, stress testing, and load generation tool for MySQL (and PostgreSQL).


Talend Open Studio

The first pure play provider of open source data integration software, Talend offers open, innovative and powerful data integration solutions, used primarily for integration between operational systems, ETL, and migration by organizations of all sizes.


TOra

TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms. In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools.


utMySQL

utMySQL is a unit test frame work for MySQL V 5 using stored procedures. utMysql is an Open Source project, using the GNU General Public License (GPL) and is operating system independent. Stored procedure in MySQL V5.0 are very useful in removing the database query layer from server side scripting. It is entirely possible to develop and maintain the database layer separately from the server side code.