SQLite Explorer MCP Server

@hannesrudolph

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

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

SQLite Explorer MCP Server 配置

暂无标准配置

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

代码仓库

SQLite Explorer MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 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

常见问题

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.

数据库分类下的更多 MCP 服务器

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412