opensource-sql-tools.md

JS/TS/FLOW

• Validate SQL queries in JavaScript and TypeScript code against your schema at build time https://github.com/andywer/postguard

• A MySQL query analyzer https://github.com/stevenmiller888/ts-mysql-analyzer

• A typescript language service plugin that gives superpowers to SQL tagged template literals. https://github.com/segmentio/ts-mysql-plugin

• Convert mysql schemas into TypeScript interfaces https://github.com/stevenmiller888/mysql-schema-ts

• An autocomplete engine for MySQL queries. https://github.com/stevenmiller888/ts-mysql-autocomplete

• Parse simple SQL statements into an abstract syntax tree (AST) with the visited tableList and convert it back to SQL https://github.com/taozhi8833998/node-sql-parser

• Generate Typescript types from Postgres https://github.com/kristiandupont/kanel

• A postgres -> typescript interface generator https://github.com/vramework/schemats

• Yet another simple Postgres SQL parser https://github.com/oguimbal/pgsql-ast-parser

• Parse SQL (select) statements into abstract syntax tree (AST) and convert ASTs back to SQL. https://github.com/godmodelabs/flora-sql-parser

• A SQL database implemented purely in TypeScript type annotations. https://github.com/codemix/ts-sql

• pgTyped - Typesafe SQL in TypeScript https://github.com/adelsz/pgtyped/

• AlaSQL.js - JavaScript SQL database for browser and Node.js. Handles both traditional relational tables and nested JSON data (NoSQL). Export, store, and import data from localStorage, IndexedDB, or Excel. https://github.com/agershun/alasql

• An in memory postgres DB instance for your unit tests https://github.com/oguimbal/pg-mem

• Statically validate correctness of all your SQL queries. TypeScript, PostgreSQL https://github.com/MedFlyt/mfsqlchecker

• SQL(select) parser written with jison. parse SQL into abstract syntax tree(AST) and stringify back to SQL https://github.com/JavaScriptor/js-sql-parser

• JavaScript implentation of SQLite 3 query parser https://github.com/codeschool/sqlite-parser

• A SQL parser written in pure JS https://github.com/forward/sql-parser

• Evidence enables analysts to deliver a polished business intelligence system using SQL and markdown https://github.com/evidence-dev/evidence

• (archived) JavaScript implentation of SQLite 3 query parser https://github.com/codeschool/sqlite-parser

• An in memory postgres DB instance for your unit tests https://github.com/oguimbal/pg-mem

GO

• Go fearless SQL. Sqlvet performs static analysis on raw SQL queries in your Go code base. https://github.com/houqp/sqlvet

• Model generator for go-pg package https://github.com/dizzyfool/genna

• Regression Testing your SQL queries https://github.com/dimitri/regresql

• An early PostgreSQL implementation in Go https://github.com/eatonphil/gosql https://notes.eatonphil.com/database-basics-expressions-and-where.html https://twitter.com/phil_eaton

• (archived) An extensible MySQL server implementation in Go https://github.com/src-d/go-mysql-server

• A MySQL-compatible relational database with a storage agnostic query engine. Implemented in pure Go. https://github.com/dolthub/go-mysql-server

• Static analysis tool for Golang that protects against SQL injections https://github.com/stripe/safesql

• OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL. https://github.com/cube2222/octosql

• A MySQL Compatible SQL Parser https://github.com/pingcap/parser

• SQL Parser implemented in Go (The backbone of this repo is extracted from vitessio/vitess) https://github.com/xwb1989/sqlparser

• A golang expression evaluator & Library to build SQL query engine based functionality https://github.com/araddon/qlbridge

• SQL Optimizer And Rewriter https://github.com/XiaoMi/soar

• Type safe SQL builder with code generation and automatic query result data mapping (JOOQ for go) https://github.com/go-jet/jet

• simply SQL Parser for Go ( powered by vitess and TiDB ) https://github.com/blastrain/vitess-sqlparser

• Simplicity-focused, template based SQL query builder https://github.com/sanggonlee/gosq

• Generate type safe Go from SQL https://github.com/kyleconroy/sqlc

• Idempotent schema management for MySQL, PostgreSQL, and more https://github.com/k0kubun/sqldef

PYTHON

• Inferring sql queries from plain-text questions about tables https://github.com/paulfitz/mlsql https://news.ycombinator.com/item?id=20101381

