{"id":4461,"date":"2010-07-26T00:17:33","date_gmt":"2010-07-25T16:17:33","guid":{"rendered":"http:\/\/www.softwareforenterprise.us\/?p=4461"},"modified":"2025-12-20T22:29:03","modified_gmt":"2025-12-20T14:29:03","slug":"list-free-open-source-sql-editor-tools","status":"publish","type":"post","link":"https:\/\/www.softwareforenterprise.us\/hub\/list-free-open-source-sql-editor-tools\/","title":{"rendered":"SQL editor tools which are free or open source"},"content":{"rendered":"<p>Recently a new joiner at our company asked me this. Where are SQL commands executed?<\/p>\n<p>I said, as a programmer or database administrator, you&#8217;ll need a SQL editor to manage and edit databases for your <a title=\"\" class=\"aalmanual\" target=\"_blank\"  rel=\"nofollow\"   style=\"color:#1e73be;\" href=\"https:\/\/partners.webydo.com\/6wdx17ttbarj\">applications<\/a>.<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>All you need in order to log into the database\u00a0is the correct <a title=\"\" class=\"aalmanual\" target=\"_blank\"  rel=\"nofollow\"   style=\"color:#1e73be;\" href=\"https:\/\/keepersecurity.partnerlinks.io\/qns375ot4fmt-1yt2lb\">credentials<\/a> (username and password).<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<div class='code-block code-block-1' style='margin: 8px 0; clear: both;'>\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7371812982681123\"\n     crossorigin=\"anonymous\"><\/script>\n<ins class=\"adsbygoogle\"\n     style=\"display:block; text-align:center;\"\n     data-ad-layout=\"in-article\"\n     data-ad-format=\"fluid\"\n     data-ad-client=\"ca-pub-7371812982681123\"\n     data-ad-slot=\"4279787798\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/div>\n\n<h2>SQL editor tools for your evaluation<\/h2>\n<p><a href=\"https:\/\/www.sqlmaestro.com\/products\/anysql\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-4616 size-full lazyload\" title=\"SQLMaestro\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/SQLMaestro.png\" alt=\"SQL Maestro SQL Editor Tool\" width=\"208\" height=\"81\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 208px; --smush-placeholder-aspect-ratio: 208\/81;\" \/><\/a><\/p>\n<p>A unique tool for administering a database engine that is accessible via ODBC driver or OLE DB provider.<\/p>\n<p>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.<\/p>\n<p>If you&#8217;re a programmer needing to connect to several types of databases, then this tool will come in very handy for you.<\/p>\n<div class=\"lyte-wrapper\" title=\"SQL Maestro for MySQL. Introduction Video\" style=\"width:640px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_KWuW62oWwjg\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FKWuW62oWwjg%2Fhqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/KWuW62oWwjg\" \/><meta itemprop=\"duration\" content=\"PT2M51S\" \/><meta itemprop=\"uploadDate\" content=\"2017-12-08T09:44:46Z\" \/><\/div><div id=\"lyte_KWuW62oWwjg\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FKWuW62oWwjg%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">SQL Maestro for MySQL. Introduction Video<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/KWuW62oWwjg\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FKWuW62oWwjg%2F0.jpg\" alt=\"SQL Maestro for MySQL. Introduction Video\" width=\"640\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"This video covers basic features of SQL Maestro for MySQL. You will know what the tool is, how it works, and how it can help you to work with MySQL and MariaDB databases. Free trial is available at https:\/\/www.sqlmaestro.com\/products\/mysql\/maestro\/download\/\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:640px;margin:5px auto;\"><\/div><\/p>\n<p><img decoding=\"async\" class=\"alignnone wp-image-4619 size-full lazyload\" title=\"toad\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/toad.png\" alt=\"Toad World SQL Editor Tool\" width=\"350\" height=\"111\" data-srcset=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/toad.png 350w, https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/toad-300x95.png 300w\" data-sizes=\"(max-width: 350px) 100vw, 350px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 350px; --smush-placeholder-aspect-ratio: 350\/111;\" \/><\/p>\n<p>Has been around for quite some time and its database management tools are comprehensive, advanced, and reliable.<\/p>\n<p>If you&#8217;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.<\/p>\n<p>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.<\/p>\n<div class=\"lyte-wrapper\" title=\"Getting started with the editor in Toad for SQL Server\" style=\"width:640px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_OkjC2Gg7MtI\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FOkjC2Gg7MtI%2Fhqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/OkjC2Gg7MtI\" \/><meta itemprop=\"duration\" content=\"PT5M44S\" \/><meta itemprop=\"uploadDate\" content=\"2017-03-10T19:02:31Z\" \/><\/div><div id=\"lyte_OkjC2Gg7MtI\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FOkjC2Gg7MtI%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">Getting started with the editor in Toad for SQL Server<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/OkjC2Gg7MtI\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FOkjC2Gg7MtI%2F0.jpg\" alt=\"Getting started with the editor in Toad for SQL Server\" width=\"640\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"This video gives a brief overview of the editor in Toad for SQL Server. Topics include how to open and change connections, and features of the tool bar, editing area, and results window. To learn more, visit: http:\/\/quest.com\/products\/toad-for-sql-server\/\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:640px;margin:5px auto;\"><\/div><\/p>\n<p><a href=\"https:\/\/www.phpmyadmin.net\/home_page\/index.php\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-4620 size-full lazyload\" title=\"phpmyadmin\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/phpmyadmin.png\" alt=\"phpmyadmin SQL Editor Tool\" width=\"184\" height=\"136\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 184px; --smush-placeholder-aspect-ratio: 184\/136;\" \/><\/a><\/p>\n<p>PhpMyAdmin Is one of my favorite SQL editors simply because I use it a lot.<\/p>\n<p>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.<\/p>\n<p>If your database is on MySQL, then look nowhere else. PhpMyAdmin is the best database administration tool for you provided you&#8217;re also into PHP. \ud83d\ude42<\/p>\n<div class=\"lyte-wrapper\" title=\"PhpMyAdmin Tutorial for Beginners\" style=\"width:640px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_JgAyGjcNrIQ\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FJgAyGjcNrIQ%2Fhqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/JgAyGjcNrIQ\" \/><meta itemprop=\"duration\" content=\"PT14M36S\" \/><meta itemprop=\"uploadDate\" content=\"2014-05-16T06:28:23Z\" \/><\/div><div id=\"lyte_JgAyGjcNrIQ\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FJgAyGjcNrIQ%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">PhpMyAdmin Tutorial for Beginners<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/JgAyGjcNrIQ\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FJgAyGjcNrIQ%2F0.jpg\" alt=\"PhpMyAdmin Tutorial for Beginners\" width=\"640\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"This tutorial will teach you how to perform tasks on MySQL database using web interface of PHPMyAdmin. You&#039;ll learn how to create database, table, perform sql query and learn various configuration available with phpmyadmin dashboard.\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:640px;margin:5px auto;\"><\/div><\/p>\n<p><a href=\"https:\/\/www.oracle.com\/technology\/products\/database\/sql_developer\/index.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-4622 size-full lazyload\" title=\"oracle sql developer\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/oracle-sql-developer.png\" alt=\"Oracle SQL Developer SQL Editor Tool\" width=\"220\" height=\"123\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 220px; --smush-placeholder-aspect-ratio: 220\/123;\" \/><\/a><\/p>\n<p>A\u00a0free and fully supported graphical tool for Oracle database development and connects to Oracle version 10g and up.<\/p>\n<p>There are versions for Windows, Linux, and Mac OSX.<\/p>\n<p>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.<\/p>\n<div class=\"lyte-wrapper\" title=\"Oracle SQL Developer: Product Demonstration\" style=\"width:640px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_EguMf4HbPU8\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FEguMf4HbPU8%2Fhqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/EguMf4HbPU8\" \/><meta itemprop=\"duration\" content=\"PT1H4M26S\" \/><meta itemprop=\"uploadDate\" content=\"2017-08-09T16:49:02Z\" \/><\/div><div id=\"lyte_EguMf4HbPU8\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FEguMf4HbPU8%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">Oracle SQL <a title=\"Remote Jobs with Turing\" class=\"aalmanual\" target=\"_blank\"  rel=\"nofollow\"   style=\"color:#1e73be;\"href=\"https:\/\/www.softwareforenterprise.us\/hub\/recommends\/agile\/\">Developer<\/a>: Product Demonstration<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/EguMf4HbPU8\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FEguMf4HbPU8%2F0.jpg\" alt=\"Oracle SQL Developer: Product Demonstration\" width=\"640\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"60 minute overview of the product including a demo. Bookmarks, as this is a LONG Video: 09:32 - Release History 12:38 - Feature List\/Summary 17:25 - End of PPT Show, Live Demo The Worksheet 42:27 - Exploring your Schema with the GUI 48:15 - Working with PL\/SQL 54:22 - Using the Debugger 59:30 - Reports 1:02:30 - How to find objects\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:640px;margin:5px auto;\"><\/div><\/p>\n<p><a href=\"http:\/\/www.squirrelsql.org\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-4623 size-full lazyload\" title=\"squirrel sql\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/squirrel-sql.png\" alt=\"Squirrel SQL Editor Tool\" width=\"300\" height=\"86\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/86;\" \/><\/a><\/p>\n<p>A universal SQL client that is capable of data browsing in tables, issuing SQL commands, and more.<\/p>\n<p>The SQL editor is a graphical Java program that allows you to connect to JDBC-compliant databases.<\/p>\n<p>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.<\/p>\n<div class=\"lyte-wrapper\" title=\"squirrelSQL\" style=\"width:640px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_NldYgRAANOo\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FNldYgRAANOo%2Fhqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/NldYgRAANOo\" \/><meta itemprop=\"duration\" content=\"PT8M42S\" \/><meta itemprop=\"uploadDate\" content=\"2017-01-05T23:55:01Z\" \/><\/div><div id=\"lyte_NldYgRAANOo\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FNldYgRAANOo%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">squirrelSQL<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/NldYgRAANOo\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FNldYgRAANOo%2F0.jpg\" alt=\"squirrelSQL\" width=\"640\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"This is a fast paced video that shows how to install Squirrelsql and make it work with a local installation of MySql.\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:640px;margin:5px auto;\"><\/div><\/p>\n<p><a href=\"https:\/\/www.synametrics.com\/SynametricsWebApp\/WinSQL.jsp\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-4625 size-full lazyload\" title=\"winsql\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/winsql.png\" alt=\"Synametrics Technologies SQL Editor Tool\" width=\"300\" height=\"77\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 300px; --smush-placeholder-aspect-ratio: 300\/77;\" \/><\/a><\/p>\n<p>A universal database management tool for a heterogeneous environment.<\/p>\n<p>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.<\/p>\n<p>Check out the top <a href=\"https:\/\/www.synametrics.com\/SynametricsWebApp\/WinSQLTopTen.jsp\" target=\"_blank\" rel=\"noopener noreferrer\">10 reasons why you should use WinSQL<\/a>.<\/p>\n<div class=\"lyte-wrapper\" title=\"WinSQL: A Universal Database Query Tool\" style=\"width:640px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_RIWyw55_WEQ\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FRIWyw55_WEQ%2Fhqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/RIWyw55_WEQ\" \/><meta itemprop=\"duration\" content=\"PT1M11S\" \/><meta itemprop=\"uploadDate\" content=\"2019-02-28T15:56:24Z\" \/><\/div><div id=\"lyte_RIWyw55_WEQ\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FRIWyw55_WEQ%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">WinSQL: A Universal Database Query Tool<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/RIWyw55_WEQ\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FRIWyw55_WEQ%2F0.jpg\" alt=\"WinSQL: A Universal Database Query Tool\" width=\"640\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"WinSQL is a universal database management tool that works with almost every relational database in the market. It&#039;s like a Swiss Army Knife for individuals who work with multiple databases in their day-to-day life. Try WinSQL Free for 30 Days http:\/\/web.synametrics.com\/WinSQL.htm\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:640px;margin:5px auto;\"><\/div><\/p>\n<div class='code-block code-block-2' style='margin: 8px 0; clear: both;'>\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7371812982681123\"\n     crossorigin=\"anonymous\"><\/script>\n<!-- Responsive ads -->\n<ins class=\"adsbygoogle\"\n     style=\"display:block\"\n     data-ad-client=\"ca-pub-7371812982681123\"\n     data-ad-slot=\"5373377611\"\n     data-ad-format=\"auto\"\n     data-full-width-responsive=\"true\"><\/ins>\n<script>\n     (adsbygoogle = window.adsbygoogle || []).push({});\n<\/script><\/div>\n\n<p><a href=\"https:\/\/www.dbvis.com\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-4627 size-full lazyload\" title=\"DBVisualizer\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/DBVisualizer.png\" alt=\"DBVis Software SQL Editor Tool\" width=\"232\" height=\"86\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 232px; --smush-placeholder-aspect-ratio: 232\/86;\" \/><\/a><\/p>\n<p>A universal database tool that works on all major operating systems including Mac OS.<\/p>\n<p>Some key functions include database object management, table data management, SQL tools, and DB server management.<\/p>\n<p>At the moment DbVisualizer comes in two flavors: Personal edition and Free edition. This feature list shows the difference between both versions.<\/p>\n<div class=\"lyte-wrapper\" title=\"DbVisualizer Pro Connect to PostgreSQL Server\" style=\"width:640px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_WMkL526V7nw\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FWMkL526V7nw%2Fhqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/WMkL526V7nw\" \/><meta itemprop=\"duration\" content=\"PT5M24S\" \/><meta itemprop=\"uploadDate\" content=\"2018-11-28T21:30:59Z\" \/><\/div><div id=\"lyte_WMkL526V7nw\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FWMkL526V7nw%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">DbVisualizer Pro Connect to PostgreSQL Server<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/WMkL526V7nw\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FWMkL526V7nw%2F0.jpg\" alt=\"DbVisualizer Pro Connect to PostgreSQL Server\" width=\"640\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"Tutorial how to connect DBVisualizer Pro to PostgreSQL Server. For DBVisualizer Pro download, please visit the following link: https:\/\/www.dbvis.com\/download\/\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:640px;margin:5px auto;\"><\/div><\/p>\n<p><a href=\"http:\/\/www.pebblereports.com\/sqlpal\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" class=\"alignnone wp-image-4626 size-full lazyload\" title=\"SQLpal\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/SQLpal.png\" alt=\"SQLPal SQL Editor Tool\" width=\"344\" height=\"107\" data-srcset=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/SQLpal.png 344w, https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2010\/07\/SQLpal-300x93.png 300w\" data-sizes=\"(max-width: 344px) 100vw, 344px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 344px; --smush-placeholder-aspect-ratio: 344\/107;\" \/><\/a><\/p>\n<p>It is usually treated as an alternative to SQL*Plus for connection to Oracle via JDBC.<\/p>\n<p>With SQLpal, you won&#8217;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.<\/p>\n<p>The download file is only 9MB in size and is available for Windows only.<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212; End of list of free or O<strong>pen Source SQL editor tools<\/strong> &#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>There you go, a couple of free or open source SQL editor tools for all your Database SQL management purposes. Enjoy!<\/p>\n<h2>Is SQL hard to learn? And where can I practice SQL for free?<\/h2>\n<p>This 4 hours video by freecodecamp.org is all you need in order to learn SQL where it covers the following topics.<\/p>\n<p><em>Introduction to SQL, What is a Database?, Tables &amp; Keys, SQL Basics, MySQL Windows Installation, MySQL Mac, Installation, Creating Tables, Inserting Data, Constraints, Update &amp; 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.<\/em><\/p>\n<div class=\"lyte-wrapper\" title=\"SQL Tutorial - Full Database Course for Beginners\" style=\"width:640px;max-width:100%;margin:5px auto;\"><div class=\"lyMe\" id=\"WYL_HXV3zeQKqGY\" itemprop=\"video\" itemscope itemtype=\"https:\/\/schema.org\/VideoObject\"><div><meta itemprop=\"thumbnailUrl\" content=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FHXV3zeQKqGY%2Fhqdefault.jpg\" \/><meta itemprop=\"embedURL\" content=\"https:\/\/www.youtube.com\/embed\/HXV3zeQKqGY\" \/><meta itemprop=\"duration\" content=\"PT4H20M39S\" \/><meta itemprop=\"uploadDate\" content=\"2018-07-02T17:13:32Z\" \/><\/div><meta itemprop=\"accessibilityFeature\" content=\"captions\" \/><div id=\"lyte_HXV3zeQKqGY\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FHXV3zeQKqGY%2Fhqdefault.jpg\" class=\"pL\"><div class=\"tC\"><div class=\"tT\" itemprop=\"name\">SQL Tutorial - Full Database Course for Beginners<\/div><\/div><div class=\"play\"><\/div><div class=\"ctrl\"><div class=\"Lctrl\"><\/div><div class=\"Rctrl\"><\/div><\/div><\/div><noscript><a href=\"https:\/\/youtu.be\/HXV3zeQKqGY\" rel=\"nofollow\"><img decoding=\"async\" src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/plugins\/wp-youtube-lyte\/lyteCache.php?origThumbUrl=https%3A%2F%2Fi.ytimg.com%2Fvi%2FHXV3zeQKqGY%2F0.jpg\" alt=\"SQL Tutorial - Full Database Course for Beginners\" width=\"640\" height=\"340\" \/><br \/>Watch this video on YouTube<\/a><\/noscript><meta itemprop=\"description\" content=\"In this course, we&#039;ll be looking at database management basics and SQL using the MySQL RDBMS. The course is designed for beginners to SQL and database management systems, and will introduce common database management topics. Throughout the course we&#039;ll be looking at various topics including schema design, basic C.R.U.D operations, aggregation, nested queries, joins, keys and much more. You can get PopSQL to follow along here: http:\/\/popsql.com\/freecodecamp \ud83d\udd17Company Database Code: https:\/\/www.giraffeacademy.com\/databases\/sql\/creating-company-database\/ \u2764\ufe0f Try interactive Databases courses we love, right in your browser: https:\/\/scrimba.com\/freeCodeCamp-Databases (Made possible by a grant from our friends at Scrimba) \u2b50\ufe0f Contents \u2b50 \u2328\ufe0f (0:00) Introduction \u2328\ufe0f (2:36) What is a Database? \u2328\ufe0f (23:10) Tables &amp; Keys \u2328\ufe0f (43:31) SQL Basics \u2328\ufe0f (52:26) MySQL Windows Installation \u2328\ufe0f (1:01:59) MySQL Mac Installation \u2328\ufe0f (1:15:49) Creating Tables \u2328\ufe0f (1:31:05) Inserting Data \u2328\ufe0f (1:38:17) Constraints \u2328\ufe0f (1:48:11) Update &amp; Delete \u2328\ufe0f (1:56:11) Basic Queries \u2328\ufe0f (2:08:37) Company Database Intro \u2328\ufe0f (2:14:05) Creating Company Database \u2328\ufe0f (2:30:27 ) More Basic Queries \u2328\ufe0f (2:26:24) Functions \u2328\ufe0f (2:45:13) Wildcards \u2328\ufe0f (2:53:53) Union \u2328\ufe0f (3:01:36) Joins \u2328\ufe0f (3:11:49) Nested Queries \u2328\ufe0f (3:21:52) On Delete \u2328\ufe0f (3:30:05) Triggers \u2328\ufe0f (3:42:12) ER Diagrams Intro \u2328\ufe0f (3:55:53) Designing an ER Diagram \u2328\ufe0f (4:08:34) Converting ER Diagrams to Schemas Course developed by Mike Dane. Check out his YouTube channel for more great programming courses: https:\/\/www.youtube.com\/channel\/UCvmINlrza7JHB1zkIOuXEbw \ud83d\udd17The Giraffe Academy website: http:\/\/www.giraffeacademy.com\/ -- Learn to code for free and get a developer job: https:\/\/www.freecodecamp.org Read hundreds of articles on programming: https:\/\/medium.freecodecamp.org\"><\/div><\/div><div class=\"lL\" style=\"max-width:100%;width:640px;margin:5px auto;\"><\/div><\/p>\n<h2>Can I run SQL editor online?<\/h2>\n<p>Yes! Of course, you can!<\/p>\n<p>An online SQL IDE that allows you to execute SQL statements online.<\/p>\n<p>Great if you would like to test your SQL statements without having to launch your favorite SQL Editors.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Recently a new joiner at our company asked me this. Where are SQL commands executed? I said, as a programmer or database administrator, you&#8217;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 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4616,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"slim_seo":{"title":"SQL editor tools which are free or open source - Software for Enterprise","description":"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"},"footnotes":""},"categories":[11],"tags":[],"class_list":["post-4461","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases"],"_links":{"self":[{"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/posts\/4461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/comments?post=4461"}],"version-history":[{"count":0,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/posts\/4461\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/media\/4616"}],"wp:attachment":[{"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/media?parent=4461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/categories?post=4461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/tags?post=4461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}