drio
Open app

SQLite Explorer MCP Server

Source

Mirror of

Catalog onlyCatalog onlySTDIO

Overview

SQLite Explorer MCP Server is an MCP server that provides safe, read-only access to SQLite databases through the Model Context Protocol (MCP). It is built using the FastMCP framework, allowing LLMs to explore and query SQLite databases with safety features and query validation.

To use the SQLite Explorer MCP Server, clone the repository, install the required dependencies, and set the environment variable for the SQLite database path. You can then run the server and use it with tools like Claude Desktop or the Cline VSCode plugin.

  • Safe, read-only access to SQLite databases - Built-in query validation and sanitization - Support for executing SELECT queries with parameter binding - Tools for listing tables and describing table schemas
  1. Providing safe access to SQLite databases for LLMs.
  2. Enabling developers to explore database schemas without modifying data.
  3. Assisting in data analysis and querying through a secure interface.

Add to your AI client

Use these steps to connect SQLite Explorer MCP Server in Cursor, Claude, VS Code, and other MCP-compatible apps. The same JSON appears in the Use with menu above for one-click copy.

Cursor

Add this to your .cursor/mcp.json file in your project root, then restart Cursor.

.cursor/mcp.json

{
  "mcpServers": {
    "hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror"
      ]
    }
  }
}

Claude Desktop

Add this server entry to the mcpServers object in your Claude Desktop config, then restart the app.

~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%\Claude\claude_desktop_config.json (Windows)

{
  "mcpServers": {
    "hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror"
      ]
    }
  }
}

Claude Code

Add this to your project's .mcp.json file. Claude Code will detect it automatically.

.mcp.json (project root)

{
  "mcpServers": {
    "hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror"
      ]
    }
  }
}

VS Code (Copilot)

Add this to your .vscode/mcp.json file. Requires the GitHub Copilot extension with MCP support enabled.

.vscode/mcp.json

{
  "servers": {
    "hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror"
      ]
    }
  }
}

Windsurf

Add this to your Windsurf MCP config file, then restart Windsurf.

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror"
      ]
    }
  }
}

Cline

Open Cline settings, navigate to MCP Servers, and add this server configuration.

Cline MCP Settings (via UI)

{
  "mcpServers": {
    "hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-hannesrudolph-sqlite-explorer-fastmcp-mcp-server-mcp-mirror"
      ]
    }
  }
}

FAQ

Is the SQLite Explorer MCP Server free to use?

Yes! The server is open-source and free to use.

What are the system requirements?

You need Python 3.6+ and a SQLite database file.

How does the server ensure safety?

The server implements query validation, sanitization, and read-only access to prevent data modification.7:["$","div",null,{"className":"container mx-auto flex flex-col gap-4","children":["$L26","$L27",["$","$L28",null,{"currentProject":{"id":642,"uuid":"a84c2f76-fd2b-400f-a7c6-4ac428c47e9d","name":"hannesrudolph_sqlite-explorer-fastmcp-mcp-server","title":"SQLite Explorer MCP Server","description":"Mirror of","avatar_url":"https://avatars.githubusercontent.com/u/192820360?v=4","created_at":"2024-12-30T03:25:04.366Z","updated_at":"2025-02-23T07:15:12.098Z","status":"created","author_name":"MCP-Mirror","author_avatar_url":"https://avatars.githubusercontent.com/u/192820360?v=4","tags":"sqlite,mcp-server,database-explorer","category":"research-and-data","is_featured":false,"sort":1,"url":"https://github.com/MCP-Mirror/hannesrudolph_sqlite-explorer-fastmcp-mcp-server","target":"_self","content":"$29","summary":"$2a","img_url":null,"type":null,"metadata":null,"user_uuid":null,"tools":null,"sse_url":null,"sse_provider":null,"sse_params":null,"is_official":false,"server_command":null,"server_params":null,"server_config":null,"allow_call":false,"is_innovation":false,"is_dxt":false,"dxt_manifest":null,"dxt_file_url":null,"is_audit":false},"randomProjects":[],"currentServerKey":"$undefined"}]]}]

Research and data