MCP MCP Server

MCP server for SQLite files. Supports Datasette-compatible metadata!

Local serverstdio

What is the MCP MCP server?

MCP MCP server exists for a simple reason — assistants are far more useful when they can act on MCP directly instead of describing what you should do. MCP server for SQLite files. Supports Datasette-compatible metadata!.

What you get

Provide useful data to AI agents without giving them access to external systems. Compatible with Datasette for human users!

  • AI agents can get the structure of all tables and columns in the SQLite database in one command - sqlite_get_catalog
  • The catalog can be enriched with descriptions for the tables and columns using a simple YAML or JSON metadata file
  • The same metadata file can contain canned queries to the AI to use
  • AI agents can execute arbitrary SQL queries with sqlite_execute

Setting it up

The server ships on npm as @modelcontextprotocol/inspector, so your MCP client can launch it on demand — there is no separate build step. Add the server block to your client's configuration, restart it, and the tools register themselves.

What the assistant can call

Once MCP is connected, these are the calls the assistant has available:

  • Datasette — Since mcp-sqlite metadata is compatible with the Datasette metadata file, you can also explore your data with Datasette: uvx datasette serve
  • Metadata — The Metadata tool exposed by this server

Before you rely on it

  • It runs with your machine's permissions. That is convenient and also the reason to think about what you point it at before you approve a tool call.
  • MCP clients confirm each tool call by default. Leave that on until you have watched what the mcp mcp server does with a few real requests.

Choosing this one

This sits in the database access group, where several servers overlap in what they claim to do but differ sharply once you actually set them up. MCP's toolset — Datasette, Metadata — is a fair guide to whether it matches your workflow.

This entry was verified against MCP's own documentation before publication; SyncDev keeps the directory reviewed rather than auto-generated.

Available tools

ToolWhat it does
DatasetteSince mcp-sqlite metadata is compatible with the Datasette metadata file, you can also explore your data with Datasette: uvx datasette serve sample/titanic.db --metadata sample/titanic.yml Compatibility with Datasette al
MetadataThe Metadata tool exposed by this server.

How to install the MCP MCP server

{
  "mcpServers": {
    "sqlite-4": {
      "command": "npx",
      "args": ["-y", "@modelcontextprotocol/inspector"]
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Example prompts to try

  • Use MCP to Datasette.
  • Use MCP to Metadata.

Frequently asked questions

It connects MCP to MCP-compatible AI assistants such as Claude and Cursor, exposing 2 tools (Datasette, Metadata) that the assistant can call on your behalf. Instead of copying data back and forth by hand, the assistant works with MCP directly.