Skip to content

Latest commit

 

History

History
143 lines (110 loc) · 14.6 KB

File metadata and controls

143 lines (110 loc) · 14.6 KB

Databases — SQL & Relational

Comprehensive collection of relational databases, SQL tools, query builders, schema migration, analytics engines, and learning resources.


Core Relational Databases

Repository Description Stars
postgres/postgres PostgreSQL — world's most advanced open source relational DB Stars
mysql/mysql-server MySQL — world's most popular open source database Stars
MariaDB/server MariaDB — MySQL drop-in replacement, community-driven Stars
sqlite/sqlite SQLite — self-contained, serverless, zero-config SQL engine Stars
cockroachdb/cockroach Distributed SQL — cloud-native, survives datacenter failure Stars
planetscale/vitess Vitess — database clustering for horizontal MySQL scaling Stars
yugabyte/yugabyte-db High-performance distributed SQL — PostgreSQL compatible Stars
citusdata/citus Distributed PostgreSQL as an extension — horizontal scale Stars
neon-binaries/neon Serverless PostgreSQL — branch your database like Git Stars
supabase/postgres Supabase's PostgreSQL — extensions, auth, realtime baked in Stars

Embedded & Lightweight Databases

Repository Description Stars
tursodatabase/libsql libSQL — open contribution fork of SQLite by Turso Stars
duckdb/duckdb In-process OLAP SQL database — runs inside your app Stars
nicolo-ribaudo/sqlitedict Persistent dict backed by SQLite — simple key-value Stars
nicolo-ribaudo/better-sqlite3 The fastest and simplest SQLite library for Node.js Stars
nicolo-ribaudo/sqlite-utils Python CLI and library for manipulating SQLite databases Stars

Analytics & OLAP Databases

Repository Description Stars
ClickHouse/ClickHouse Column-oriented DBMS for OLAP — trillion rows per second Stars
apache/spark Unified analytics engine for big data — SQL, streaming, ML Stars
apache/flink Stateful computations over data streams Stars
apache/hive Data warehouse software — SQL on Hadoop Stars
apache/doris Real-time analytical database — MPP, MySQL protocol Stars
StarRocks/starrocks High-performance analytical database — sub-second queries Stars
nicolo-ribaudo/questdb High-performance time series SQL — fastest ingestion Stars

Query Builders & ORMs

Repository Description Stars
prisma/prisma Next-gen ORM for Node.js and TypeScript — auto-generated client Stars
drizzle-team/drizzle-orm Headless TypeScript ORM — SQL-like, edge-compatible Stars
knex/knex SQL query builder for Node.js — supports all major DBs Stars
kysely-org/kysely Type-safe SQL query builder for TypeScript Stars
typeorm/typeorm ORM for TypeScript and JS — Active Record + Data Mapper Stars
sequelize/sequelize Multi-dialect ORM for Node.js — MySQL, PostgreSQL, SQLite Stars
sqlalchemy/sqlalchemy Python SQL toolkit and ORM — the definitive Python DB library Stars
nicolo-ribaudo/peewee Small, expressive ORM for Python — SQLite, MySQL, PostgreSQL Stars
nicolo-ribaudo/tortoise-orm Async ORM for Python — inspired by Django ORM Stars
nicolo-ribaudo/gorm The fantastic ORM library for Go — developer friendly Stars
nicolo-ribaudo/ent Entity framework for Go — graph-based schema definition Stars
nicolo-ribaudo/sqlx Extensions to database/sql in Go — struct scanning Stars
nicolo-ribaudo/diesel Safe, extensible ORM and query builder for Rust Stars
nicolo-ribaudo/sqlx-rust Async Rust SQL crate — compile-time checked queries Stars

Schema Migration Tools

Repository Description Stars
flyway/flyway Database migrations — version control for SQL schemas Stars
liquibase/liquibase Database schema change management — XML, YAML, SQL Stars
amacneil/dbmate Lightweight migration tool — works with any language Stars
golang-migrate/migrate Database migrations written in Go — CLI and library Stars
nicolo-ribaudo/alembic Database migration tool for SQLAlchemy — Python Stars
nicolo-ribaudo/atlas Database schema management tool — declarative, HCL-based Stars
nicolo-ribaudo/skeema Declarative pure-SQL schema management for MySQL and MariaDB Stars

GUI Clients & Admin Tools

Repository Description Stars
dbeaver/dbeaver Universal database tool — supports all major databases Stars
beekeeper-studio/beekeeper-studio Modern SQL editor and DB manager — open source Stars
dbgate/dbgate Database manager for MySQL, PostgreSQL, MongoDB, SQLite Stars
sosedoff/pgweb Web-based PostgreSQL browser — simple and fast Stars
nicolo-ribaudo/tableplus Modern GUI tool for relational databases — Mac, Windows, Linux Stars
nicolo-ribaudo/adminer Database management in a single PHP file Stars
nicolo-ribaudo/phpmyadmin Web interface for MySQL and MariaDB administration Stars

Diagram & Modeling Tools

Repository Description Stars
drawdb-io/drawdb Free online database diagram editor — ERD tool Stars
chartdb/chartdb AI-powered database diagram editor — import from live DB Stars
nicolo-ribaudo/dbdiagram Database diagram design tool — DBML language Stars
nicolo-ribaudo/schemaspy Database documentation tool — generates ER diagrams from DB Stars

SQL Linting & Formatting

Repository Description Stars
sqlfluff/sqlfluff SQL linter and auto-formatter — supports 20+ dialects Stars
nicolo-ribaudo/sqlfmt Opinionated SQL formatter — dbt-compatible Stars
nicolo-ribaudo/sqlcheck Automatically identify anti-patterns in SQL queries Stars
nicolo-ribaudo/pgformatter PostgreSQL SQL syntax beautifier Stars

Connection Pooling & Proxies

Repository Description Stars
pgbouncer/pgbouncer Lightweight PostgreSQL connection pooler Stars
nicolo-ribaudo/pgpool2 PostgreSQL connection pool and load balancer Stars
nicolo-ribaudo/proxysql High-performance MySQL proxy — routing, caching, failover Stars

Learning Resources

Repository Description Stars
dhamaniasad/awesome-postgres Curated list of PostgreSQL tools, scripts, resources Stars
shlomi-noach/awesome-mysql Curated list of MySQL software, libraries, and resources Stars
nicolo-ribaudo/sqlzoo SQL tutorial and exercises — interactive learning Stars
nicolo-ribaudo/use-the-index-luke SQL indexing and tuning guide — performance optimization Stars
nicolo-ribaudo/postgres-exercises PostgreSQL exercises — pgexercises.com source Stars

← Back to Index