MCP.so
登录

MCP SQLite Server

@cnosuke

基本信息

分类

数据库

传输方式

stdio

作者

cnosuke

提交者

cnosuke

关于 MCP SQLite Server

Generic MCP server to manipulate SQLite

MCP SQLite Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp-sqlite-cnosuke": {
      "command": "docker",
      "args": [
        "pull",
        "cnosuke/mcp-sqlite:latest"
      ]
    }
  }
}

MCP SQLite Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表,不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MCP SQLite Server?

MCP SQLite Server is a Go-based MCP (Model Context Protocol) server that wraps an SQLite database. It allows MCP clients such as Claude Desktop to interact with SQLite using a standardized JSON‑RPC protocol.

How to use MCP SQLite Server?

Use Docker (recommended) with docker run -i --rm cnosuke/mcp-sqlite:latest or mount a custom SQLite database. Alternatively, build the Go binary and run with a YAML config file and environment variables. Then integrate with MCP clients (e.g., Claude Desktop) by adding the server to claude_desktop_config.json.

Key features of MCP SQLite Server

  • Fully compliant with the MCP specification.
  • Execute CREATE TABLE, SELECT, INSERT, UPDATE, and DELETE queries.
  • Retrieve table schemas and list all tables.
  • Configurable via YAML file or environment variables.
  • Logging directed to a file (suppressed when used with stdio transport).

Use cases of MCP SQLite Server

  • Allow Claude Desktop to create and query SQLite databases in real time.
  • Persist data by mounting an existing SQLite database file into the Docker container.
  • Manage database schemas and explore table structures programmatically.
  • Run read and write queries directly from an MCP-enabled assistant.

常见问题

1

What are the requirements to run MCP SQLite Server?

Docker is recommended. For local development, you need Go 1.24+, SQLite, and GCC/CGO tools.

2

How do I use MCP SQLite Server with Claude Desktop?

Add an entry to your `claude_desktop_config.json` with the Docker command or the Go binary path and its arguments.

3

How do I configure logging?

Set the `log` config option or `LOG_PATH` environment variable to a file path. For stdio transport (e.g., Claude Desktop), set it to an empty string to avoid interfering with protocol messages.

4

What MCP tools does the server provide?

It supports `create_table`, `describe_table`, `list_tables`, `read_query`, and `write_query`.

5

Is there persistent storage when using Docker?

Yes. Mount an SQLite file from the host to `/app/sqlite.db` in the container using the `-v` flag.

评论

数据库 分类下的更多 MCP 服务器