Stack Gems
Menu

Tag

Sql tools

5 reviewed tools: 4 free or open source, 1 paid or paid-led.

Order: free and open source first, then hosted products with a real free tier, then paid-led; catalog order inside each group, with quiet or archived repos last. Not a score, and no tool pays for its place.

5 tools

  • Drizzle ORMTypeScript ORM that feels like SQL

    Free / OSS · Apache-2.0 · 36.1k GitHub stars

    VerdictSQL-first type safety for the abstraction-allergic.

    CatchLess magic means more typing. Relation handling requires more manual work than Prisma. The ecosystem is smaller.

  • SQLModelSQL + Pydantic in one elegant package

    Free / OSS · OSS/MIT · 18.4k GitHub stars

    VerdictOne model for database and API—elegant when it fits.

    CatchRelatively young library, so edge cases exist. Complex SQLAlchemy patterns may need direct SQLAlchemy access.

  • dbmateMIT framework-agnostic SQL migration CLI; single Go binary

    Free / OSS · OSS/MIT · 7.5k GitHub stars

    VerdictMIT SQL migration CLI. Tiny free forever; not a schema platform.

    CatchVs Atlas/Flyway/Bytebase: ordered SQL files only — no declarative planner, no review UI. You own ordering and rollbacks. Distinct from goose-style twins by DX focus plus dump.

  • DuckLakeMIT lakehouse table format on SQL + Parquet — a DuckDB extension

    Free / OSS · OSS/MIT · 3.3k GitHub stars

    VerdictMIT SQL-catalog lakehouse format when DuckDB is your engine and Iceberg’s catalog stack feels heavy — confirm multi-engine support first.

    CatchNeeds a separate catalog database you run and back up (DuckDB file for one writer, Postgres/MySQL for multi-client). Engines outside DuckDB support it far less widely than Iceberg or Delta Lake — check your Spark/Trino/warehouse story before committing. Younger format with a shorter production track record. Vs the duckdb gem: DuckDB is the engine; DuckLake is the table format and catalog layer on top.

  • ScryHosted freemium MCP + SQL over public-record corpora

    Paid-led · Freemium

    VerdictFreemium public-record research API. MCP+SQL over an indexed corpus; not Firecrawl, Crawl4AI, or an OSS database.

    CatchResearcher is non-commercial; Team starts from $2k. This is a hosted data product, not an OSS dump you can fork and self-host. Vs Firecrawl / Crawl4AI / Context7: Scry is indexed corpus + SQL, not page fetch, crawl, or documentation packing. Check corpus coverage, freshness, and commercial terms before treating a query as evidence.

FAQ

What is the top free pick among Sql tools?
Drizzle ORM leads the Stack Gems list for Sql tools. Verdict: SQL-first type safety for the abstraction-allergic.
How many Sql tools does Stack Gems review?
5: 4 free or open source, 1 paid or paid-led. Each review has a verdict and an honest Catch; no tool pays for its spot.
Which Sql tools can I self-host for free?
Drizzle ORM, SQLModel, dbmate and DuckLake.
Which Sql tools have the most GitHub stars?
Drizzle ORM (36.1k), SQLModel (18.4k), dbmate (7.5k), per GitHub on 2026-10-21. Stars measure attention, not fit; read the Catch.
What is the catch with Drizzle ORM?
Less magic means more typing.