010: Securely access data through MCP PostgreSQL

Project Introduction

Provides read-only access to a PostgreSQL database. The server allows Large Language Models (LLMs) to inspect the database schema and perform read-only queries.

Core Features

• • Provides read-only access to a PostgreSQL database
• • Allow LLM (Large Language Model) to view database schema and perform read-only queries
• • Ensure data security (read operations only)

Configuration usage

Two configuration methods are provided:

The Docker way

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run", 
        "-i", 
        "--rm", 
        "mcp/postgres", 
        "postgresql://host.docker.internal:5432/mydb"
      ]
    }
  }
}

Special Notes:

• • When running Docker on MacOS, if the server is running on the host network, use host.docker.internal
• • You can add username and password to the PostgreSQL URL: postgresql://user:password@host:port/db-name

NPX method

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/mydb"
      ]
    }
  }
}

Build Instructions

Docker build commands are provided:

docker build -t mcp/postgres -f src/postgres/Dockerfile .