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!

License