mcp-sqlite-server
If you are the rightful owner of mcp-sqlite-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
SQLite MCP Server is a Python-based server that connects to a SQLite database, exposing table schemas and providing tools for SQL queries and data analysis prompts.
The SQLite MCP Server is designed to interface with a SQLite database containing startup funding data. It leverages the MCP Python SDK to expose database schemas as resources, execute read-only SQL queries, and provide prompt templates for data analysis tasks. The server communicates using the STDIO protocol, making it compatible with MCP clients and language models (LLMs). This setup allows for seamless integration and interaction with the database, facilitating data-driven insights and analysis.
Features
- Resources: Exposes SQL table schemas as MCP resources, allowing clients to retrieve schema information.
- Tools: Provides a read-only SQL query tool that permits only SELECT statements for safe data retrieval.
- Prompts: Offers prompt templates to assist language models in generating data analysis insights.
- STDIO Protocol: Utilizes the STDIO protocol for communication, reading from stdin and writing to stdout.
- Logging: Incorporates Python’s logging module to trace server activity and debug errors.
Tools
sql_query
Executes read-only SQL queries, allowing only SELECT statements.
