Skip to main content
Glama

SQLite MCP Server

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

# 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

The application can be easily deployed using Nixpacks with platforms like Railway, Coolify, or Render:

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

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

// 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' });

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

-
security - not tested
F
license - not found
-
quality - not tested

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)和表管理。

  1. 特征
    1. 开发与部署
      1. 本地开发
      2. Docker 部署
      3. Nixpacks部署
    2. 可用工具
      1. 远程服务器连接
        1. 示例用法
          1. 环境变量
            1. 贡献
              1. 执照

                Related MCP Servers

                • A
                  security
                  A
                  license
                  A
                  quality
                  A 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 -
                  17
                  MIT License
                  • Apple
                • -
                  security
                  F
                  license
                  -
                  quality
                  A 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
                • A
                  security
                  A
                  license
                  A
                  quality
                  A Model Context Protocol server that enables executing SQL queries and managing connections with Microsoft SQL Server databases.
                  Last updated -
                  1
                  49
                  5
                  MIT License
                • A
                  security
                  A
                  license
                  A
                  quality
                  A Model Context Protocol server that allows users to store, retrieve, update, and delete memories using SQLite storage.
                  Last updated -
                  5
                  6
                  MIT License

                View all related MCP servers

                MCP directory API

                We provide all the information about MCP servers via our MCP API.

                curl -X GET 'https://glama.ai/api/mcp/v1/servers/isaacgounton/sqlite-mcp-server'

                If you have feedback or need assistance with the MCP directory API, please join our Discord server