5 Open-Source SQL IDEs for You to Learn and Explore

MySQL MySQL Tools MySQL GUI Monitoring Tools

SQuirreL SQL Landing Page

1

SQuirreL SQL

SQuirreL SQL is an open-source Java SQL Client program for any JDBC compliant database

#Database Management #Databases #MySQL Tools
HeidiSQL Landing Page
2

HeidiSQL

HeidiSQL is a powerful and easy client for MySQL, MariaDB, Microsoft SQL Server and PostgreSQL. Open source and entirely free to use.
Pricing:
- Open Source
Just over half the age of Squirrel, HeidiSQL has been my personal favorite for the past three years. It’s more restricted in its range of databases (you only get MySQL/MariaDB, SQL Server and PostgreSQL) but for many, that’s enough. I’ve found it very fast, which is vital for projects such as a 29-million-rows table; a select count (*) SQL command against MariaDB running on my PC takes around two minutes.

#Database Management #Databases #MySQL Tools 1 user reviews
DBeaver Landing Page
3

DBeaver

DBeaver - Universal Database Manager and SQL Client.
Pricing:
- Open Source
One thing to note: DBeaver doesn’t install drivers at the start, but fetches them as you need them (this is very “Eclipse-like”). That’s probably because it’s built on the Eclipse platform, so if you’re used to that, you’ll feel right at home. Certainly I had no problems with it; it felt very snappy. The range of export formats includes CSV, HTML and XML, as well as JSON and Markdown.

#Databases #Database Management #MySQL Tools 106 social mentions
TOra Landing Page

4

TOra

tora - TOra is an open source SQL IDE for Oracle, MySQL and PostgreSQL dbs.

As you’d expect, Tora uses Qt for the user interface and is speedy, but it does feel a bit dated, especially when connecting to MySQL. If you’re working with Oracle, and you don’t have commercial software, use Tora; but for MySQL/PostgreSQL, or any of HeidiSQL, Squirrel and DBeaver is probably better.

#Database Management #Database Tools #Relational Databases
omnidb Landing Page

5

omnidb

NOTE: omnidb has been discontinued.

An Open Source Web Tool for Database Management and Conversion

I’m not a fan of web GUIs generally, but this looked great and works very well. HeidiSQL and DBeaver provide better import/export, but OmniDB is open to suggestions for future development. Just like the two Java clients, OmniDB is cross-platform, and has the most modern look and feel.

#Database Management #Databases #MySQL Tools