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

Related MCP server: Database MCP Server

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

1. read_query: Execute SELECT queries

2. write_query: Execute INSERT, UPDATE, or DELETE queries

3. create_table: Create new tables

4. list_tables: List all tables in the database

5. describe_table: View schema information for a table

6. append_insight: Add business insights to the memo

Remote Server Connection

To connect using SSE in n8n:

1. Add an MCP Client node

2. Configure SSE connection:

   • SSE URL: http://localhost:3000/sse

   • Messages Post Endpoint: http://localhost:3000/messages

   • No additional headers required

Example Usage

Environment Variables

None required by default. If using file-based storage, modify the database path in src/index.ts.

Contributing

1. Fork the repository

2. Create your feature branch (git checkout -b feature/amazing-feature)

3. Commit your changes (git commit -m 'Add some amazing feature')

4. Push to the branch (git push origin feature/amazing-feature)

5. Open a Pull Request

License

ISC