/awesome-sql

List of tools and techniques for working with relational databases.

awesome-sql

List of tools and techniques for working with relational databases inspired by other awesome lists.

  • Oracle - Software and packages specifically for Oracle and PL/SQL.
  • SQL Server - Software and packages specifically for SQL Server and T-SQL.
  • MySQL - There is already a whole awesome list just for MySQL.
  • PostgreSQL - There is alread a whole awesome list just for PostgreSQL.
  • Cross Platform Stuff
    • Formatters - Tools and sites that will format your ugly SQL code.
    • Tools - Other cool tools and sites.

Oracle

SQL Server

  • SQL Server Express Edition - Free SQL Server Database to develop and deploy applications
  • SQL Server Data Tools - Integrated environment for developers to design and build database and other business intelligence solutions for MS SQL Server stack.
  • tSQLt - Unit testing framework for SQL Server
  • MSSqlCLI - A command-line client for SQL Server with auto-completion and syntax highlighting

Formatters

Tools

  • sqruff - A SQL linter and formatter written in Rust that supports various SQL dialects and integrates with VSCode through a plugin.
  • sqlaxe - CLI tool for searching, filtering, formatting, and splitting SQL files. Supports 40+ dialects of SQL.
  • SQLPage - Open-source SQL-only website builder
  • PixQL - Command-line image processing tool in SQL by @Phildo
  • SQL Fiddle - Easly test and share database problems and their solutions. Can use different backend DBMS's (MySQL, PostgreSQL, MS SQL Server, Oracle, and SQLite)
  • SqlPad - A web app for running SQL queries and visualizing the results
  • ERAlchemy - ERAlchemy generates Entity Relation (ER) diagram from databases
  • BigBash - Open-source converter that generates a bash one-liner from an SQL Select query, no database necessary
  • Flyway - Database migration tool
  • Liquibase - Source Control for your database
  • Rumba RDBM - Database migration tool, plain-SQL, and declarative definition supported
  • PgCLI - Postgres CLI with autocompletion and syntax highlighting
  • LINQPad - LINQPad is not just for LINQ queries, but any C#/F#/VB expression, statement block or program.
  • SchemaSpy - we will do the best to simplify documentation process of your database
  • MissionKontrol - Self-hosted admin panel to manage one or more MySQL/PostGRES databases.
  • DBeaver - Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases.
  • EverSQL - SQL query optimization and database observability, powered by AI.
  • WhoDB - SQL/NoSQL/Graph/Cache/Object data explorer with AI-powered chat + other useful features

Resources