Index

Databases

Learning to write queries is easy; getting the schema right is hard — later performance problems usually trace back to modelling decisions made on day one. Spend separate time on indexing: the cause of slowness is almost never the query itself.

34 links

1

A list of tools that make working with databases easier (clients, migration, schema). Unlike single-database lists it looks at engine-agnostic helper tools.

Awesome List · Database · Freechecked 2026-11-09archive
2
Awesome MongoDBgithub.com

A list of libraries and tools for MongoDB, the document-based NoSQL database. Unlike general NoSQL lists it focuses on one product’s driver and ODM ecosystem.

Awesome List · Database · Freechecked 2026-11-09archive
3

A list of extensions, tools and resources for PostgreSQL. Unlike the official docs it shows the ecosystem’s extensions and management tools together.

Awesome List · Database · Freechecked 2026-11-09archive
4
Beekeeper Studiobeekeeperstudio.io

An open-source SQL editor and manager supporting many databases. Compared with DBeaver its interface is simpler and more modern, with fewer advanced features in exchange.

Database · Open Source · Free · Desktopchecked 2026-11-09archive
5
CockroachDBcockroachlabs.com

A distributed SQL database that scales horizontally with strong consistency and survivability, speaking the PostgreSQL protocol. Unlike single-node PostgreSQL it replicates across regions; since 2024 it has no open-source core and is offered free to individuals, students and businesses under $10M annual revenue under an enterprise licence.

Database · Server · Freemiumchecked 2026-11-09archive
6
ConnectionStrings.comconnectionstrings.com

A reference giving the correct connection-string format for every database and driver. Unlike hunting the docs it gathers the syntax of dozens of drivers in one place.

Reference · Database · Freechecked 2026-11-09archive
7
Couchbase Learnlearn.couchbase.com

Queries a document store with a SQL-like language (N1QL), which is a gentler break for teams arriving from the relational world than MongoDB’s query syntax.

Free · Database · Curriculumchecked 2026-11-09archive
8
dbdiagram.iodbdiagram.io

A tool that turns a simple text DSL (DBML) into shareable ER diagrams fast. Unlike drag-and-drop diagram tools you type the schema — no aligning boxes by hand — and can export it to SQL.

Database · In Browser · Freechecked 2026-11-09archive
9
DBeaverdbeaver.io

A universal desktop database client managing many databases from one interface. Compared with Beekeeper Studio it is far more comprehensive — ER diagrams, data transfer, hundreds of drivers — but Java-based and heavy.

Database · Open Source · Desktop · Freechecked 2026-11-09archive
10
Firebasefirebase.google.com

Realtime database, auth, storage and hosting in one package. Unlike Supabase it is NoSQL: it accelerates a prototype sharply, while query flexibility and vendor lock-in become the later problem.

Backend · API · Freemiumchecked 2026-11-09archive
11

A full course on normal forms and schema design. It teaches getting the tables right rather than writing queries — which is where every later problem originates.

Video · Free · Databasechecked 2026-11-09archive
12
MariaDBmariadb.org

A community-driven open-source fork of MySQL, usable as a drop-in replacement.

Database · Open Source · Server · Freechecked 2026-11-09archive
13
Modern SQLmodern-sql.com

Markus Winand’s site teaching modern SQL features such as window functions across dialects. Unlike general SQL tutorials, it tabulates which databases support each feature and since which version.

Database · Tutorial · Reference · Freechecked 2026-11-09archive
14
MongoDBmongodb.com

Document-oriented NoSQL database that stores data in flexible JSON-like (BSON) documents rather than rigid relational tables; built for horizontal scaling and rapid schema iteration.

Freemium · Open Source · Database · Backend · Docschecked 2026-11-09archive
15
MongoDB Universitylearn.mongodb.com

MongoDB’s official free courses. Unlike third-party courses it puts weight on data modelling — designing a document store with relational habits is the most common source of performance trouble.

Free · Database · Curriculumchecked 2026-11-09archive
16
MySQL Tutorialmysqltutorial.org

Works MySQL end to end over a sample database, treating join types, subqueries and stored procedures separately. Far more readable as an introduction than the official manual.

Free · Database · Tutorialchecked 2026-11-09archive
17
Neonneon.tech

Serverless Postgres with branching and scale-to-zero; it joined Databricks in 2025. Unlike traditional managed Postgres you can branch the database like git — an instant copy for every PR.

