Need help with awesome-sql?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

danhuss
160 Stars 25 Forks 34 Commits 3 Opened issues

Description

List of tools and techniques for working with relational databases.

Services available

!
?

Need anything else?

Contributors list

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

  • SQL Format - Instant SQL Formatter
  • Poor SQL - Instant Free and Open-Source T-SQL Formatting (look here for the plugins and whatnot: https://github.com/TaoK/PoorMansTSqlFormatter )
  • T-SQL Tidy - Online T-SQL formatting with Webservice and Plugins for SSMS.

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

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.