SQLite Explorer MCP Server

Name: SQLite Explorer MCP Server
Author: hannesrudolph

@hannesrudolph

关于 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.

#python #sqlite #mcp #database-tools #llm-tools #llm-integration

基本信息

分类

数据库

运行时

python

传输方式

stdio

发布者

hannesrudolph

配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

工具

未检测到工具

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is SQLite Explorer MCP Server?

SQLite Explorer MCP Server is a read-only Model Context Protocol server that allows LLMs to explore and query SQLite databases safely. Built with the FastMCP framework, it enforces query validation, parameter binding, and row limits to prevent harmful operations. It is intended for developers who need LLM-driven database inspection without write access.

How to use SQLite Explorer MCP Server?

Clone the repository, install dependencies via pip install -r requirements.txt, set the SQLITE_DB_PATH environment variable to point to a SQLite database file, then install the server using either fastmcp install for Claude Desktop or a JSON configuration for the Cline VSCode plugin. The server exposes three tools: read_query, list_tables, and describe_table.

Key features of SQLite Explorer MCP Server

Read-only access to SQLite databases
Query validation and sanitization
Parameter binding for safe query execution
Row limit enforcement
Clean JSON responses (progress output suppressed)

Use cases of SQLite Explorer MCP Server

Allow an LLM to list tables in a local SQLite database
Let an LLM describe a table’s schema (columns, types, constraints)
Enable safe, read-only SQL querying from an AI assistant
Integrate SQLite exploration into Claude Desktop or Cline VSCode plugin workflows

FAQ from SQLite Explorer MCP Server

How does SQLite Explorer MCP Server differ from a general SQLite client?

Unlike a general client, it only allows read-only queries and enforces validation, parameter binding, and row limits to protect the database from harmful or accidental writes.

What are the runtime/dependency requirements?

Python 3.6+, the fastmcp and uvicorn packages (installed via requirements.txt), and a path to an existing SQLite database file.

Where does the database data live?

The database file is located on the local filesystem at the path specified by the SQLITE_DB_PATH environment variable.

What are the known limits?

All queries are read-only; write operations (INSERT, UPDATE, DELETE, DDL) are blocked. Query results are capped by a row limit to prevent excessive output.

What transport or authentication does it use?

It uses the standard Model Context Protocol; no authentication is mentioned. Communication is local and configured via MCP settings in Claude Desktop or the Cline VSCode plugin.