SQLite Explorer MCP Server

1[![MseeP.ai Security Assessment Badge](https://mseep.net/pr/hannesrudolph-sqlite-explorer-fastmcp-mcp-server-badge.png)](https://mseep.ai/app/hannesrudolph-sqlite-explorer-fastmcp-mcp-server)
2 
3# SQLite Explorer MCP Server
4 
5An 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.
6 
7## 📋 System Requirements
8 
9- Python 3.6+
10- SQLite database file (path specified via environment variable)
11 
12## 📦 Dependencies
13 
14Install all required dependencies:
15 
16```bash
17# Using pip
18pip install -r requirements.txt
19```
20 
21### Required Packages
22- **fastmcp**: Framework for building Model Context Protocol servers
23 
24All dependencies are specified in `requirements.txt` for easy installation.
25 
26## 📑 Table of Contents
27- [System Requirements](#-system-requirements)
28- [Dependencies](#-dependencies)
29- [MCP Tools](#%EF%B8%8F-mcp-tools)
30- [Getting Started](#-getting-started)
31- [Installation Options](#-installation-options)
32  - [Claude Desktop](#option-1-install-for-claude-desktop)
33  - [Cline VSCode Plugin](#option-2-install-for-cline-vscode-plugin)
34- [Safety Features](#-safety-features)
35- [Development Documentation](#-development-documentation)
36- [Environment Variables](#%EF%B8%8F-environment-variables)
37 
38## 🛠️ MCP Tools
39 
40The server exposes the following tools to LLMs:
41 
42### read_query
43Execute a SELECT query on the database with built-in safety validations. Features:
44- Query validation and sanitization
45- Parameter binding support
46- Row limit enforcement
47- Results formatted as dictionaries
48 
49### list_tables 
50List all available tables in the database with their names.
51 
52### describe_table
53Get detailed schema information for a specific table, including:
54- Column names and types
55- NULL constraints
56- Default values
57- Primary key information
58 
59## 🚀 Getting Started
60 
61Clone the repository:
62 
63```bash
64git clone https://github.com/hannesrudolph/sqlite-explorer-fastmcp-mcp-server.git
65cd sqlite-explorer-fastmcp-mcp-server
66```
67 
68## 📦 Installation Options
69 
70You can install this MCP server in either Claude Desktop or the Cline VSCode plugin. Choose the option that best suits your needs.
71 
72### Option 1: Install for Claude Desktop
73 
74Install using FastMCP:
75 
76```bash
77fastmcp install sqlite_explorer.py --name "SQLite Explorer" -e SQLITE_DB_PATH=/path/to/db
78```
79 
80Replace `/path/to/db` with the path to your SQLite database file.
81 
82### Option 2: Install for Cline VSCode Plugin
83 
84To use this server with the [Cline VSCode plugin](http://cline.bot):
85 
861. In VSCode, click the server icon (☰) in the Cline plugin sidebar
872. Click the "Edit MCP Settings" button (✎)
883. Add the following configuration to the settings file:
89 
90```json
91{
92  "sqlite-explorer": {
93    "command": "uv",
94    "args": [
95      "run",
96      "--with",
97      "fastmcp",
98      "--with",
99      "uvicorn",
100      "fastmcp",
101      "run",
102      "/path/to/repo/sqlite_explorer.py"
103    ],
104    "env": {
105      "SQLITE_DB_PATH": "/path/to/your/database.db"
106    }
107  }
108}
109```
110 
111Replace:
112- `/path/to/repo` with the full path to where you cloned this repository (e.g., `/Users/username/Projects/sqlite-explorer-fastmcp-mcp-server`)
113- `/path/to/your/database.db` with the full path to your SQLite database file
114 
115## 🔒 Safety Features
116 
117- Read-only access to SQLite databases
118- Query validation and sanitization
119- Parameter binding for safe query execution
120- Row limit enforcement
121- Progress output suppression for clean JSON responses
122 
123## 📚 Development Documentation
124 
125The repository includes documentation files for development:
126 
127- `mcp-documentation.txt`: Contains comprehensive documentation about the MCP server implementation and FastMCP framework usage.
128 
129This documentation serves as context when developing features and can be used with LLMs to assist in development.
130 
131## ⚙️ Environment Variables
132 
133The following environment variables must be set:
134 
135- `SQLITE_DB_PATH`: Full path to the SQLite database file you want to explore
136