SQL Tools and Techniques

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.
  • 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

  • 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
  • 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

Resources

Reference: https://github.com/danhuss/awesome-sql