广告合作
MCP.so
登录
D

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

常见问题

1

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.

2

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.

3

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.

4

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.

5

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.

评论

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

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

NPILayer

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617
广告合作