Database · Freemium · Serverchecked 2026-11-09archive
18

A free desktop client for Oracle databases combining querying, schema browsing and PL/SQL debugging. Unlike general clients such as DBeaver it has a PL/SQL debugger and Oracle-specific tooling — the usual tool if you work with Oracle.

Free · Database · Desktopchecked 2026-11-09archive
19
PlanetScaleplanetscale.com

Serverless MySQL built on Vitess, managing schema changes through branches with no downtime. Unlike classic managed MySQL it offers that branching and non-blocking migrations; its free tier was removed in 2024.

Database · Freemium · Serverchecked 2026-11-09archive
20
PocketBasepocketbase.io

A backend shipping as one Go file, providing SQLite, auth and a real-time API. Unlike heavy stacks it reduces the server to a single executable.

Database · Backend · Open Source · Go · FreeRepo Archivedchecked 2026-11-09archive
21
PostgreSQL Exercisespgexercises.com

Practise SQL with graded PostgreSQL exercises in the browser. Compared with SQLBolt it is PostgreSQL-specific and more advanced, including recursive queries and window functions.

Database · Interactive · Tutorial · Free · In Browserchecked 2026-11-09archive
22

A PostgreSQL tutorial showing each topic with a runnable query. Unlike most SQL courses, it goes deep on window functions and CTEs.

Free · Database · Tutorialchecked 2026-11-09archive
23
PostgreSQLCO.NFpostgresqlco.nf

Searchable documentation for every postgresql.conf parameter, with version differences, defaults and community recommendations. Unlike the official manual it adds per-parameter tuning advice and context.

Reference · Database · Docs · Freechecked 2026-11-09archive
24

Redis’s official GUI — browse, edit, query and profile your data. Instead of third-party tools such as RESP.app (RedisDesktopManager), this is now the official option.

Database · Free · Desktopchecked 2026-11-09archive
25
Select Star SQLselectstarsql.com

An interactive online book that teaches SQL through exercises run in the browser against one real dataset. Unlike syntax references it builds query reasoning step by step around a single dataset's story.

Database · Tutorial · Interactive · Freechecked 2026-11-09archive
26

SQL from basics to advanced in four hours for anyone who wants the whole picture in one sitting. It reaches window functions rather than stopping at basic SELECT.

Video · Free · Databasechecked 2026-11-09archive
27
SQLBoltsqlbolt.com

Interactive SQL lessons that teach by doing in the browser; each lesson ends with an exercise where you write the query. Unlike video courses you write queries instead of watching; it sits at a more basic level than PostgreSQL tutorials.

Database · Interactive · Tutorial · Free · In Browserchecked 2026-11-09archive
28
SQLitesqlite.org

A serverless embedded database living in a single file — the most widely deployed database engine in the world. Unlike server databases such as PostgreSQL it needs no separate process or setup; its test coverage is legendary.

Open Source · Database · Free · Docschecked 2026-11-09archive
29
SQLZoosqlzoo.net

An exercise set that teaches SQL by making you write queries in the browser, each section over its own dataset. That is the difference from tutorials needing an install: your first SELECT requires no database.

Database · Interactive · Free · Tutorial · In Browserchecked 2026-11-09archive
30
Supabasesupabase.com

An open-source Firebase alternative adding auth, APIs and storage on top of Postgres. Unlike Firebase it stands on relational Postgres and can be self-hosted.

Database · Backend · Open Source · Freemiumchecked 2026-11-09archive
31
SurrealDBsurrealdb.com

A multi-model database combining document, graph and relational in one engine. Instead of running a document store, a graph database and a SQL database separately, you use them all through one query language — at the cost of less maturity than established databases.

Database · Open Source · Server · Freechecked 2026-11-09archive
32
Tursoturso.tech

A database platform built on libSQL, a SQLite fork, that replicates the database to edge nodes near the user. Unlike centralised services such as PlanetScale, read latency becomes local file access rather than a network round trip.

Database · Open Source · Free · Serverchecked 2026-11-09archive
33
Use The Index, Luke!use-the-index-luke.com

Markus Winand’s developer-focused guide to SQL indexing and performance. Unlike general SQL books, it focuses solely on indexing and compares every topic across five major databases.

Database · Tutorial · Reference · Freechecked 2026-11-09archive
34

A course on internals — index structures, transaction isolation levels, locking. Not a product tutorial; it holds regardless of which database you use.

Video · Free · System Designchecked 2026-11-09archive