PostgreSQL

Provides read-only access to PostgreSQL databases, allowing LLMs to inspect schemas and execute queries.

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:[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.

Verwandte Server

NotebookLM Web Importer

Importieren Sie Webseiten und YouTube-Videos mit einem Klick in NotebookLM. Vertraut von über 200.000 Nutzern.

Chrome-Erweiterung installieren