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.
Installation
pip install coffy
Features
- Local persistence (JSON, SQLite)
- In-memory mode (
:memory:orNone) - 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
MIT License © 2025 Neelesh Sarathy
Disclaimer: Number of downloads includes mirrors.
Metadata
Release files for coffy 0.2.5
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| coffy-0.2.5.tar.gz | 50.4 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| coffy-0.2.5-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 92.5 kB
Release files / coffy-0.2.5.tar.gz
| Download URL | coffy-0.2.5.tar.gz |
|---|---|
| Size | 50.4 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
f0ef0ae20e0849c1f8e082c191c7ace30d7a62b244feb6614a6ad675f09b038a
|
|
BLAKE2b-256 checksum How to use checksums |
8fbe3a2f8b69f7c0e3232581609a0b7331a7d28df2c1d68ad120367e7217e712
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.11.13
|
Release files / coffy-0.2.5-py3-none-any.whl
| Download URL | coffy-0.2.5-py3-none-any.whl |
|---|---|
| Size | 42.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
c4a12d30c38f240d41c244dae57b5dc2108de7305cf18832abff5ea075f08680
|
|
BLAKE2b-256 checksum How to use checksums |
808dafec3bfa4f08d1d8fa01121aabd9088bca400a33986f9dbb23b9fcd1ac82
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.11.13
|