Happy slice of mcp pizzaMCP.pizza

sqlite-explorer-fastmcp-mcp-server

MCP.Pizza Chef: hannesrudolph

Three tools point at one SQLite file you choose: list its tables, describe a table's columns, and run a question against it. The read-only promise is mostly real, since it rejects anything that is not a read and refuses several commands at once. But the check only inspects the first word, so a carefully worded query can still slip a change past it. There is also no licence file at all, which usually rules it out for work use. No changes since July 2025.

Unmaintained · No commits in 14 months.
Data
Spreadsheets

Use This MCP server To

Find out what tables are inside a database file I was given Count how many orders came in last month Look up a customer's records without building a report See which columns a table holds before I use it Pull a quick summary out of an app's saved data

README

MseeP.ai Security Assessment Badge

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:

# Using pip
pip install -r requirements.txt

Required Packages

  • fastmcp: Framework for building Model Context Protocol servers

All dependencies are specified in requirements.txt for easy installation.

📑 Table of Contents

🛠️ MCP Tools

The server exposes the following tools to LLMs:

sqlite-explorer-fastmcp-mcp-server FAQ

Do I need a key?
No. It runs on your own machine against one database file you name, and nothing is sent anywhere.
Can it change or delete my data?
It is meant to be read-only and does block ordinary write commands, but the guard only checks the first word of a query. A query starting with WITH can still carry a change through, so point it at a copy of anything you cannot lose.
Can I use this to ask questions about a database?
Yes, that is exactly what it is for. Ask in plain English, and it works out the query, lists the tables and returns the rows.
Which apps does it work in?
Claude Desktop and Cline in VS Code are documented, and it works in anything that can start a local command.
How hard is setup?
Developer-level. You clone the project, install its packages, then either run its install command or paste a configuration block naming the path to your database file.
Can I use it at work?
Probably not without asking first. The project ships no licence file whatsoever, which means nobody has formally been granted permission to use it. Most employers treat that as a blocker.
Is there a cap on how much it returns?
There is a thousand-row default, but it is skipped whenever the word limit already appears anywhere in your query, so very large results can still come back at you.
Is it maintained?
Only quietly. The last code change was July 2025, over a year ago, and it is pinned to an old version of the framework it is built on.