Skip to content

List of tools and techniques for working with relational databases.

Notifications You must be signed in to change notification settings

danhuss/awesome-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

52 Commits
 
 

Repository files navigation

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

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

Resources

About

List of tools and techniques for working with relational databases.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published