Some were simple and just involved entering a database, service name, username, and password. This excludes tools like SQL*Plus and SQLcl.īefore we get into my recommendations and more details about each IDE, there were a few things I noticed when testing and analysing these SQL editors.įirst, the connection process was different for many of them. It also excludes data modelling tools and data visualisation tools. While Notepad++ is a great tool and has SQL syntax highlighting, it doesn’t let you run SQL queries. This excludes text editors such as Notepad++. Must be able to write and run SQL queries.This guide has been created and was last updated in 2020. Some sites had a comparison of IDEs but they were out of date. I’ve seen many questions on websites such as Quora and Stack Overflow about “which IDE is the best” and “which SQL Editor should I use”, and while there were some good answers, there wasn’t really a single place to compare all of the options. It’s a list of all SQL editors available for major databases: Oracle, SQL Server, MySQL, PostgreSQL, SQLite, and MariaDB.

This guide is a comparison of all SQL IDEs currently available. Operating System:Windows 7, 8/8.Are you looking for an SQL IDE (Integrated Development Environment) or SQL editor? Take a look at this list of all of the IDEs currently available. Script autorun support and full command-line options Image viewer cell detail window with support for Jpg, Gif, Png, Bmp, Tif, MultiPage Tif, etc.Įxport data directly to Excel, Calc, CSV, XML, insert statement scripts, and more.Įxport directly to Excel files even if Excel is not installed. Incredibly fast data grid with support for transposed mode, sorting, custom formatting, filtering and more.Ĭell detail window for multi-line or formatted Text. Support for viewing tables, columns, stored procedures, schemas, etc. Language copy & paste feature for integration with programming tools. SQL query and script running including database specific commands, stored procedures, etc.īind variable (:bindvar) and prompt variable (&AskMe) support. Native driver support for Oracle, MySQL, PostgreSQL, Firebird and SQLServer. GoldSqall has an advanced syntax highlighting SQL Editor and formatter, a lightning fast datagrid with sorting, filtering, data formatting and a transposed view mode. GoldSqall also allows connecting to any database with OLEDB or ODBC drivers. GoldSqall can natively connect to Oracle, PostgreSQL, MySQL, Firebird and SQL Server. GoldSqall is an SQL query, editing and exporting tool.

Benthic software golden