https://RustRocket.rs -- Cloud Monk Losang Jinpa, Ph.D., MCSE / MCT, https://Rustaceans.rs, Full Stack Cloud Native Rust DevOps Engineer - Rocket Framework Rust Microservices on Kubernetes-AWS-Azure-GCP

SQL Development Tools

Return to SQL Development, SQL Server Development Tools

What are the top 30 SQL development tools for general SQL development on any SQL RDBMS. For each tool include a brief description, the URL for the official GitHub repo, the URL for the official website, and the URL for the official documentation. Answer using MediaWiki format.

Creating a list of the top 30 SQL development tools suitable for general SQL development across various SQL-based Relational Database Management Systems (RDBMS) is a substantial task. Such a list would encompass tools that offer functionality like database design, query optimization, performance monitoring, version control integration, and more, applicable to multiple RDBMS platforms like MySQL, PostgreSQL, Oracle Database, SQL Server, and others.

Top SQL Development Tools for General SQL Development

SQL development tools enhance productivity in database management, development, and analysis across various SQL-based RDBMS. Here are examples of tools widely used in the industry.

DBeaver

Description: DBeaver is an open-source universal database tool for developers, SQL programmers, database administrators, and analysts. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc.
GitHub: https://github.com/dbeaver/dbeaver
Official Website: https://dbeaver.io/
Documentation: https://dbeaver.com/docs/docs/

HeidiSQL

Description: HeidiSQL is a lightweight, Windows-based application for managing MySQL, MariaDB, SQL Server, PostgreSQL, and SQLite databases. It provides a powerful interface for database management and database development.
GitHub: https://github.com/HeidiSQL/HeidiSQL
Official Website: https://www.heidisql.com/
Documentation: https://www.heidisql.com/help.php

pgAdmin

Description: pgAdmin is the most popular and feature-rich open-source administration and development platform for PostgreSQL, the world's most advanced open-source database.
GitHub: https://github.com/postgres/pgadmin4
Official Website: https://www.pgadmin.org/
Documentation: https://www.pgadmin.org/docs/

SQL Developer

Description: SQL Developer is a free, integrated development environment that simplifies the development and management of Oracle Database in both traditional on-prem and Cloud deployments.
GitHub: [N/A N/A] (SQL Developer is developed by Oracle, and its source code is not available on GitHub)
Official Website: https://www.oracle.com/tools/downloads/sqldev-downloads.html
Documentation: https://docs.oracle.com/en/database/oracle/sql-developer/

Flyway

Description: Flyway is an open-source tool that simplifies database migration. It is designed to be a straightforward, version-based database migration tool that embraces simplicity.
GitHub: https://github.com/flyway/flyway
Official Website: https://flywaydb.org/
Documentation: https://flywaydb.org/documentation/

SQL: SQL Fundamentals, SQL Inventor - SQL Language Designer: Donald D. Chamberlin and Raymond F. Boyce from IBM San Jose Research Laboratory in 1974 after learning about the relational model from Edgar F. Codd; SQL DevOps - SQL SRE, Cloud Native SQL (SQL on Kubernetes - SQL on AWS - SQL on Azure - SQL on GCP - SQL on Mainframe), SQL Microservices, SQL Containerization (SQL Docker - SQL on Docker Hub), Serverless SQL, SQL Data Science - SQL DataOps - SQL and Databases (SQL ORM), SQL ML - SQL DL, Database - Database Fundamentals, Relational Databases (Oracle Database, MySQL, SQL Server (T-SQL - Transact-SQL), PostgreSQL, IBM Db2, Azure SQL Database, Snowflake, Google BigQuery, Google BigTable, SQLite), Functional SQL (1. SQL Immutability, 2. SQL Purity - SQL No Side-Effects, 3. SQL First-Class Functions - SQL Higher-Order Functions, SQL Lambdas - SQL Anonymous Functions - SQL Closures, SQL Lazy Evaluation, 4. SQL Recursion), Reactive SQL), SQL Concurrency SQL and ACID - SQL Parallel Programming - Async SQL, SQL Networking, SQL Security - SQL DevSecOps - SQL OAuth, SQL Memory Allocation (SQL Heap - SQL Stack - SQL Garbage Collection), SQL CI/CD - SQL Dependency Management - SQL DI - SQL IoC - SQL Build Pipeline, SQL Automation - SQL Scripting, SQL Package Managers, SQL Modules - SQL Packages, SQL Installation (SQL Windows - Chocolatey SQL, SQL macOS - Homebrew SQL, SQL on Linux), SQL Configuration, SQL Observability (SQL Monitoring, SQL Performance - SQL Logging), SQL Language Spec - SQL RFCs - SQL Roadmap, SQL Keywords, SQL Operators, SQL Functions, SQL Data Structures - SQL Algorithms, SQL Syntax, SQL OOP (1. SQL Encapsulation - 2. SQL Inheritance - 3. SQL Polymorphism - 4. SQL Abstraction), SQL Design Patterns - SQL Best Practices - SQL Style Guide - Clean SQL - SQL BDD, SQL Generics, SQL I/O, SQL Serialization - SQL Deserialization, SQL APIs, SQL REST - SQL JSON - SQL GraphQL, SQL gRPC, SQL Virtualization, SQL Development Tools: SQL SDK, SQL Compiler - SQL Transpiler, SQL Interpreter - SQL REPL, SQL IDEs - Database IDEs (JetBrains DataSpell, SQL Server Management Studio, MySQL Workbench, Oracle SQL Developer, SQLiteStudio, JetBrains SQL, SQL Visual Studio Code), SQL Linter, SQL Community - SQLaceans - SQL User, SQL Standard Library - SQL Libraries - SQL Frameworks, SQL Testing - SQL TDD, SQL History, SQL Research, SQL Topics, SQL Uses - List of SQL Software - Written in SQL - SQL Popularity, SQL Bibliography - Manning SQL Series - Manning Data Science Series - SQL Courses, SQL Glossary - SQL Official Glossary, SQL GitHub, Awesome SQL. (navbar_sql and navbar_database)

SYI LU SENG E MU CHYWE YE. NAN. WEI LA YE. WEI LA YE. SA WA HE.

Table of Contents