SQLite MCP Server
by isaacgounton
An MCP server that provides SQLite database operations through a standardized interface. It offers SQL operations and table management capabilities.
Last updated: N/A
What is SQLite MCP Server?
SQLite MCP Server is a Model Context Protocol server that enables interaction with an SQLite database using a standardized interface. It supports various SQL operations and table management functions.
How to use SQLite MCP Server?
The server can be deployed locally using npm or via Docker and Nixpacks. Once deployed, you can connect to it using an MCP client (e.g., in n8n) and use the available tools (read_query, write_query, etc.) to interact with the SQLite database.
Key features of SQLite MCP Server
In-memory SQLite database (configurable for file-based storage)
SQL operations (SELECT, INSERT, UPDATE, DELETE)
Table management (CREATE, LIST, DESCRIBE)
Business insights memo tracking
Docker support for easy deployment
Use cases of SQLite MCP Server
Building data-driven applications with a standardized database interface
Integrating SQLite databases into workflow automation tools (e.g., n8n)
Providing a consistent API for accessing and manipulating SQLite data
Tracking business insights alongside database operations
FAQ from SQLite MCP Server
What is the default database storage?
What is the default database storage?
The default storage is in-memory, but it can be configured to use file-based storage.
How do I connect to the server remotely?
How do I connect to the server remotely?
You can connect using SSE with an MCP client, configuring the SSE URL and Messages Post Endpoint.
What SQL operations are supported?
What SQL operations are supported?
The server supports SELECT, INSERT, UPDATE, and DELETE queries.
How do I create a table?
How do I create a table?
Use the create_table tool with a valid CREATE TABLE query.
Can I deploy this server using Docker?
Can I deploy this server using Docker?
Yes, Docker support is provided for easy deployment.