SQLite Explorer
Createdhannesrudolph
Provides safe, read-only access to SQLite databases for exploration and querying by Large Language Models (LLMs).
About
SQLite Explorer is an MCP server designed to facilitate secure, read-only interaction between Large Language Models (LLMs) and SQLite databases. Built on the FastMCP framework, it enables LLMs to explore database schemas, execute queries, and retrieve data while ensuring safety through query validation, sanitization, and row limit enforcement. This tool exposes functionalities like listing tables, describing table schemas, and executing SELECT queries, making it easier for LLMs to work with SQLite databases in a controlled environment.
Key Features
- Validates and sanitizes queries to prevent malicious SQL injection.
- Supports parameter binding for safe query execution.
- Enforces row limits to control the amount of data returned.
- 22 GitHub stars
- Provides read-only access to SQLite databases, ensuring data integrity.
- Formats results as dictionaries for easy parsing by LLMs.
Use Cases
- Using LLMs to explore and understand SQLite database schemas.
- Enabling LLMs to answer questions based on data stored in SQLite databases.
- Allowing LLMs to generate reports from SQLite data.