sqlite-mcp-server
If you are the rightful owner of sqlite-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol (MCP) server that provides SQLite database operations through a standardized interface.
The SQLite MCP Server is designed to facilitate database operations using the Model Context Protocol, offering a standardized interface for interacting with SQLite databases. It supports both in-memory and file-based storage configurations, allowing for flexibility in deployment. The server provides comprehensive SQL operations, including SELECT, INSERT, UPDATE, and DELETE, as well as table management capabilities such as CREATE, LIST, and DESCRIBE. Additionally, it includes a feature for tracking business insights through memos. The server is Docker-compatible, ensuring easy deployment across various environments. It also supports deployment using Nixpacks, making it suitable for platforms like Railway, Coolify, or Render. The server is equipped with tools for executing queries and managing tables, and it can be connected remotely using Server-Sent Events (SSE) in applications like n8n.
Features
- 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
Tools
read_query
Execute SELECT queries
write_query
Execute INSERT, UPDATE, or DELETE queries
create_table
Create new tables
list_tables
List all tables in the database
describe_table
View schema information for a table
append_insight
Add business insights to the memo
