DataBook

An AI-editable SQL database app powered by MCP. The MCP server is the app — its tool definitions encode the product decisions. The AI's capabilities become the feature set.

What is DataBook?

DataBook is a Model Context Protocol (MCP) server that gives AI assistants full control over a collection of SQLite databases. Instead of building a traditional CRUD UI, DataBook exposes database operations as MCP tools — letting any MCP-capable AI client (Claude, Cursor, etc.) act as the interface.

Tools

Database Management

| Tool | Description | |------|-------------| | list_databases | List all available databases | | select_database | Choose which database to work with | | create_database | Create a new empty database | | delete_database | Delete a database permanently |

Schema Management

| Tool | Description | |------|-------------| | list_tables | List all tables in the selected database | | describe_table | Show table schema and column definitions | | create_table | Create a table with column definitions | | alter_table | Add, rename, drop columns, or rename the table | | drop_table | Delete a table and all its data |

Data CRUD

| Tool | Description | |------|-------------| | insert_rows | Insert one or more rows | | update_rows | Update rows matching a WHERE condition | | delete_rows | Delete rows matching a WHERE condition |

Query

| Tool | Description | |------|-------------| | query | Execute any SQL statement and return results |

Query Pages (Views)

| Tool | Description | |------|-------------| | create_query_page | Save a named query with a view type (table, kanban, calendar, etc.) | | list_query_pages | List all saved query pages for the current database | | update_query_page | Rename, change query, or change view type | | delete_query_page | Remove a saved query page |

Storage

• Each database is a separate .db SQLite file stored in ~/.databook/ (configurable via DATABOOK_DIR)
• Query pages are stored in ~/.databook/.meta.db — a metadata SQLite database

Setup

Install

npm install
npm run build

Run

npm start
# or
node dist/index.js

Configure data directory

DATABOOK_DIR=/path/to/data node dist/index.js

Connecting to Claude Desktop

Add to your claude_desktop_config.json:

{
  "mcpServers": {
    "databook": {
      "command": "node",
      "args": ["/path/to/DataBook/dist/index.js"],
      "env": {
        "DATABOOK_DIR": "/path/to/your/data"
      }
    }
  }
}

Or using npx after publishing:

{
  "mcpServers": {
    "databook": {
      "command": "npx",
      "args": ["databook"]
    }
  }
}

Architecture

DataBook MCP Server (TypeScript)
  │
  ├── DatabaseManager          # Core logic layer
  │   ├── SQLite files         # One .db file per database (via better-sqlite3)
  │   └── .meta.db             # Query pages metadata
  │
  └── McpServer (stdio)        # MCP transport
      └── 17 tools             # The complete feature set

Development

npm run dev    # Watch mode (recompiles on change)
npm run build  # Production build