Skip to main content
Glama
Ethan2298

DataBook

by Ethan2298

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: MCP SQLite Server

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
A
license - permissive license
-
quality - not tested
F
maintenance

Maintenance

Maintainers
Response time
Release cycle
Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Ethan2298/DataBook'

If you have feedback or need assistance with the MCP directory API, please join our Discord server