PostgreSQL

提供對 PostgreSQL 資料庫的唯讀存取，允許 LLM 檢查架構並執行查詢。

GitHub

文件

K_YH mcp-db-server

Introduction

This package is purely experimental and just for fun!

Do not use this code in production or with any critical databases.

This implementation grants full control over the database to the agent. Therefore, it is strongly discouraged to use shared or sensitive databases.

References

This implementation is based on the mcp/postgres Docker image.

Usage

npx @k_yh/mcp-db-server <your-postgresql-url>

For example:

npx @k_yh/mcp-db-server 'postgresql://user:password@127.0.0.1:5432/my-db'

To use this with an agent like Claude desktop or Cursor, configure it like so:

{
  "mcpServers": {
    "my-db-server": {
      "command": "npx",
      "args": [
        "-y",
        "@k_yh/mcp-db-server",
        "postgresql://user:password@localhost:5432/my-db"
      ]
    }
  }
}

You can manipulate the database through the agent using your prompt.