Skip to main content
Glama
Sign In
DataBook

DataBook

by Ethan2298
OverviewSchemaSourceRelated ServersDiscussionsAdmin
TypeScript
Local

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.

Related MCP server: database-analytics-mcp

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

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    This server cannot be deployed

    Claude Code, inside the Godot 4 editorFlockbay puts an AI agent in the real Godot 4 editor: it writes GDScript, runs your game and fixes what breaks. Free, or bring your own Claude Code or Codex.flockbay.comAd

    Maintenance

    ActivityNo data
    ResponsivenessSyncing

    Resources

    Related MCP Connectors

    Related MCP Servers

    • mcp-sqlite3

      daedalus
      A
      license
      Not graded
      quality
      D
      maintenance
      Exposes sqlite3 database functionality as MCP tools, enabling SQL query execution, schema management, and CRUD operations.
      82 PyPI
      1
      MIT

    • @lubo3395/mcp-sqlite-server

      lubo3395
      A
      license
      Not graded
      quality
      D
      maintenance
      Provides a set of MCP tools to let AI assistants like Claude, Cursor, and VS Code Copilot interact with SQLite databases, supporting querying, schema management, and data import/export.
      11 npm
      MIT

    • mcp-to-db

      jorgepvenegas
      F
      license
      Not graded
      quality
      C
      maintenance
      Exposes any SQLite database as read-only MCP tools for AI assistants, enabling listing tables, describing schemas, and running SELECT queries with filtering, ordering, and pagination.
      -