Coffy: Local-First Embedded Database Engine for Python

Coffy is a lightweight, local-first embedded database engine supporting NoSQL, SQL, and Graph models — all in pure Python. Designed for fast prototyping, scripting, and local apps.

coffydb.org

Installation

pip install coffy

Features

Local persistence (JSON, SQLite)
In-memory mode (:memory: or None)
No server needed
Logical and comparison operators
Unified query interface
Command Line Interface (CLI)

Engines

If you are viewing this from coffydb.org, you can find the documentation for each engine in the NoSQL, Graph, and SQL sections.

| Engine | Description | Docs | |--------|-------------|------| | coffy.graph | Local graph database (NetworkX-based) | Graph Docs | | coffy.nosql | Document store with chainable queries | NoSQL Docs | | coffy.sql | Thin SQLite wrapper | SQL Docs |

What sets Coffy apart?

Only embedded Python graph DB with:

✅ Declarative traversal syntax (match_node_path(...))
✅ Label/type filtering, limit/offset, result projection
✅ Unified API for both nodes and relationships
✅ Robust CLI

Only pure-Python embedded document store with:

✅ Auto-indexing on all top-level fields
✅ Chainable logical queries (.where(...).eq(...).or_().in_())
✅ Merge/lookups across collections (like mini $lookup)
✅ JSON persistence or in-memory fallback

🔗 Links

coffydb.org
PyPI: coffy
Source: GitHub

License

Disclaimer: Number of downloads includes mirrors.

Coffy

Install / Use

README