• Look for SQL injection attacks in python source code https://github.com/uber/py-find-injection

• A non-validating SQL parser module for Python https://github.com/andialbrecht/sqlparse

• A small python based sql parser focusing on finding table dependencies within database views. Currently only working with Snowflake ANSI Sql https://github.com/dondaum/parsesql

• A SQL linter and auto-formatter for Humans https://github.com/sqlfluff/sqlfluff

• Let's make a SQL parser so we can provide a familiar interface to non-sql datastores! https://github.com/mozilla/moz-sql-parser

• Compares the PostgreSQL schema between two databases and generates SQL statements that can be run manually against the second database to make their schemas match. https://github.com/joncrlsn/pgdiff

• Like diff but for PostgreSQL schemas https://github.com/djrobstep/migra

• Making it easy to query APIs via SQL https://github.com/betodealmeida/shillelagh/

• Python SQL Parser and Transpiler https://github.com/tobymao/sqlglot

• SQL Lineage Analysis Tool powered by Python https://github.com/reata/sqllineage

RUST

• The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. https://github.com/launchbadge/sqlx/

• Extensible SQL Lexer and Parser for Rust https://github.com/ballista-compute/sqlparser-rs

• Postgres' query parser, as a Rust crate! https://github.com/zombodb/postgres-parser

• Build Postgres Extensions with Rust! https://github.com/zombodb/pgx

• linter for PostgreSQL, focused on migrations https://github.com/sbdchd/squawk

• PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement https://github.com/prql/prql

C

• C library for accessing the PostgreSQL parser outside of the server environment https://github.com/lfittl/libpg_query

• pgquarrel compares PostgreSQL database schemas (DDL) https://github.com/eulerto/pgquarrel

C++

• Automatically identify anti-patterns in SQL queries https://github.com/jarulraj/sqlcheck https://github.com/moeryomenko/sqlcheck

• SQL Parser for C++. Building C++ object structure from SQL statements. https://github.com/hyrise/sql-parser

C#

• Configurable linting for TSQL https://github.com/tsqllint/tsqllint

• TSQL Static Code Analysis Rules for SQL Server https://github.com/ashleyglee/TSqlRules

• TSQL parser with Microsoft SQL Server Transact-SQL ScriptDom https://github.com/GCer-Hidenori/TSQLScriptDomParser

• Library Written in C# For Parsing SQL Server T-SQL Scripts in .Net
  https://github.com/bruce-dunwiddie/tsql-parser

• An engine for searching patterns in the source code, based on Unified AST or UST. At present time C#, Java, PHP, PL/SQL, T-SQL, MySql, and JavaScript are supported. Patterns can be described within the code or using a DSL. https://github.com/PositiveTechnologies/PT.PM

JAVA

• JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern https://github.com/JSQLParser/JSqlParser

• jOOQ is the best way to write SQL in Java https://github.com/jOOQ/jOOQ

• Coral is a translation, analysis, and query rewrite engine for SQL and other relational languages. https://github.com/linkedin/coral

• The official home of the Presto distributed SQL query engine for big data https://github.com/prestodb/presto

PHP

• A pure PHP SQL (non validating) parser w/ focus on MySQL dialect of SQL https://github.com/greenlion/PHP-SQL-Parser

• A validating SQL lexer and parser with a focus on MySQL dialect. https://github.com/phpmyadmin/sql-parser

CLOJURE

• Turn Clojure data structures into SQL https://github.com/seancorfield/honeysql

ERLANG

• LALR grammar based SQL Parser https://github.com/KonnexionsGmbH/sqlparse

HASKELL

• Parsing and analysis of Vertica, Hive, and Presto SQL. https://github.com/uber/queryparser

F#

• Statically typechecks a common SQL dialect and translates it to various RDBMS backends https://github.com/rspeele/Rezoom.SQL

COQ, LEAN, ...

• Cosette is an automated SQL solver https://github.com/uwdb/cosette

RUBY

• Simple SQL linter supporting ANSI and PostgreSQL syntaxes https://github.com/purcell/sqlint

V

• SQL database written in pure V https://github.com/elliotchance/vsql

MISC

• Parsing, formatting, modification and analysis http://sqlparser.com/

Articles

• Improving on the Command-Line SQL Experience https://medium.com/swlh/improving-on-the-command-line-sql-experience-48c2b544c71b