Top Free or Open Source SQL Database Manager Tools

MySQL Database itself doesn’t have any king GUI (Graphical User interface) to easily manage the created database and its users. So, if you are not very much acquainted with the command line interface then it would be a pain to manage databases, moreover, even professionals need some MySQL GUI tool when it comes to handling large databases. So, either you are a newbie or profession, the GUI based tools to manage the MySQL will help you a lot.

1. MySQL Workbench

MySQL Workbench is a most reliable tool to provide GUI interface to MySQL Database system because it also developed the MySQL developers, the Oracle. The MySQL Workbench is available for all three major operating systems: Windows, MacOS and Linux. It gives the capability to a user to visually design databases with access to some other tools for SQL development, Database Design & Modeling, SQL Development, Database Administration ,Database Migration, monitoring and maintenance from the single unified graphical user interface

Website: http://dev.mysql.com/downloads/workbench/
Price: FREE
License: GPL License

2. DBeaver


DBeaver is another up to date database administration tool with GUI (graphical user interface). It provides an SQL client that uses JDBC API via JDBC driver to interact with the relational databases. It provides a modular architecture as its features can be enhanced using the plugins which are based on Eclipse plugin system or architecture. Furthermore, the DBeaver comes with an editor where the syntax highlighting and auto code completion are also possible.
It is developed in Java and based on the Eclipse platform. DBeaver is available in both enterprise and open source versions. The open source one is free to use and distribute. It supports a variety of databases such as MySQL and MariaDB; PostgreSQL, DB2 (LUW), EXASOL, Teradata, Vertica, Apache Phoenix, Netezza, H2, SQLite, SnappyData and more. Available for Windows, MacOS, Linux and Eclipse (using plugin).

Website: https://dbeaver.io/
Price: FREE
License: GPL License

3. HeidiSQL


HeidiSQL is also free and open source MySQL administration tool to provide a GUI front-end. It even works for the MySQL forks including Microsoft SQL Server and PostgreSQL. HeidiSQL was originally pulled from another software code-named as MySQL front 2.5 software by the German developer Ansgar Becker. It features all common features those you get in the MySQL Workbench from managing databases to tables, views, procedures, triggers and events. However, the best thing apart for Windows and MacOS, it also available in Portable version; which means you can save it on a Pendrive and use on the go on any system.

Website: Link
Price: FREE
License: Open source

4. phpMyAdmin


phpMyAdmin is another open source MySQL database management tool written in PHP. It provides a web interface to connect the MySQL and MariaDB server. It allows databases to manage tables, columns, relations, indexes, users, permissions, etc. It is a most popular tool that used in most of the hosting platform to give graphical user environment to manage Database and its user, and ability to directly execute any SQL statement.
It is available in 72 languages and supports both LTR and RTL languages.

Website: Link
Price: FREE
License: Open source

Post a Comment

0 Comments