SQLite MCP Server
A Model Context Protocol (MCP) server that provides SQLite database operations through a standardized interface.
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
Development & Deployment
Local Development
Docker Deployment
Nixpacks Deployment
The application can be easily deployed using Nixpacks with platforms like Railway, Coolify, or Render:
No additional configuration is needed as the project includes a Dockerfile.
Available Tools
read_query
: Execute SELECT querieswrite_query
: Execute INSERT, UPDATE, or DELETE queriescreate_table
: Create new tableslist_tables
: List all tables in the databasedescribe_table
: View schema information for a tableappend_insight
: Add business insights to the memo
Remote Server Connection
To connect using SSE in n8n:
- Add an MCP Client node
- Configure SSE connection:
- SSE URL:
http://localhost:3000/sse
- Messages Post Endpoint:
http://localhost:3000/messages
- No additional headers required
- SSE URL:
Example Usage
Environment Variables
None required by default. If using file-based storage, modify the database path in src/index.ts
.
Contributing
- Fork the repository
- Create your feature branch (
git checkout -b feature/amazing-feature
) - Commit your changes (
git commit -m 'Add some amazing feature'
) - Push to the branch (
git push origin feature/amazing-feature
) - Open a Pull Request
License
ISC
This server cannot be installed
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
模型上下文协议服务器,通过与 SQLite 数据库的标准化接口实现 SQL 操作(SELECT、INSERT、UPDATE、DELETE)和表管理。
Related MCP Servers
- AsecurityAlicenseAqualityA Model Context Protocol server that provides database interaction capabilities through SQLite, enabling users to run SQL queries, analyze business data, and automatically generate business insight memos.Last updated -17MIT License
- -securityFlicense-qualityA Model Context Protocol server that provides tools for connecting to and interacting with various database systems (SQLite, PostgreSQL, MySQL/MariaDB, SQL Server) through a unified interface.Last updated -3
- AsecurityAlicenseAqualityA Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.Last updated -1495MIT License
- AsecurityAlicenseAqualityA Model Context Protocol server that allows users to store, retrieve, update, and delete memories using SQLite storage.Last updated -56MIT License