Zum Inhalt springen
Kitbay
Einreichen
MCP-Server

mcp-sqlite

Läuft lokalApache-2.0Aktualisiert am 26. Jan. 202628GitHub-SterneKann Daten ändernKein API-Key nötig

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.

Was er kann

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.

Funktionen

  • 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