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.
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
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
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
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
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.
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.
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
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
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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
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
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
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.
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