SQLite MCP Server
This is a Model Context Protocol (MCP) server implementation providing database interaction and business intelligence through SQLite.
Key Features:
- SQL Query Execution: Enables running SQL queries for data retrieval and manipulation.
- Business Intelligence: Facilitates business data analysis and automatic generation of insight memos.
- Dynamic Resource: Exposes a continuously updated business insights memo (
memo://insights
). - Demo Prompt: Includes an interactive prompt (
mcp-demo
) to guide users through database operations and analysis for a given business domain. - Core Tools: Offers tools for query execution (
read_query
,write_query
,create_table
), schema inspection (list_tables
,describe-table
), and insight generation (append_insight
).
Use Cases:
- Analyzing business data stored in SQLite databases.
- Generating automated business insights and reports.
- Integrating database interactions into larger MCP workflows.