SQLite MCP Server

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.