joaoh82/rust_sqlite

Health v2 · maintenance only

Adoption not part of the score

1091 stars · 56 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

SQLRite is an embedded SQL database engine written from scratch in Rust, modeled on SQLite with a paged single-file format, B-tree storage, write-ahead log, and ACID transactions. It extends the SQLite model with HNSW vector search, BM25 full-text search, an MCP server, and SDKs for Rust, Python, Node, Go, C, and WASM.

Use cases

• embed a lightweight SQL database in a Rust application
• learn how database internals like B-trees and WALs work
• run vector similarity search alongside SQL queries
• full-text search with BM25 in an embedded database
• expose a local database to an LLM via MCP
• try a SQL engine in the browser with WebAssembly
• single-file embedded database with transactions and JOINs

When to choose

• you want an embedded, single-file SQL database with vector and full-text search built in
• you are studying or teaching database engine internals in Rust
• you need an MCP server that gives AI agents local SQL access
• you want multi-language bindings (Python, Node, Go, C, WASM) around one engine

When to avoid

• you need a battle-tested production database with decades of hardening - use SQLite or PostgreSQL
• you require the full SQL standard, complex aggregates over JOINs, or advanced features SQLRite has not implemented
• you need a client-server networked database rather than an embedded one

Facets

library · maturity active

database search-engine vector-database cli mcp parser databases developer-tools education rust cross-platform cli wasm python go embedded-database sqlite-alternative b-tree write-ahead-log acid-transactions hnsw-vector-search bm25-full-text-search single-file-database database-internals repl educational search command-line nodejs desktop

Member repositories

For agents

markdown · JSON · MCP: product_card(name="joaoh82/rust_sqlite")