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 Developer - Oracle's Free IDE for PL/SQL development and administration of Oracle databases
- SQL Tools for Oracle - Lightweight frontend for Oracle DB development.
- Oracle Database 11g Express Edition - Free entry level database to develop and deploy applications
- Alexandria PL/SQL Utility Library - Collection of utility packages for PL/SQL
- PLSQL-JSON - PL/SQL library to encode/decode JSON
- utPLSQL - Unit testing framework for PL/SQL
SQL Server
- [SQL Server Express Edition] (http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx) - 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
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