Postgresql MCP example

This starts a postgresql mcp server that loads csv files when started and provides a read only mcp server to interface with the data.

Quick start

Build the mcp docker container

docker build -t mcp_benchmarks-mcp-server .

Update your claude desktop server config:

{
  "mcpServers": {
    "postgres": {
      "command": "<use the output of `which docker`>",
      "args": [
        "run", 
        "-i", 
        "--rm", 
        "--network=host",
        "mcp_benchmarks-mcp-server", 
        "postgresql://postgres:postgres@host.docker.internal:5432/benchmarks"
      ]
    }
  }
}

Start the postgresql database container: docker-compose up

Start claude desktop and ask questions about your data.