Skip to content

The best DuckDB alternatives

5 tools that do a similar job to DuckDB, 5 of them open source. Each entry says what it does and who it suits, so you can pick the one that fits instead of the most famous.

You're replacing

DuckDB

An in-process analytical SQL database that runs inside your app with no server to manage.

  1. 1

    Polars

    Open source · MIT · ★ 40.2k

    A fast library for working with tables of data (DataFrames), written in Rust with Python and other bindings.

    Best for: Python users who analyze large CSV or Parquet files and find slower tools too slow; Data analysts who want lazy queries that the engine can optimize before running

  2. 2

    Turso

    Open source · MIT · ★ 25.1k

    An in-process SQL database in Rust that aims for SQLite compatibility, with Postgres support in progress.

    Best for: Developers who want an embedded SQLite-compatible database in a Rust, JavaScript, Python, Java, Go, or .NET project; Teams exploring a Rust-based alternative to SQLite that wants features like concurrent writes via MVCC

  3. 3

    lowdb

    Open source · MIT · ★ 22.6k

    A small JSON-file database you use with plain JavaScript arrays and objects.

    Best for: Node.js developers building small tools or prototypes that need simple persistent storage; Projects where a full database server would be more setup than the job needs

  4. 4

    Kysely

    Open source · MIT · ★ 14.3k

    A type-safe TypeScript SQL query builder that checks your queries against your table types.

    Best for: TypeScript developers who want SQL control without losing compile-time type checks; Teams building Node.js backends that query PostgreSQL, MySQL, SQLite or MSSQL

  5. 5

    libSQL

    Open source · MIT · ★ 17.3k

    An open-source fork of SQLite that accepts outside contributions.

    Best for: Developers who already use SQLite and want extra features like embedded replicas; Teams that want a SQLite-based database they can reach remotely through libsql-server

How we pick: tools in the same category that solve the same problem, projects that name each other as alternatives, and open-source projects that describe themselves as an alternative to DuckDB. We don't take payment for placement.