PostgreSQL MCP Server

Cung cấp quyền truy cập chỉ đọc vào cơ sở dữ liệu PostgreSQL, cho phép LLM kiểm tra lược đồ và thực thi truy vấn.

GitHub

Tài liệu

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:[email protected]: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.