SQLite Explorer

概要

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.

主な機能

• 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.

ユースケース

• 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.