mysql2mongo - MySQL to MongoDB importer

•    PHP

---

MySQL to MongoDB importer. The scripts are using simple relational to non-relational (r2n) mapping mechanism that should let You automagically convert Your MySQL database into MongoDB set of collections.

mysql-to-mongodb database-import database-tools

SQLToNoSQLImporter - Import data from SQL to NoSQL systems

•    Java

---

SQLToNoSQLImporter is a Solr like data import handler to import Sql (MySQL,Oracle,PostgreSQL) data to NoSQL Systems (Mongodb,CouchDB,Elastic Search). Migration is now completely configuration driven. SQLToNoSQLImporter reads from sql databases, converts and then batch inserts them into NoSQL datastore.

sql-to-nosql mysql-to-mongodb database-import database-tools

mongify

•    Ruby

---

Mongify allows you to map your data from a sql database and into a mongodb document database.

Elasticsearch-Exporter - A small script to export data from one Elasticsearch cluster into another.

•    Javascript

---

A command line script to import/export data from ElasticSearch to various other storage systems. This is a brand new implementation with lots of bugs and way too little time to test everything for one lonely developer, so please consider this beta at best and provide feedback, bug reports and maybe even patches.

export import elastichsearch data-pump file transfer tools cli command-line database backup restore archive synchronize dump replicate mongodb mysql csv hbase datastore bigquery

JugglingDB - Multi-database ORM in NodeJS

•    Javascript

---

JugglingDB is cross-db ORM for nodejs, providing common interface to access most popular database formats. Currently supported are: mysql, sqlite3, postgres, mongodb, redis and js-memory-storage (yep, self-written engine for test-usage only). You can add your favorite database adapter, checkout one of the existing adapters to learn how.

orm db-tools nodejs-orm database-adaptor

DBeaver - Universal SQL Manager and SQL Client

•    Java

---

DBeaver is a multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. Its feature include metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.

database-tool database-management database-administration sql-client

mysql-country-list - mysql insert country list into database

•    PHP

---

Use this mysql to import a list of countries into your database. Use PHPmyAdmin to import the SQL file into your database.

migrate - Database migrations. CLI and Golang library.

•    Go

---

Database migrations written in Go. Use as CLI or import as library.

migration migrations database postgres cassandra sqlite mysql neo4j mongodb crate ql databases sql mariadb spanner google-cloud-spanner aws-s3 google-cloud-storage database-migration

mysql - Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package

•    Go

---

Make sure Git is installed on your machine and in your system's PATH.Go MySQL Driver is an implementation of Go's database/sql/driver interface. You only need to import the driver and can use the full database/sql API then.

mysql sql database mysql-driver

jugglingdb - Multi-database ORM for nodejs: redis, mongodb, mysql, sqlite3, postgresql, arango, in-memory

•    Javascript

---

JugglingDB is cross-db ORM for nodejs, providing common interface to access most popular database formats. Currently supported are: mysql, sqlite3, postgres, mongodb, redis and js-memory-storage (yep, self-written engine for test-usage only). You can add your favorite database adapter, checkout one of the existing adapters to learn how. Jugglingdb also works on client-side (using WebService and Memory adapters), which allows to write rich client-side apps talking to server using JSON API.

PHPMyAdmin

•    PHP

---

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

database-front-end adminstration tool mysql-admin mysql-management mysql-tool

Sequel Pro - MySQL Database management for Mac

•    PHP

---

Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. It gives you direct access to your MySQL databases on local and remote server. It supports Full table management including indexes and MySQL Views.

database-front-end adminstration tool mysql-front-end mysql-gui

MySQL-Front - A GUI front end for the MySQL and MariaDB database servers

•    Pascal

---

MySQL-Front is a Windows front end program for the MySQL database server. The database structure and data can be handled via dialogs or SQL commands. Import and Export in standard file formats is supported. The database server can be connected directly or via HTTP tunneling.

database-front-end adminstration tool mysql-front-end mysql-gui mariadb-gui mariadb-front-end

Chinook Database

•    

---

Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script. Chinook database is an alternative to the Northwind database, being ideal for demos and testing ORM tools targeting single and multiple database servers.

database sql-server database-tools effiproz mysql oracle sample-databases

mosql - MongoDB to PostgreSQL Streaming Replication

•    Ruby

---

MoSQL imports the contents of your MongoDB database cluster into a PostgreSQL instance, using an oplog tailer to keep the SQL mirror live up-to-date. This lets you run production services against a MongoDB database, and then run offline analytics or reporting using the full power of SQL.

database-replication database-utilities db-tools

phpMoAdmin - MongoDB administration tool for PHP

•    PHP

---

phpMoAdmin is a MongoDB administration tool for PHP. It helps to create, drop and repair database and indexes. It provides support to view and search on data, Provides stats on database uptime and memory, Import/export data in JSON format.

db-tool administration-tool mongodb mongodb-admin mongodb-tool

MongoDB SQL Server Importer

•    

---

If you want a quick (but kinda dirty) way to import your SQL Server database to MongoDB, this is your tool. This tool is for those who wants to leverage their existing database to learn MongoDB. It's developed in C#.

mongodb converter mongo sql-server

MySQL Workbench - Visual database design tool for MySQL

•    C++

---

MySQL Workbench is a visual database design tool. The tool is specifically for designing MySQL database. MySQL Workbench provides DBAs and developers an integrated tools for Database Design & Modeling, Query browser, Database Administration.

mysql-admin mysql-management administration tool mysql-tool

SQLTransmutate - Converts one database to another using SQLAlchemy

•    Python

---

SQLTransmutate helps to converts one database to another using SQLAlchemy. It inspects a database, creates the same schema in another database with another engine, then copies over all the data. It has no knowledge whatsoever of which databases it's moving from and to. Whatever SQLAlchemy can handle, this script can handle. Currently it supports MySQL and PostgreSQL.

database-tools db-tools convert-database

Coolstorage - ORM library for .NET

•    CSharp

---

The main strength of Vici CoolStorage is the ease of use. Most ORM tools still require a lot of unneeded code to accomplish basic data persistence tasks, but Vici CoolStorage is designed to relieve the programmer from these tedious and error-prone tasks, making it very intuitive to use.

orm persistence database-development datamapper ormdotnet