SQLite Explorer

by hannesrudolph

40 stars

526 downloads

Not rated

GitHub

About

Secure, read-only access to query and analyze SQLite databases.

Details

Author: hannesrudolph
Repository: hannesrudolph/sqlite-explorer-fastmcp-mcp-server
GitHub stars: 40
Downloads: 526
Categories: AI, Design, Developer Tools, Search, Database, Frontend, Infrastructure
Tags: #mobile

Setting up with Highlight

This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:

Download and install Highlight from highlightai.com/download
Navigate to the plugins tab and select "Add Custom Plugin"
Configure the plugin with the settings below
Plugin Name SQLite Explorer

Command (node, npx, python, etc.) uv
Arguments
- Argument 1 run
- Argument 2 --with
- Argument 3 fastmcp
- Argument 4 --with
- Argument 5 uvicorn
- Argument 6 fastmcp
- Argument 7 run
- Argument 8 /path/to/repo/sqlite_explorer.py
Environment
- SQLITE_DB_PATH /path/to/your/database.db
Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
Enable "Start Automatically" if you want the plugin to start when Highlight launches

Setting up with Cursor

Open Cursor's settings
Navigate to the MCP section
Click "Add new Global MCP server"
Copy and paste the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "/c",
                "uv",
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

Setting up with Claude Desktop

Open Claude Desktop's settings
Go to the Integrations tab
Click "Add MCP Server"
Use the configuration below based on your operating system

Note: Make sure Claude Desktop is running before attempting to connect.

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "/c",
                "uv",
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

Setting up with Windsurf

Open Windsurf's preferences
Go to the Integrations section
Click "Add MCP Integration"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "/c",
                "uv",
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

Setting up with Cline

Open Cline's settings
Navigate to the Integrations section
Click "Add MCP Server"
Copy and paste the configuration below based on your operating system

Note: Make sure to restart Cline after adding the configuration.

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "/c",
                "uv",
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

Setting up with Goose

Open Goose's preferences
Go to the Integrations tab
Select "MCP Servers"
Click "Add New Server"
Use the configuration below based on your operating system

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "/c",
                "uv",
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "cmd"
        }
    }
}

JSON

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

From the repository

Clone the repository:

git clone https://github.com/hannesrudolph/sqlite-explorer-fastmcp-mcp-server.git
cd sqlite-explorer-fastmcp-mcp-server

You can install this MCP server in either Claude Desktop or the Cline VSCode plugin. Choose the option that best suits your needs.

Install using FastMCP:

fastmcp install sqlite_explorer.py --name "SQLite Explorer" -e SQLITE_DB_PATH=/path/to/db

Replace /path/to/db with the path to your SQLite database file.

To use this server with the Cline VSCode plugin:

1. In VSCode, click the server icon (☰) in the Cline plugin sidebar
2. Click the "Edit MCP Settings" button (✎)
3. Add the following configuration to the settings file:

{
  "sqlite-explorer": {
    "command": "uv",
    "args": [
      "run",
      "--with",
      "fastmcp",
      "--with",
      "uvicorn",
      "fastmcp",
      "run",
      "/path/to/repo/sqlite_explorer.py"
    ],
    "env": {
      "SQLITE_DB_PATH": "/path/to/your/database.db"
    }
  }
}

`read_query`

Execute a SELECT query on the database with built-in safety validations, including query validation, parameter binding support, row limit enforcement, and results formatted as dictionaries.

`list_tables`

List all available tables in the database with their names.

`describe_table`

Get detailed schema information for a specific table, including column names and types, NULL constraints, default values, and primary key information.

Claude Desktop / Cursor

Paste into your MCP client config file to install this server.

{
    "mcpServers": {
        "sqlite explorer": {
            "env": {
                "SQLITE_DB_PATH": "/path/to/your/database.db"
            },
            "args": [
                "run",
                "--with",
                "fastmcp",
                "--with",
                "uvicorn",
                "fastmcp",
                "run",
                "/path/to/repo/sqlite_explorer.py"
            ],
            "command": "uv"
        }
    }
}

Linux

{
    "env": {
        "SQLITE_DB_PATH": "/path/to/your/database.db"
    },
    "args": [
        "run",
        "--with",
        "fastmcp",
        "--with",
        "uvicorn",
        "fastmcp",
        "run",
        "/path/to/repo/sqlite_explorer.py"
    ],
    "command": "uv"
}

Macos

{
    "env": {
        "SQLITE_DB_PATH": "/path/to/your/database.db"
    },
    "args": [
        "run",
        "--with",
        "fastmcp",
        "--with",
        "uvicorn",
        "fastmcp",
        "run",
        "/path/to/repo/sqlite_explorer.py"
    ],
    "command": "uv"
}

Windows

{
    "env": {
        "SQLITE_DB_PATH": "/path/to/your/database.db"
    },
    "args": [
        "/c",
        "uv",
        "run",
        "--with",
        "fastmcp",
        "--with",
        "uvicorn",
        "fastmcp",
        "run",
        "/path/to/repo/sqlite_explorer.py"
    ],
    "command": "cmd"
}

SQLite Explorer MCP Server

An MCP server that provides safe, read-only access to SQLite databases through Model Context Protocol (MCP). This server is built with the FastMCP framework, which enables LLMs to explore and query SQLite databases with built-in safety features and query validation.

📋 System Requirements

- Python 3.6+
- SQLite database file (path specified via environment variable)

📦 Dependencies

Install all required dependencies:

```bash

No reviews yet — be the first

Use Google, GitHub, or an email account so ratings stay tied to real people.

Email sign in

No reviews posted yet.

About

Details

Jump to

Setting up with Highlight

From the repository

read_query

list_tables

describe_table

Claude Desktop / Cursor

Linux

Macos

Windows

SQLite Explorer MCP Server

📋 System Requirements

📦 Dependencies

Install

More like this

Sentry

Github

Git

GitLab

Context 7

1Panel

`read_query`

`list_tables`

`describe_table`