SQLite MCP Server
Overview
A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
Components
Resources
The server exposes a single dynamic resource:
memo://insights: A continuously updated business insights memo that aggregates discovered insights during analysis
Prompts
The server provides a demonstration prompt:
mcp-demo: Interactive prompt that guides users through database operations
Tools
The server offers six core tools:
Query Tools
read_query
write_query
create_table
Schema Tools
list_tables
describe-table
Analysis Tools
append_insight
Usage with Claude Desktop
uv
Docker
Building
Docker:
Test with MCP inspector
License
This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
SQLite MCP Server
Overview
A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
Components
Resources
The server exposes a single dynamic resource:
memo://insights: A continuously updated business insights memo that aggregates discovered insights during analysis
Prompts
The server provides a demonstration prompt:
mcp-demo: Interactive prompt that guides users through database operations
Tools
The server offers six core tools:
Query Tools
read_query
write_query
create_table
Schema Tools
list_tables
describe-table
Analysis Tools
append_insight
Usage with Claude Desktop
uv
Docker
Building
Docker:
Test with MCP inspector
License
This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
SQLite MCP Server
Overview
A Model Context Protocol (MCP) server implementation that provides database interaction and business intelligence capabilities through SQLite. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos.
Components
Resources
The server exposes a single dynamic resource:
memo://insights: A continuously updated business insights memo that aggregates discovered insights during analysis
Prompts
The server provides a demonstration prompt:
mcp-demo: Interactive prompt that guides users through database operations
Tools
The server offers six core tools:
Query Tools
read_query
write_query
create_table
Schema Tools
list_tables
describe-table
Analysis Tools
append_insight
Usage with Claude Desktop
uv
Docker
Building
Docker:
Test with MCP inspector
License
This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.