# Datanotes

> Datanotes is an open-source MCP server for knowledge and memory. Turns a folder of Markdown notes into typed, validated tables for agents. It runs locally on your machine and is started by your AI client.

- **Kind:** MCP server
- **Pricing:** Open source
- **Platforms:** CLI, self-hosted, API
- **Website:** https://datanotes.dev
- **Repository:** https://github.com/davidefornelli/datanotes
- **MCP Registry name:** io.github.davidefornelli/datanotes
- **Categories:** knowledge and memory, databases
- **Listing updated:** 2026-11-15

## About

Each note that carries a table property becomes a row, with its front matter keys as columns, while the file stays plain Markdown you can open in Obsidian, VS Code or git. A single metastore.yaml defines the columns. The engine checks types, links, unique values and CHECK rules, and a refused write changes nothing and explains how to fix the call.

Every write made through the engine is journaled with who made it (agent, session, token), so a change can be taken back with `undo_migration`, and with history turned on a table can be read as it was last week. Agents, programs and a phone can write at once; each write is checked against the latest data and applies whole or not at all. Hand edits are checked too and the engine reports what they break.

Beyond tables it offers joins, saved views, text and meaning-based search, link walking, git sync and an HTTP API with a JavaScript client. It runs locally on Node.js 22 or newer under Apache-2.0. The README says it is not a replacement for SQLite or Postgres: it is comfortable around 10,000 notes, and at 50,000 the first start takes about 15 seconds.

## Features

- **Notes as tables:** Notes with a table property become rows; metastore.yaml defines the columns.
- **Checked, atomic writes:** Types, links, unique values and CHECK rules are validated, and a bad write changes nothing.
- **Journal and undo:** Writes are journaled with their author, and undo_migration reverses a change.
- **Joins and views:** Filter, join and aggregate rows and save a query as a view.
- **Search by text and meaning:** Search note text, find notes by meaning and walk links.
- **Git sync:** Commits and pushes the vault, and a private repo can back up undo and history.

## Good for

- Log things you watched or read and find them again later
- Keep linked tables like films, actors and viewings in plain notes
- Let several agents write to one vault without corrupting it
- Build a small app on top of an Obsidian vault over HTTP

## Install

### Claude Code (Terminal)

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

### Claude Desktop (claude_desktop_config.json)

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

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

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

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

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

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

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

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

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

## Tools

- `update_row`: Updates a row in a table and writes the change back to its note.
- `undo_migration`: Takes back a change the engine journaled.

## FAQ

### Do my notes stop being Markdown?

No. Every row is still a note (or a section of a pack note) that you can read, edit, grep or commit.

### Can I undo an agent's change?

Yes. The engine journals every write it makes and undo_migration takes a change back.

### Is it a replacement for Postgres?

No. The README advises a classic database for large analytical data, high write throughput or many concurrent writers on one folder.

### What does it need to run?

Node.js 22 or newer (24.16 or newer on Windows).

### How do clients connect?

Run npx -y datanotes mcp --database your_database_folder, or add it to Claude Code, Claude Desktop, Cursor, VS Code or Codex.

### Is Datanotes free?

Yes. Datanotes is open source, so you can use and self-host it for free.

### How do I add Datanotes to Claude Code?

Run this command in your terminal: claude mcp add datanotes -- npx -y datanotes

### What are the best alternatives to Datanotes?

The closest alternatives to Datanotes 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/datanotes
