Db View MCP Server

@conte777

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

conte777

投稿者

Alexey

Db View MCP Server について

MCP server that gives AI assistants direct access to PostgreSQL and ClickHouse databases. Supports stdio and HTTP transports.

#database #postgresql #clickhouse #sql #query

Db View MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "database": {
      "command": "npx",
      "args": [
        "-y",
        "@conte777/db-view-mcp",
        "--config",
        "/path/to/config.json"
      ]
    }
  }
}

Db View MCP Server のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

上のボタンで一時的なサンドボックスでこのサーバーを実行し、ツール一覧を取得できます。

概要

What is db-view-mcp?

db-view-mcp is an MCP server that gives AI assistants direct access to PostgreSQL and ClickHouse databases. It supports stdio and HTTP transports, allowing both local IDE integration and remote network access.

How to use db-view-mcp?

Install with npm install @conte777/db-view-mcp, configure a config.json listing databases and optional transport settings, then run via npm start -- --config config.json. Add the server to your MCP client (e.g., Claude Desktop or Claude Code) using the npx command with the config path.

Key features of db-view-mcp

Supports both PostgreSQL and ClickHouse connections simultaneously
Offers read-only tools (SELECT, schema, EXPLAIN) and write tools (INSERT/UPDATE/DELETE, DDL, transactions)
Provides two transport modes: stdio for local IDE use and HTTP for remote/multi-client access
Includes SQL safety with read-only tools that block accidental writes
Supports optional bearer token authentication for HTTP transport
Allows lazy connections (connect on first use) to avoid unneeded startup overhead

Use cases of db-view-mcp

Let AI coding assistants query a project's database directly from an IDE like Cursor or Claude Code
Enable remote database exploration and management via a web application using HTTP transport
Run schema introspection and performance analysis (EXPLAIN ANALYZE, slow query tracking) through AI chat
Perform batch data inserts, updates, or DDL operations via an AI agent in a controlled session

よくある質問

What databases does db-view-mcp support?

It supports PostgreSQL and ClickHouse. You can connect to any number of instances of either type simultaneously in one server.

How do I switch between stdio and HTTP transport?

Set `"transport.type"` to `"http"` in config.json, or use the CLI flag `--transport http`. The default is stdio.

Can I prevent accidental writes to the database?

Yes. Read-only tools (`query`, `list_tables`, etc.) validate SQL to block write keywords. Write operations require the explicit `execute` or `transaction` tool.

Does db-view-mcp support transactions?

Yes, for PostgreSQL. The `transaction` tool allows begin, commit, and rollback. ClickHouse does not support transactions — using the transaction tool on ClickHouse throws an error.

How does authentication work for HTTP transport?

Optional bearer token authentication can be enabled by setting `transport.auth.type` to `"bearer"` with a token value. Requests to `/mcp` must include an `Authorization: Bearer <token>` header. The `/health` endpoint is not protected.

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

MongoDB MCP Server

mongodb-js

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.

1.1K

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

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