Coffy - GitLite

KO | EN

gitlite — search

#javascript #python #typescript #go #android #rust #nodejs #windows #kubernetes #awesome-list #pytorch #ios #mcp #openai

Coffy

(★ 86)

Open source lightweight embedded database engine for Python that supports NoSQL, SQL, and Graph data models.

File Explorer

Download Latest Version (.zip)

- - bug_report.md
  - feature_request.md
- - publish.yml
- CODE_OF_CONDUCT.md
- CONTRIBUTING.md
- Coffy preview image.png
- graphviz.png
- logo.png
- nosqlviz.png
- sqlviz.png
- - __init__.py
  - graph_cli.py
  - nosql_cli.py
  - sql_cli.py
- - __init__.py
  - atomicity.py
  - graph_result.py
  - graph_view.py
  - graphdb_nx.py
- - __init__.py
  - atomicity.py
  - doclist.py
  - engine.py
  - index_engine.py
  - nosql_view.py
  - query_builder.py
- - __init__.py
  - engine.py
  - orm.py
  - sql_view.py
  - sqldict.py
- __init__.py
- - GRAPH_CLI.md
  - NOSQL_CLI.md
  - SQL_CLI.md
- - graph_demo_animals.py
  - GRAPH_EXAMPLES.md
  - graphvizeg.png
  - nosql_demo_space.py
  - NOSQL_EXAMPLES.md
  - SQL_EXAMPLES.md
- GRAPH_DOCS.md
- NOSQL_DOCS.md
- SQL_DOCS.md
- USER_GUIDE.md
- test_graph.py
- test_graph_cli.py
- test_nosql.py
- test_nosql_cli.py
- test_sql.py
- test_sql_cli.py
- test_sql_orm.py
.gitignore
LICENSE
MANIFEST.in
pyproject.toml
README.md
run_tests.py
setup.py

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Coffy: Local-First Embedded Database Engine for Python

[![PyPI](https://img.shields.io/pypi/v/coffy)](https://pypi.org/project/coffy/)
![PyPI Downloads](https://static.pepy.tech/badge/coffy)

**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](https://coffydb.org/)

---

## Installation

```bash
pip install coffy
```

---
![preview](https://github.com/nsarathy/Coffy/blob/main/assets/Coffy%20preview%20image.png)
---
## 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](https://github.com/nsarathy/Coffy/blob/main/Documentation/GRAPH_DOCS.md) |
| `coffy.nosql` | Document store with chainable queries | [NoSQL Docs](https://github.com/nsarathy/Coffy/blob/main/Documentation/NOSQL_DOCS.md) |
| `coffy.sql`   | Thin SQLite wrapper | [SQL Docs](https://github.com/nsarathy/Coffy/blob/main/Documentation/SQL_DOCS.md) |

---

## 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](https://coffydb.org/)
- PyPI: [coffy](https://pypi.org/project/coffy/)
- Source: [GitHub](https://github.com/nsarathy/Coffy)

---

## License

MIT License © 2025 [Neelesh Sarathy](https://github.com/nsarathy)

---

Disclaimer: Number of downloads includes mirrors.