# stoolap/stoolap

A Modern Embedded SQL Database written in Rust

Repository: https://github.com/stoolap/stoolap
Canonical: https://ross.abutalabs.com/products/stoolap
Homepage: https://stoolap.io
Language: Rust
License: Apache-2.0
License Family: permissive
Topics: database, embedded-sql, mvcc, rust, sql
Last push: 2026-09-02T23:12:48+00:00

## Health v2 (maintenance only)
Score: 76/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 100, release rhythm 77, longevity 18
- inputs: {"age_days": 265, "days_push": 0, "days_rel": 154, "gap_med": 5, "n_releases_24m": 14}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1210, forks 45 (observed 2026-09-03T02:15:18.156817+00:00)

## What it is
Stoolap is a modern embedded SQL database written in pure Rust, offering ACID transactions with MVCC, a cost-based query optimizer, parallel query execution, and native vector search via HNSW indexes. It runs in-process with no external server and ships first-party drivers for Python, Go, Node.js, Java, C#, and other languages.

## Use cases
- embed a SQL database in a Rust application without an external server
- run transactional workloads with MVCC and snapshot isolation
- query historical data with AS OF time-travel queries
- add vector similarity search to an embedded database
- use SQL from Python, Go, Node.js, Java, or C# via native drivers
- run analytical queries with parallel execution and columnar storage

## When to choose
- you want an embedded, in-process SQL database with modern features like MVCC and time-travel queries
- you need vector search alongside relational SQL in a single binary
- you prefer a pure Rust, memory-safe alternative to SQLite or DuckDB for embedded use
- you need multi-language drivers for an embedded engine

## When to avoid
- you need a battle-tested database with a long production track record
- you require a client-server database with network access from many hosts
- your stack depends on mature ecosystem tooling and extensions built for SQLite or PostgreSQL

## Facets
- artifact type: library
- maturity: active
- function: database, search-engine, vector-database
- domain: databases, developer-tools, backend
- platform: rust, cross-platform, python, go, jvm, dotnet, wasm
- tags: embedded-database, sql, mvcc, acid, time-travel-queries, hnsw, vector-search, columnar-storage, query-optimizer, in-memory-database, nodejs

## Member repositories
- stoolap/stoolap (main) score 76

## Provenance
- Observed fields: from GitHub, fetched 2026-09-03T02:15:18.156817+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:18:56.256334+00:00, confidence not recorded.
  - readme: https://github.com/stoolap/stoolap (fetched 2026-09-03T02:15:18.156817+00:00, sha c6ffb711c983)
  - homepage: https://stoolap.io (fetched 2026-08-29T12:26:41.213789+00:00, sha fd2e59c0d956)
  - site_page: https://stoolap.io/docs (fetched 2026-08-29T12:26:41.216726+00:00, sha 1e69bd6d52fc)
  - site_page: https://stoolap.io/docs/getting-started/installation (fetched 2026-08-29T12:26:41.220660+00:00, sha 8092a5314d63)
  - site_page: https://stoolap.io/docs/drivers/python (fetched 2026-08-29T12:26:41.222851+00:00, sha d5cec216ec0d)
  - site_page: https://stoolap.io/docs/drivers/go (fetched 2026-08-29T12:26:41.225128+00:00, sha eb64c46b8f87)
  - site_page: https://stoolap.io/docs/drivers/nodejs (fetched 2026-08-29T12:26:41.227141+00:00, sha 14644202725c)
  - site_page: https://stoolap.io/docs/drivers/java (fetched 2026-08-29T12:26:41.229984+00:00, sha 3ae801b61e31)
  - site_page: https://stoolap.io/docs/drivers/csharp (fetched 2026-08-29T12:26:41.232678+00:00, sha 41afc5875ed3)
  - registry_crates: https://crates.io/api/v1/crates/stoolap (fetched 2026-08-29T12:26:41.235510+00:00, sha 316de58f9b20)
- Data as of 2026-08-30T08:39:29.467469+00:00.