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.
pip install coffy
- ✅ Local persistence (JSON, SQLite)
- ✅ In-memory mode (
:memory:orNone) - ✅ No server needed
- ✅ Logical and comparison operators
- ✅ Unified query interface
| 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 |
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
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
- PyPI: coffy
- Source: GitHub
- Graph Documentation: GRAPH_DOCS.md
- SQL Documentation: SQL_DOCS.md
- NoSQL Documentation: NOSQL_DOCS.md
MIT License © 2025 Neel Sarathy