PG MCP SERVER

@cbc3929

Basic information

About PG MCP SERVER

No overview available yet

PG MCP SERVER config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "pg_mcp_server": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "pg-mcp-server:latest",
        "."
      ]
    }
  }
}

PG MCP SERVER tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is PG_MCP_SERVER?

PG_MCP_SERVER is a general-purpose PostgreSQL MCP (Model Context Protocol) server that provides efficient schema context to large language models by pre-processing table structures. It supports PostGIS and PgVector extensions and communicates via Stdio or SSE transports.

How to use PG_MCP_SERVER?

Configure the database connection string either in main.go via RegisterConnection or by setting the SCHEMA_LOAD_DB_URL environment variable. Run with Docker (docker run -d -p 8181:8181 pg-mcp-server:latest) or directly with go run ./cmd/server/main.go after cloning and installing dependencies.

Key features of PG_MCP_SERVER

Pre-fetches database schema to reduce token usage.
Uses MCP Tool descriptions and Resources for implicit schema context.
Supports PostGIS geometry types, indexes, and EPSG codes.
Native PgVector extension support.
Implements Stdio and SSE transports.
Docker deployment available.

Use cases of PG_MCP_SERVER

Provide LLMs with optimized database context without repeated schema queries.
Query spatial data in PostGIS-enabled databases through natural language.
Manage vector embeddings stored with PgVector via LLM agents.
Enable secure, role-based read-only database access for MCP applications.

Frequently asked questions

Why does PG_MCP_SERVER pre-process the database schema instead of reading it on every call?

Reading the schema on each call consumes significant time and token context. Pre-processing caches table structures, columns, constraints, foreign keys, indexes, geometry types, and EPSG codes during initialization.

What database permissions does PG_MCP_SERVER require?

It recommends creating a dedicated role with `SELECT` on the `public` schema and all privileges on a `temp` schema. Configuring a role limits SQL injection risk and protects sensitive data.

Which PostgreSQL extensions are supported?

PostGIS and PgVector are fully supported. PgRouting support is marked as partial (⭕).

What transport protocols are available?

PG_MCP_SERVER supports Stdio and SSE transports via the `go-mcp` library.

How do I configure the database connection?

Set the connection string in `main.go` with `schemaLoadConnID, err := dbService.RegisterConnection(tempCtx, "postgres://user:pass@host:port/db")` or use the `SCHEMA_LOAD_DB_URL` environment variable in a `.env` file.

Comments

More Other MCP servers

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

MCP Toolbox for Databases

googleapis

MCP Toolbox for Databases is an open source MCP server for databases.

15.9K

Glasswarp

See and control a real Windows PC you own — from any MCP client, locally or remotely. Observe (UIA + screenshots), click/type/drag/scroll, launch apps, owner Live View. BYOH: your machine, your key.

Lemon.io

lemon-io

Request dedicated senior developers to work on your project, write job descriptions, and prep technical interviews — all without leaving your Claude chat. Just describe what you need, and Lemon.io MCP does the rest. 1–3

Next Generation Movers: free moving quotes (remote MCP)

Next Generation Movers

Free moving quotes for AI agents from Next Generation Movers, a licensed interstate mover (USDOT 3764697). US long-distance nationwide and local DC/MD/VA. Indicative ballpark price and booking options; optional $0.01 x40