Git Product home page Git Product logo

awesome-sql's Introduction

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

awesome-sql's People

Contributors

alexis-benoist avatar aloisdg avatar cyrilbois avatar danhuss avatar djberube avatar duncan-m avatar etai4542 avatar f440 avatar kirillzi avatar lovasoa avatar prabaprakash avatar sachinbhatttech avatar succhisingh avatar wodencafe avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

awesome-sql's Issues

What's about

Brent Ozar first-aid
https://www.brentozar.com/responder/
https://www.brentozar.com/first-aid/

More Ola Hallengren:
https://ola.hallengren.com/

The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, and SQL Server 2016

and sqlserver-kit by K.Taranov

http://sqlserver-kit.org/en
https://github.com/ktaranov/sqlserver-kit

More gurus about SQL Server
http://sqlserver-kit.org/en/home/people?perPage=100

Maybe with many gurus, tools, resources can be I get Information overload (also known as infobesity or infoxication),
https://theeconomiccontrarian.wordpress.com/2015/01/02/infoxication/

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.