# Emerald

> Emerald is an open-source MCP server for databases. Local SQLite database an AI model fills and checks through typed MCP tools. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** macOS, Windows, CLI
- **Website:** https://getemerald.dev
- **Repository:** https://github.com/kfireliyahu/emerald-emd
- **MCP Registry name:** io.github.kfireliyahu/emerald
- **Categories:** databases, knowledge and memory
- **Listing updated:** 2026-11-14

## About

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.

## Features

- **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

## Install

### Claude Code (Terminal)

```sh
claude mcp add emerald -- npx -y emerald-mcp
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "emerald": {
      "command": "npx",
      "args": [
        "-y",
        "emerald-mcp"
      ]
    }
  }
}
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "emerald": {
      "command": "npx",
      "args": [
        "-y",
        "emerald-mcp"
      ]
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "emerald": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "emerald-mcp"
      ]
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "emerald": {
      "command": "npx",
      "args": [
        "-y",
        "emerald-mcp"
      ]
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "emerald": {
      "command": "npx",
      "args": [
        "-y",
        "emerald-mcp"
      ]
    }
  }
}
```

## 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

- [Codebase Memory](https://ai-powered.com/mcp/codebase-memory): Codebase Memory is an open-source MCP server for knowledge and memory.
- [XERJ](https://ai-powered.com/mcp/xerj): XERJ is an open-source MCP server for knowledge and memory.
- [Claude Code Ultimate Guide](https://ai-powered.com/mcp/claude-code-ultimate-guide): Claude Code Ultimate Guide is an open-source MCP server for ai models and llm tooling.
- [Nautilus Compass Memory](https://ai-powered.com/mcp/nautilus-compass-memory): Nautilus Compass Memory is an open-source MCP server for knowledge and memory.
- [Midplane](https://ai-powered.com/mcp/midplane): Midplane is an open-source MCP server for databases.
- [note1](https://ai-powered.com/mcp/note1): note1 is an MCP server for productivity.
- [MedXpert 图书馆连接器（通用版）](https://ai-powered.com/mcp/medxpert): MedXpert 图书馆连接器（通用版） is an open-source MCP server for knowledge and memory.
- [Context Nest](https://ai-powered.com/mcp/context-nest): Context Nest is a freemium MCP server for knowledge and memory.

---
Source: https://ai-powered.com/mcp/emerald
