Awesome SQL

         

A curated list of SQL databases, tools, clients, query builders, learning resources, extensions, and ecosystem utilities for working with structured data and relational databases.

Contents

• Databases
• GUI Clients
• CLI Tools
• Extensions
• Drivers
• ORMs & Query Builders
• SQL Linters & Formatters
• Learning Resources
• Related Awesome Lists

Databases

• PostgreSQL – Powerful open-source relational database.
  https://www.postgresql.org/

• MySQL – Widely used relational database.
  https://www.mysql.com/

• MariaDB – Community-driven fork of MySQL.
  https://mariadb.org/

• SQLite – Lightweight, file-based SQL database.
  https://sqlite.org/

• SQL Server – Microsoft’s relational database engine.
  https://www.microsoft.com/sql-server/

• CockroachDB – Distributed SQL database with PostgreSQL compatibility.
  https://github.com/cockroachdb/cockroach

• TiDB – Distributed SQL database compatible with MySQL.
  https://github.com/pingcap/tidb

• DuckDB – In-process OLAP SQL database optimized for analytics.
  https://github.com/duckdb/duckdb

GUI Clients

• DBeaver – Universal database tool supporting all major SQL systems.
• TablePlus – Fast, modern database GUI (commercial).
• Beekeeper Studio – Open-source cross-platform SQL editor.
• DataGrip – JetBrains SQL IDE.
• DB Browser for SQLite – SQLite visual interface.

CLI Tools

• psql – PostgreSQL command-line client.
• mysql CLI – MySQL client.
• duckdb CLI – DuckDB SQL shell.
• LiteCLI – Enhanced SQLite CLI.
• pgcli – Autocompletion and syntax highlighting for PostgreSQL.
• mycli – MySQL client with autocomplete.

Extensions

• PostGIS – GIS and geospatial SQL processing for PostgreSQL.
• pgvector – Vector search extension for PostgreSQL.
• TimescaleDB – Time-series database built on PostgreSQL.
• SQLCipher – Encrypted SQLite.
• DuckDB Extensions – Analytics functions, Parquet, Iceberg, etc.

Drivers

JavaScript / TypeScript

• pg – PostgreSQL driver.
• mysql2 – MySQL client.
• better-sqlite3 – SQLite client.

Python

• psycopg – PostgreSQL driver.
• mysqlclient – MySQL driver.
• sqlite3 – Built-in SQLite driver.

Go

• lib/pq – PostgreSQL driver.
• go-sql-driver/mysql – MySQL driver.
• mattn/go-sqlite3 – SQLite driver.

Rust

• sqlx – Async SQL framework.
• postgres – PostgreSQL driver.

ORMs & Query Builders

JavaScript / TypeScript

• Prisma – Type-safe ORM with SQL migrations.
• Drizzle ORM – SQL-first TypeScript ORM.
• Sequelize – Mature ORM for SQL databases.
• Kysely – Type-safe SQL query builder.

Python

• SQLModel – FastAPI-focused ORM.
• SQLAlchemy – Leading Python ORM.
• Peewee – Lightweight ORM.

Go

• GORM – Go ORM built on top of database/sql.
• sqlc – Generate type-safe Go code from SQL.

Rust

• Diesel – Type-safe ORM.
• SeaORM – Async ORM with migrations.

SQL Linters & Formatters

• SQLFluff – Popular SQL linter and formatter.
• pgFormatter – PostgreSQL SQL formatter.
• sqlfmt – SQL formatter for modern codebases.
• Prettier Plugin SQL – Prettier support for SQL.

Learning Resources

• PostgreSQL Tutorial – Beginner–advanced PostgreSQL learning.
• SQLBolt – Interactive SQL lessons.
• Mode SQL Tutorials – Practical SQL training.
• W3Schools SQL – Intro to SQL.
• LeetCode Database Problems – SQL problem-solving practice.
• SQL Style Guide – Best practices and conventions.

Related Awesome Lists

• Awesome Databases
• Awesome SQLite
• Awesome PostgreSQL
• Awesome MySQL
• Awesome DB Tools

Contribute

Contributions are welcome. Please ensure your submission fully follows the requirements outlined in CONTRIBUTING.md, including formatting, scope alignment, and category placement.

Pull requests that do not adhere to the contribution guidelines may be closed.

License