SQLite MCP Server

What it does

SQLite MCP integrates the Model Context Protocol (MCP) directly into the SQLite database engine. This allows you to bridge the gap between your data and the AI agent ecosystem by invoking MCP server tools from within standard SQL queries.

Tools

• mcp_connect: Establishes a connection to an MCP server via URL.
• mcp_list_tools_json: Retrieves a JSON list of available tools and their schemas from the connected server.
• mcp_call_tool_json: Executes a specific tool on the MCP server with provided arguments and returns the result as JSON.
• mcp_list_tools_respond: A virtual table providing structured access to available tools.
• mcp_call_tool_respond: A virtual table for extracting text results from tool calls.

Installation

To use SQLite MCP, load the extension into your SQLite environment:

.load ./dist/mcp.dylib
SELECT mcp_connect('http://localhost:8000/mcp');

Supported hosts

Supported via any SQLite-compatible environment, including Flutter, Android, iOS, macOS, and Linux.