Sqlite MCP Server

🚀 SQLite MCP Server

A Model Context Protocol (MCP) server that provides standardized interfaces for performing SQLite database operations.

✨ Features

• In-memory SQLite database (configurable for file storage)
• SQL operations (SELECT, INSERT, UPDATE, DELETE)
• Table management (CREATE, LIST, DESCRIBE)
• Business insight memo tracking
• Docker support for easy deployment

📦 Installation

Local Development

# Install dependencies and build
npm install
npm start

Docker Deployment

# Build and run with Docker
docker build -t sqlite-mcp-server .
docker run -d --name sqlite-mcp sqlite-mcp-server

Nixpacks Deployment

This application can be easily deployed via Nixpacks on platforms such as Railway, Coolify, or Render:

# Deploy using Nixpacks
nixpacks build . --name sqlite-mcp-server

No additional configuration is required as the project already includes a Dockerfile.

📚 Documentation

Available Tools

1. read_query: Execute a SELECT query
2. write_query: Execute an INSERT, UPDATE, or DELETE query
3. create_table: Create a new table
4. list_tables: List all tables in the database
5. describe_table: View the schema information of a table
6. append_insight: Add business insights to the memo

Remote Server Connection

Use SSE connection in n8n:

1. Add an MCP client node
2. Configure the SSE connection:
   • SSE URL: http://localhost:3000/sse
   • Message POST endpoint: http://localhost:3000/messages
   • No additional headers required

💻 Usage Examples

Basic Usage

// Create a table
await callTool('create_table', {
  query: 'CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)'
});

// Insert data
await callTool('write_query', {
  query: 'INSERT INTO users (name) VALUES ("John Doe")'
});

// Query data
const result = await callTool('read_query', {
  query: 'SELECT * FROM users'
});

🔧 Technical Details

Environment Variables

No configuration is required by default. If you need to use file storage, modify the database path in src/index.ts.

🤝 Contribution Guidelines

1. Fork the repository
2. Create a 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