SQL IDEs are the butter and bread of a Business Intelligence Engineer and Data Engineer.
# Terminal based
- Dadbod (GitHub) - see Query databases in vim (vim-dadbod)
- Supports: Big Query, ClickHouse, Impala, jq, MongoDB, MySQL, Oracle, osquery, PostgreSQL, Presto, Redis, SQL Server, SQLite, DuckDBSee a short video of how I use it with DuckDB on asciinema):
- DBeaver: Highly versatile and supports numerous databases. Its open-source nature and extensive functionality make it a top choice for many professionals.HeidiSQL: A lightweight tool that’s great for quick and efficient work with MySQL, MariaDB, and Microsoft SQL Server databases.MySQL Workbench: Tailored for MySQL databases, it offers a complete set of tools for database design, development, and administration.SQL Server Management Studio (SSMS): A go-to for those working primarily with Microsoft SQL Server. It offers comprehensive tools for configuration, management, and SQL development.Oracle SQL Developer: Designed specifically for Oracle Database, it provides a comprehensive development and management toolset.PgAdmin: Widely used by PostgreSQL database developers, it’s an open-source tool that offers a rich set of features for database management.Aqua Data Studio: Offers database management, development, and visualization tools for a variety of databases.Toad: Known for its database management tools, it supports Oracle, SQL Server, MySQL, and other databases. Toad is particularly popular for its automation features and extensive functionality.Valentina Studio: A multi-platform tool that works with MySQL, PostgreSQL, MariaDB, and SQLite. It offers excellent schema editing and diagramming capabilities.DbForge Studio: A comprehensive IDE for SQL Server, MySQL, Oracle, and PostgreSQL. Offers a wide range of tools for database development, management, and administration, including data comparison and synchronization, database diagramming, and SQL code completion.Aqua Data Studio: An advanced IDE that provides database developers with tools for editing, querying, and managing various databases. It’s known for its sophisticated query tool and versatile database support, including visual analytics.SQLyog: A powerful MySQL manager and admin tool, SQLyog is known for its intuitive GUI and a rich set of features like schema synchronization, query builder, and data transfer tools.DataSpell: Developed by JetBrains, it’s a new IDE specifically designed for data science, offering a productive environment for Python and R with integrated Jupyter Notebook support.VSCode Extensions Visual Studio Code, a lightweight but powerful source code editor, offers SQL development extensions. These extensions add database connectivity, query execution, and result set viewing capabilities to VSCode.
# Payed
- TablePlus: A modern, native tool with a clean user interface that allows developers to simultaneously manage multiple databases such as MySQL, PostgreSQL, SQLite, and more. It’s known for its simplicity and robustness.DataGrip: Developed by JetBrains, it’s known for its intelligent query console, schema navigation, and version control integration. It’s a powerful tool, especially if you’re working with multiple databases and SQL dialects.Navicat: A series of database management products that support MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite. It offers an intuitive interface with powerful tools for data editing, SQL query and report building, and backup management.Aginity Pro: A specialized tool primarily focused on enhancing productivity for SQL data analysts and developers. It provides features for code reuse, query optimization, and team collaboration.Azure Data Studio: VSCode like SQL editor.
Origin: Harlequin
References: SQL IDE of choice? : r/dataengineering, SQL
Created 2023-12-22
