Cadenya
Paid
Developers building agentic workflows
Two-tier-memory
FreeOpen SourceSelf-Hosted
AI coding agents that rely on loading markdown files into context work fine on small projects — past a hundred files, the context window silently truncates and the agent re-solves problems it already solved last week. two-tier-memory is a SQLite-backed, CLI-driven memory library that stores solved problems, decisions, and known issues in a queryable structure so your agent retrieves only what it needs, not everything at once.
Similar tools
JevProxyFreemiumThe proxy sits in front of your Cursor or Claude Code agent fleet and classifies incoming tool…
CadenyaPaidCadenya is an agent runtime built around a layered model: tools connect once through MCP…
WorldsFreemiumWorlds spins up a sealed twin of the external systems your agent touches — Stripe and Zendesk…
Brain MemoryFreeBrain Memory stores agent decisions as Markdown files with YAML frontmatter, organized in a…
Get This Tool
License: MIT Any use incl. commercial
Local-run terms: MIT license permits commercial use, modification, and distribution with attribution.
Pricing
- Model
- Free
Summary
The library implements what the repo calls the 'two-tier fix': structured storage in a local SQLite database, with semantic or keyword queries pulling back only the relevant rows instead of the entire memory corpus. The core workflow is a single Python file and a SQL schema — add a memory, query a memory, done. It runs entirely on-device with no external API calls. The wall you hit is expressiveness: the schema is fixed, so teams with complex memory taxonomies end up forking the schema or layering their own abstraction on top. At that point you are maintaining a fork.
Bottom line: Exactly right for a solo developer or small team whose agent keeps forgetting solved problems across sessions — not the right foundation when your memory schema needs to evolve with your domain, because the fixed schema means every structural change is a migration you own.
Find your fit
Before you choose Two-tier-memory
More options in Agent Frameworks. Compare pricing, platforms, and features side by side.
Brain Memory
Free · Open source
Long-term continuity in multi-session coding projects
Pros
- Queries the SQLite store for only the relevant memory entries rather than loading the full history into context, so the agent's effective memory scales with the size of the database rather than the size of the context window.
- Entirely local and dependency-light — no API keys, no network calls, no managed service — which means the memory layer cannot go down because a third-party endpoint is unavailable.
- MIT license with full source in a single Python file, so you can read exactly what happens to your stored data and modify the retrieval logic without waiting on a vendor.
- CLI-driven interface means you can add or query memories from shell scripts, editor plugins, or agent tool calls without importing a framework.
- Persistent across sessions by default via SQLite, so a solved problem recorded in one session is available in every subsequent session without any additional configuration.
Cons
- The schema ships with a fixed structure targeting solved coding problems and project decisions. Teams whose memory needs include different record types — hierarchical documentation, multi-entity relationships, or domain-specific metadata — hit the schema ceiling immediately and must fork and migrate, at which point they own all future schema evolution.
- There is no server, no sync layer, and no multi-agent access model. A team with more than one agent process, or a developer working across multiple machines, gets no shared state — each environment has its own isolated database, and keeping them consistent is a manual problem.
- At the point where a team needs semantic vector search rather than keyword or structured queries — typical once the memory corpus grows large and queries become fuzzy — this library provides no embedding or vector retrieval path. That is the condition under which teams move to a dedicated vector database or a memory framework like Mem0 instead.
About
- Platforms
- Python, SQLite
- API Available
- No
- Self-Hosted
- Yes
- Last Updated
- July 6, 2026
Best For
Who it's for
- AI coding agents with growing memory needs
- Projects using local SQLite for persistence
- Developers wanting simple CLI-based memory
What it does well
- Storing solved coding problems for later lookup
- Preventing agents from re-solving known issues
- Maintaining project decisions across sessions
Frequently Asked Questions
- Is Two-tier-memory free?
- Two-tier-memory offers a free option. Hosting, model usage, or optional services may have separate costs; check the pricing details and official terms.
- Is Two-tier-memory open source?
- Yes. Two-tier-memory is open source.
- Can I self-host Two-tier-memory?
- Yes. Two-tier-memory supports self-hosting on your own infrastructure.
- What platforms does Two-tier-memory support?
- Two-tier-memory is available on: Python, SQLite.
Curated lists that include this category
Your AI coding agent’s memory is broken the moment the project outgrows a handful of markdown files: the whole pile gets stuffed into context, the window fills, and the oldest decisions fall off the edge silently. two-tier-memory addresses this by replacing the flat-file stack with a local SQLite database and a queried retrieval layer. You record a solved problem or a project decision through the CLI or by calling the Python module directly; when the agent needs to check whether a problem is already solved, it queries the database and gets back only the matching rows — not the full history.
The differentiating design choice is explicitly architectural: the repo frames the approach as applying 1970s relational database principles to a problem that most agent setups still solve with grep-and-load. Indexing and structured storage mean retrieval time stays flat as the memory grows, rather than degrading as the context window fills. The companion essay referenced in the README makes the case that this is not a new idea, just one that the AI tooling ecosystem has been slow to apply to agent memory.
This fits narrowest and best when you need a drop-in persistence layer for a local coding agent, want zero external dependencies, and are comfortable with SQLite as your operational database. It breaks when your memory needs don’t fit the provided schema — project decisions and solved coding problems are the intended record types, and teams storing anything structurally different, such as hierarchical knowledge or multi-entity relationships, will find the fixed schema a constraint that requires forking. Any team that needs hosted, multi-user, or multi-agent shared memory will need a different architecture entirely, since the library is local-first with no server component.
The implementation is a single Python file alongside a SQL schema file and an MIT license. There is no package published to PyPI per the scraped page; setup is via direct repository clone. The CLI usage and schema are documented in the README. No external API is required at any point.
Contribute
- Work on Two-tier-memory? Claim this listing.
- Embed a badge for your README or site.
Sign in to rate this tool or suggest an edit.