Skip to content
Kitbay
Submit
MCP server

mcp-sqlite

Runs locallyApache-2.0Updated on Jan 26, 202628GitHub starsCan change dataNo API key needed

A Python MCP server that serves a local SQLite file to an agent, designed to share its metadata format with Datasette so people and agents can explore the same data.

InstallRepository Checked on Nov 12, 2026

What it does

A Python MCP server that serves a local SQLite file to an agent, designed to share its metadata format with Datasette so people and agents can explore the same data. One tool returns the full catalogue of tables and columns, enriched with descriptions from an optional YAML or JSON metadata file; another runs any SQL and returns results as HTML tables. Canned queries defined in the metadata file each become their own tool, so the agent can run them without writing SQL. It runs over stdio with uvx, and the README walks through using it with GitHub Copilot agent mode in VS Code and with MCP Inspector.

Capabilities

  • Return a catalogue of tables and columns with descriptions
  • Run arbitrary SQL on a SQLite file
  • Expose canned queries from a metadata file as tools
  • Share metadata files with Datasette

Other MCP servers and skills for SQLite