Emerald
Local SQLite database an AI model fills and checks through typed MCP tools
- Pricing
- Open source
- Platforms
- macOS, Windows, CLI
- Runs
- Locally
- Version
- 0.4.0
- Listing updated
- 3 days ago
About Emerald
Emerald is an open-source MCP server for databases. It runs locally on your machine and is started by your AI client.
Everything lives in one .emd file, a real SQLite database on your disk that sqlite3 can open. You declare a table for anything you keep, such as a charge, a paycheck or a milestone, and each stated rule becomes a CHECK, so a value that does not fit is refused when it is written.
The model never gets a free-form query. The README describes shaped tools instead: 28 for any document and 86 once the ledger pack is added. Deletes and column changes run as a dry run until you say commit, and a copy is kept beside the document before any write.
Two packs ship with it. The ledger reads card statements, bank exports and payslips and opens every total to the rows it came from. The development pack keeps a project's decisions, open questions and inbox as rows, so a new session starts from them rather than from a chat summary.
Install
Run in a terminal
claude mcp add emerald -- npx -y emerald-mcpAdd to claude_desktop_config.json
{
"mcpServers": {
"emerald": {
"command": "npx",
"args": [
"-y",
"emerald-mcp"
]
}
}
}Add to ~/.cursor/mcp.json
{
"mcpServers": {
"emerald": {
"command": "npx",
"args": [
"-y",
"emerald-mcp"
]
}
}
}Add to .vscode/mcp.json
{
"servers": {
"emerald": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"emerald-mcp"
]
}
}
}Add to ~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"emerald": {
"command": "npx",
"args": [
"-y",
"emerald-mcp"
]
}
}
}Add to your client's MCP settings (most use this shape)
{
"mcpServers": {
"emerald": {
"command": "npx",
"args": [
"-y",
"emerald-mcp"
]
}
}
}What it does
- Typed local tables
- Each table has real types and a CHECK for every rule you state, so bad values are refused on write.
- Claims that must hold
- Rules such as a receipt total matching a card charge are marked proved, failed or unchecked, with the reason for unchecked.
- Files read onto formats
- Spreadsheets, CSV, JSON and Markdown notes are mapped to columns once and checked on every read.
- Dry-run deletes
- Deletes and column changes are previewed until you confirm, and a backup copy is kept before writes.
- Drawn views
- Where the host supports MCP Apps, sheets, boards and roadmaps are drawn in the conversation.
- Ledger and development packs
- Prebuilt formats for personal finance and for a project's decisions and open questions.
Good for
- Keep a household ledger built from card statements and payslips
- Give a coding project a memory of decisions and open questions
- Track hours or milestones with totals that open to their rows
- Load a spreadsheet and have a model query it without guessing values
Pricing
Open source
Free software under AGPL-3.0; no account
Prices change. Check getemerald.dev before you buy.
Emerald FAQ
Does Emerald need an account or internet connection?
No. The README says the app makes no network call of its own and needs no login; an optional update check is off by default.
What format are documents stored in?
Each document is a `.emd` file, which is a SQLite database that ordinary SQLite tools can open.
Can the model run arbitrary SQL?
No. It works through shaped tools, never a general query, and wrong values are refused with a reason.
What licence does it use?
The README says it is free software under AGPL-3.0.
Is Emerald free?
Yes. Emerald is open source, so you can use and self-host it for free.
How do I add Emerald to Claude Code?
Run this command in your terminal: claude mcp add emerald -- npx -y emerald-mcp
What are the best alternatives to Emerald?
The closest alternatives to Emerald are Codebase Memory, XERJ, Claude Code Ultimate Guide, Nautilus Compass Memory and Midplane.
Alternatives to Emerald

Codebase Memory
MCP serverLocal MCP server that builds a code knowledge graph for AI coding agents
Runs locally- Open source
- 48.7K GitHub stars
- Knowledge and memory

XERJ
MCP serverLocal search engine for AI agents with cited answers over your code and docs
Runs locally- Open source
- 19.2K GitHub stars
- Knowledge and memory

Claude Code Ultimate Guide
MCP serverMCP server for searching the Claude Code Ultimate Guide from any MCP client
Runs locally- Open source
- 6.5K GitHub stars
- AI models and LLM tooling

Nautilus Compass Memory
MCP serverLocal-first long-term memory layer for AI agents, served over MCP
Not checked yet- 5 tools
- Remote
- Open source
- 1.3K GitHub stars
- Knowledge and memory

Midplane
MCP serverPostgres gateway for AI agents with table grants, column masking and approval for writes
Runs locally- Open source
- 5 GitHub stars
- Databases

note1
MCP serverMCP server giving AI assistants search and summaries across your note1 meetings
- 4 tools
- Remote
- Free trial
- 1 GitHub star
- Productivity