← All docs
HybridDB

Persistent local data for AI apps.

HybridDB combines SQLite rows, FTS5 keyword search, ChromaDB vectors, optional DuckDB analytics, graph context, and repairable indexes in one embedded Python package.

Install

pip install hybriddb

60-second quickstart

from hybriddb import HybridDB, HYBRID, LONGTEXT, TEXT

db = HybridDB("./my_data")
db.create_table("docs", {"title": TEXT, "body": LONGTEXT})

db.insert("docs", {
    "title": "Getting Started",
    "body": "HybridDB stores local rows and searchable long text.",
})

results = db.search("docs", "body", "local searchable data", mode=HYBRID)

Core concepts

  • SQLite is the source of truth.
  • TEXT columns get keyword search.
  • LONGTEXT columns get keyword and vector search.
  • DuckDB analytics and graph helpers are optional layers.
  • Derived indexes can be rebuilt from local truth.

Useful APIs

  • create_table, insert, query
  • search, search_columns
  • export_sql, import_sql
  • backup, restore
  • check_integrity, stats, reindex