Zaia
Provides tools for listing datasets and tables, describing columns, querying with read-only SQL, and retrieving paginated data from SQLite databases.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@Zaialist datasets"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
Maia
Build 2 of the Hermes stack: the MCP server.
Exposes the sqlite datasets produced by zeus as MCP tools/resources, so an MCP client (e.g. Claude Desktop) can explore and query them. Transport is Streamable HTTP.
Install
Requires uv.
cd maia
uv syncRelated MCP server: sqlite-reader-mcp
Usage
Generate data with zeus first (see ../zeus), then point maia at
its output directory:
cd zeus && uv run zeus generate patient_history -n 500 --seed 42 -f sqlite
cd zeus && uv run zeus generate pharma_sales -n 20000 --seed 42 -f sqlite
cd maia && uv run maia serve --data-dir ../zeus/output --host 127.0.0.1 --port 8000--data-dir defaults to $MAIA_DATA_DIR or ./output. It scans
<data_dir>/<use_case>/<use_case>.db — each subdirectory with a .db file
becomes a queryable "dataset" — and re-scans on every call, so newly
generated datasets show up without restarting the server.
Tools
Tool | Purpose |
| List datasets and their tables |
| Tables + row counts for a dataset |
| Columns (name + inferred type) + one sample row |
| Paginated raw rows, no SQL needed |
| Arbitrary read-only SQL ( |
Also one resource template, maia://{dataset}/schema, returning the full
table/column listing for a dataset as JSON.
For example prompts and Claude Desktop configuration, see
../docs/client-setup.md.
All access is strictly read-only: the sqlite connection itself is opened in
mode=ro, so writes fail at the DB layer even if query's SQL-prefix check
were somehow bypassed.
Claude Desktop setup
Claude Desktop's claude_desktop_config.json launches MCP servers over
stdio, so an HTTP server needs a bridge — mcp-remote
does this:
{
"mcpServers": {
"maia": {
"command": "npx",
"args": ["-y", "mcp-remote", "http://127.0.0.1:8000/mcp"]
}
}
}Start maia serve first, then restart Claude Desktop to pick up the config.
See ../docs/client-setup.md for details.
MCP Inspector
MCP Inspector connects directly to an MCP server over Streamable HTTP, with no client or bridge in between.
Start maia first:
cd maia
uv run maia serve --data-dir ../zeus/output --host 127.0.0.1 --port 8000Then, in another terminal, launch Inspector against it. See
../docs/client-setup.md (Step 4) for the full
walkthrough (interactive UI + scriptable CLI mode with examples).
Layout
maia/
├── pyproject.toml
├── src/maia/
│ ├── data.py # dataset discovery + read-only sqlite access (no MCP dependency)
│ ├── server.py # FastMCP instance: tools + resource
│ └── cli.py # typer CLI: `maia serve`
└── tests/
└── test_data.pyThis server cannot be deployed
Maintenance
Related MCP Connectors
Query, join, profile, clean and convert CSV/JSON/Parquet with server-side DuckDB over MCP.
Read-only MCP server for The Quiet Protocol's engines, benchmarks, proof, and business data.
An MCP server that provides read access to your cloud storage providers, bank accounts and more.
Host your MCP tool over streamable HTTP in one command.
Related MCP Servers
- FlicenseNot gradedqualityDmaintenanceAn MCP server that provides safe, read-only access to SQLite databases through MCP. This server is built with the FastMCP framework, which enables LLMs to explore and query SQLite databases with built-in safety features and query validation.107-
- AlicenseNot gradedqualityDmaintenanceA lightweight MCP server that provides read-only access to SQLite databases, allowing users to execute SELECT queries, list tables, and describe table schemas.1MIT
- FlicenseNot gradedqualityCmaintenanceCustom MCP server connected to a read-only SQLite database, exposing a schema resource and a query tool for safe data retrieval.-
- AlicenseCqualityAmaintenanceAn MCP server for interacting with SQLite databases, enabling SQL query execution, schema inspection, and CRUD operations.7MIT