SQLite Graph is unlocking graph data inside a single SQLite database, powered by a Cypher-style virtual table. In alpha from Agentflare AI, you can CREATE nodes and relationships, then MATCH patterns and RETURN results — all without leaving SQLite. This approach blends graph power with the simplicity of a single-file database. [1]
What you can do today - CREATE and MATCH with full relationship support [1] - WHERE clause with node property comparisons on nodes [1] - RETURN with basic JSON projections [1] - Virtual table integration for mixing SQL and Cypher in one DB [1]
Performance snapshot - 340K nodes/sec inserts; ~1M nodes/sec under scale testing [1] - 390K edges/sec for relationships [1] - 180K nodes/sec scans with WHERE filtering [1]
Current limits & roadmap - Only forward relationships (no bidirectional) [1] - No relationship property filtering in WHERE [1] - No variable-length paths, aggregations, or ORDER BY in RETURN [1] - Roadmap targets full Cypher support by Q1 2026 [1]
Why this matters in a single-file world For lightweight relationship modeling and pattern-based queries, this lets you model simple graphs inside a single-file SQLite database environment without extra infrastructure [1]. It’s an attractive option for apps that want graph-features tucked into a familiar SQL workflow.
Keep an eye on this alpha—it's a promising bridge between SQL and graph databases. [1]
References
Show HN: SQLite Graph – Graph database with Cypher queries (alpha, but working)
Adds a graph database layer to SQLite with Cypher support; supports CREATE, MATCH, and RETURN via a virtual table extension.
View source