Recently a new joiner at our company asked me this. Where are SQL commands executed?
I said, as a programmer or database administrator, you’ll need a SQL editor to manage and edit 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 its own set of client-based SQL editor tools 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.
SQL editor tools for your evaluation
A unique tool for administering a database engine that is 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.
Has been around for quite some time and its database management tools are comprehensive, advanced, and reliable.
If you’re in need of 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 specific apps for Oracle, DB2, MySQL, SQL Server, etc. Its other freeware includes a data modeler, an extension for visual studio, a benchmark factory, and more.
PhpMyAdmin Is one of my favorite SQL editors simply because I use it a lot.
Since this website is using WordPress and MySQL, I use PHPMyAdmin as a SQL editor extensively to manage my database from checking table records to deleting unwanted data.
If your database is on MySQL, then look nowhere else. PhpMyAdmin is the best database administration tool for you provided you’re also into PHP. 🙂
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 the ability to migrate 3rd party databases to Oracle.
A universal SQL client that is capable of data browsing in tables, issuing SQL commands, and more.
The SQL editor is a graphical Java program that allows you to connect to JDBC-compliant databases.
Some new enhancements for its latest release include using RText as the default editor instead of the classic Netbeans editor, and a new plugin for the Netezza database.
A universal database management tool for a heterogeneous environment.
WinSQL users generally use the tool to perform database administration tasks such as importing and exporting data, generating test data, reverse engineering existing databases, and more.
Check out the top 10 reasons why you should use WinSQL.
A universal database tool that works on all major operating systems including 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 versions.
It is usually treated as an alternative to SQL*Plus for connection to Oracle via JDBC.
With SQLpal, you won’t need to have the Oracle client installation file and thus can be placed on USB thumb drives for easy access and connection to Oracle.
The download file is only 9MB in size and is available for Windows only.
————— End of list of free or Open Source SQL editor tools —————-
There you go, a couple of free or open source SQL editor tools for all your Database SQL management purposes. Enjoy!
Is SQL hard to learn? And where can I practice SQL for free?
This 4 hours video by freecodecamp.org is all you need in order to learn SQL where it covers the following topics.
Introduction to SQL, What is a Database?, Tables & Keys, SQL Basics, MySQL Windows Installation, MySQL Mac, Installation, Creating Tables, Inserting Data, Constraints, Update & Delete, Basic Queries, Company Database Intro, Creating Company Database, More Basic Queries, Functions, Wildcards, Union, Joins, Nested Queries, On Delete, Triggers, ER Diagrams Intro, Designing an ER Diagram, Converting ER Diagrams to Schemas.
Can I run SQL editor online?
Yes! Of course, you can!
An online SQL IDE that allows you to execute SQL statements online.
Great if you would like to test your SQL statements without having to launch your favorite SQL Editors.
PHPRunner also worth checking – one of the best PHP code generators. http://xlinesoft.com/phprunner/index.htm
like your article, and I would like to choose a online ide for mysql, including a function about censoring user’s sql and nominate it’s user, do you have any suggestion about it?, ps, have to be free
Some of these are not free, just that they offer a 30 day trial, for free (AnySQL Maestro, TOAD, etc.).