About SQLite MCP Server
The SQLite MCP Server is a utility server that enables AI assistants to interact with SQLite databases through the Model Context Protocol (MCP). It provides tools for executing SQL queries, analyzing business data, and automatically generating business insight memos. Key components include:
**Resources:**
- memo://insights: A dynamic resource that aggregates discovered insights during analysis, auto-updating as new insights are appended
**Tools:**
- read_query: Executes SELECT queries to read data from the database.
- write_query: Executes INSERT, UPDATE, or DELETE queries.
- create_table: Creates new tables in the database.
- list_tables: Retrieves a list of all tables in the database.
- describe_table: Provides schema information for a specific table.
- append_insight: Adds new business insights to the memo resource, triggering an update of the memo://insights resource.
Designed for local operation, the server ensures data privacy and security. It is actively maintained as an open-source project.