MCP.so
ログイン

MCP SQLite Server

@cnosuke

リポジトリ

MCP SQLite Server について

Generic MCP server to manipulate SQLite

基本情報

カテゴリ

データベース

ランタイム

go

トランスポート

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 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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

mcp-server-duckdb

ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

177

Redis

modelcontextprotocol

Model Context Protocol Servers

88.2K

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412