Skip to content
MCP server

Emerald

Local SQLite database an AI model fills and checks through typed MCP tools

Runs locallyStatus and history
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-mcp

Add to claude_desktop_config.json

{
  "mcpServers": {
    "emerald": {
      "command": "npx",
      "args": [
        "-y",
        "emerald-mcp"
      ]
    }
  }
}
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "emerald": {
      "command": "npx",
      "args": [
        "-y",
        "emerald-mcp"
      ]
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

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

  1. Codebase Memory

    MCP server

    Local MCP server that builds a code knowledge graph for AI coding agents

    Runs locally
    • Open source
    • 48.7K GitHub stars
    • Knowledge and memory
  2. XERJ

    MCP server

    Local search engine for AI agents with cited answers over your code and docs

    Runs locally
    • Open source
    • 19.2K GitHub stars
    • Knowledge and memory
  3. MCP 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
  4. Local-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
  5. Midplane

    MCP server

    Postgres gateway for AI agents with table grants, column masking and approval for writes

    Runs locally
    • Open source
    • 5 GitHub stars
    • Databases
  6. note1

    MCP server

    MCP server giving AI assistants search and summaries across your note1 meetings

    • 4 tools
    • Remote
    • Free trial
    • 1 GitHub star
    • Productivity