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.

コメント

「データベース」の他のコンテンツ