MCP SQLite Server

Name: MCP SQLite Server
Author: cnosuke

@cnosuke

代码仓库

关于 MCP SQLite Server

Generic MCP server to manipulate SQLite

基本信息

分类

数据库

运行时

传输方式

stdio

发布者

cnosuke

提交者

cnosuke

配置

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

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

工具

未检测到工具

工具是从 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.

FAQ from MCP SQLite Server

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.

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.

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.

What MCP tools does the server provide?

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

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 服务器

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K