List of free or open source SQL editor tools
As a programmer or database administrator, you’ll need the ability to manage databases for your applications.
A good SQL editor is usually required to run sql queries for all sorts of functions such as adding and editing data, adding and dropping tables, etc.
Each database usually has it’s own set of client based SQL editor tool which allows a client machine to connect to the database server to perform database administration work.
All you need in order to log into the database is the correct credentials (username and password).
Sometimes, the client tool for the database may not be available and you need the ability to quickly access the database to check some table records.
If this is the case then here is a list of free or open source SQL editor tools for you to begin running SQL queries against your DB.
AnySQL Maestro is a unique tool for administering database engine which are accessible via ODBC driver or OLE DB provider.
The reason why I placed this as the first is because of its vast support for many types of databases such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc.
If you’re a programmer needing to connect to several types of databases, then this tool will come in very handy for you.
Toad has been around for quite some time and its database management tools are comprehensive, advanced and reliable.
If you’re in need for support and have questions related to the tools as well as database related queries, the Toad community is where you can get lots of help, resources and videos.
Toad has got specific apps for Oracle, DB2, MySQL, SQL Server, etc. It’s other freewares include a data modeler, extension for visual studio, benchmark factory and more.
PHPMyAdmin is one of my favorite SQL editor simply because I use it a lot.
Since this website is on WordPress and MySQL, I use PHPMyAdmin extensively to manage my database from checking table records to deleting unwanted data.
If your database is on MySQL, then look no where else. PhpMyAdmin is the best database administration tool for you provided you’re also into PHP.
Oracle SQL Developer is a free and fully supported graphical tool for Oracle database development and connects to Oracle version 10g and up.
There are versions for Windows, Linux and Mac OSX.
With this tool, you can browse database objects, edit and debug PL/SQL statements, run reports and more. Another strong feature includes ability to migrate 3rd party databases to Oracle.
SQuirreL SQL is a universal SQL Client capable of data browsing in tables, issuing SQL commands and more.
The SQL editor is a graphical Java program which allows you to connect to JDBC compliant databases.
Some new enhancements for its latest release includes using RText as the default editor instead of the classic Netbeans editor, new plugin for Netezza database and more.
WinSQL is a universal database management tool for heterogeneous environment.
WinSQL users generally use the tool to perform database administrative tasks such as importing and exporting data, generating test data, reverse engineer existing databases and more.
Check out the top 10 reason why you should use WinSQL.
SQLpal is usually treated as an alternative to SQL*Plus for connection to Oracle via JDBC.
With SQLpal, you wont need to have the Oracle client installation file and thus can be placed on USB thumbdrives for easy access and connection to Oracle.
The download file is only 9MB in size and is available for Windows only.
DBVisualizer is a universal database tool which works on all major operating systems including for Mac OS.
Some key functions include database object management, table data management, SQL tools and DB server management.
At the moment DbVisualizer comes in two flavors: Personal edition and Free edition. This feature list shows the difference between both version.
————— End of list of free or open source SQL editor tools —————-
There you go! 8 free or open source SQL editor tools for all your Database SQL management purposes. Enjoy!Thanks for reading! Read more articles by Bob Lee :)