Is Pg Mcp Server safe to use?

Pg Mcp Server has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under MIT.

How do I install Pg Mcp Server?

Pg Mcp Server can be installed by cloning its GitHub repository and following the setup instructions in the README.

What can Pg Mcp Server do?

Pg Mcp Server provides 4 tools: connect, disconnect, pg_query, pg_explain. See the full tools list on the server page for descriptions and parameters.

What AI clients work with Pg Mcp Server?

Pg Mcp Server is compatible with claude-desktop, cursor, claude-code. It uses sse transport.

Is Pg Mcp Server actively maintained?

Pg Mcp Server is less actively maintained — last commit was 319 days ago. It has 540 GitHub stars.

Pg Mcp Server

Name: Pg Mcp Server
Author: stuzero

by stuzero

540 4 tools GitHub

No known CVEs

MIT license

Stale

Last commit 319d ago

Works with most clients

Transport: sse

4 tools · ~347 tok

Grade A · 0.2% of 200K ctx

MCPpedia last refreshed this data 2d ago

Edit this pageView history

Data

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Supported in Claude Desktopsse · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "pg-mcp-server": {
      "command": "<see-readme>",
      "args": []
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/pg-mcp-server)](https://mcppedia.org/s/pg-mcp-server)

Read me

What Pg Mcp Server does

A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents.

Test This Server

No automated test available for this server. Check the GitHub README for setup instructions.

Loading README…

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

64/100across 5 weighted dimensions

How we score →

0255075100

−36

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

No package registry to scan.

Inventory

Tools (4)

Click any tool to inspect its schema.

~347 tokens total

Inventory

Resources (8)

database_description

Comprehensive database description with schema and structure information

pgmcp://{conn_id}/

schemas

List schemas with descriptions

pgmcp://{conn_id}/schemas

schema_tables

List tables in a schema with descriptions and row counts

pgmcp://{conn_id}/schemas/{schema}/tables

table_columns

Get column details with data types and descriptions for a table

pgmcp://{conn_id}/schemas/{schema}/tables/{table}/columns

table_constraints

View table constraints and indexes

pgmcp://{conn_id}/schemas/{schema}/tables/{table}/constraints

table_sample

Sample table data with pagination

pgmcp://{conn_id}/schemas/{schema}/tables/{table}/sample

table_row_count

Get approximate row count for a table

pgmcp://{conn_id}/schemas/{schema}/tables/{table}/row_count

extensions

Explore database extensions with built-in context

pgmcp://{conn_id}/extensions

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is Pg Mcp Server safe to use?: Pg Mcp Server has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under MIT.
How do I install Pg Mcp Server?: Pg Mcp Server can be installed by cloning its GitHub repository and following the setup instructions in the README.
What can Pg Mcp Server do?: Pg Mcp Server provides 4 tools: connect, disconnect, pg_query, pg_explain. See the full tools list on the server page for descriptions and parameters.
What AI clients work with Pg Mcp Server?: Pg Mcp Server is compatible with claude-desktop, cursor, claude-code. It uses sse transport.
Is Pg Mcp Server actively maintained?: Pg Mcp Server is less actively maintained — last commit was 319 days ago. It has 540 GitHub stars.

Similar servers

Others in data

View all →

Supabase MCP Server97

Manage Supabase projects — databases, auth, storage, and edge functions

2.8k 4

PostgreSQL MCP Server96

Query and manage PostgreSQL databases directly from AI assistants

88.9k 1

Dbhub96

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.2k 2

Firecrawl Mcp Server95

🔥 Official Firecrawl MCP Server - Adds powerful web scraping and search to Cursor, Claude and any other LLM clients.

7.0k 4

MCP Security Weekly

Get CVE alerts and security updates for Pg Mcp Server and similar servers.

Community

Discussion

Start a conversation

Ask a question, share a tip, or report an issue.

Has anyone used this with Cursor?How do you handle auth?Any alternatives?

Edit this pageView history

Data

Step 1

Install in your client

Config is the same across clients — only the file and path differ.

Supported in Claude Desktopsse · Node 18+

Paste into ~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "pg-mcp-server": {
      "command": "<see-readme>",
      "args": []
    }
  }
}

Are you the author?

Add this badge to your README to show your security score and help users find safe servers.

Embed in your READMEAbout badges →

[![MCPpedia Score](https://mcppedia.org/api/badge/pg-mcp-server)](https://mcppedia.org/s/pg-mcp-server)

Read me

What Pg Mcp Server does

A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents.

Test This Server

No automated test available for this server. Check the GitHub README for setup instructions.

README

PostgreSQL Model Context Protocol (PG-MCP) Server

A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents.

More info on the pg-mcp project here:

https://stuzero.github.io/pg-mcp/

Overview

PG-MCP is a server implementation of the Model Context Protocol for PostgreSQL databases. It provides a comprehensive API for AI agents to discover, connect to, query, and understand PostgreSQL databases through MCP's resource-oriented architecture.

This implementation builds upon and extends the reference Postgres MCP implementation with several key enhancements:

Full Server Implementation: Built as a complete server with SSE transport for production use
Multi-database Support: Connect to multiple PostgreSQL databases simultaneously
Rich Catalog Information: Extracts and exposes table/column descriptions from the database catalog
Extension Context: Provides detailed YAML-based knowledge about PostgreSQL extensions like PostGIS and pgvector
Query Explanation: Includes a dedicated tool for analyzing query execution plans
Robust Connection Management: Proper lifecycle for database connections with secure connection ID handling

Features

Connection Management

Connect Tool: Register PostgreSQL connection strings and get a secure connection ID
Disconnect Tool: Explicitly close database connections when done
Connection Pooling: Efficient connection management with pooling

Query Tools

pg_query: Execute read-only SQL queries using a connection ID
pg_explain: Analyze query execution plans in JSON format

Schema Discovery Resources

List schemas with descriptions
List tables with descriptions and row counts
Get column details with data types and descriptions
View table constraints and indexes
Explore database extensions

Data Access Resources

Sample table data (with pagination)
Get approximate row counts

Extension Context

Built-in contextual information for PostgreSQL extensions like:

PostGIS: Spatial data types, functions, and examples
pgvector: Vector similarity search functions and best practices

Additional extensions can be easily added via YAML config files.

Installation

Prerequisites

Python 3.13+
PostgreSQL database(s)

Using Docker

# Clone the repository
git clone https://github.com/stuzero/pg-mcp-server.git
cd pg-mcp-server

# Build and run with Docker Compose
docker-compose up -d

Manual Installation

# Clone the repository
git clone https://github.com/stuzero/pg-mcp-server.git
cd pg-mcp-server

# Install dependencies and create a virtual environment ( .venv )
uv sync

# Activate the virtual environment
source .venv/bin/activate  # On Windows: .venv\Scripts\activate

# Run the server
python -m server.app

Usage

Testing the Server

The repository includes test scripts to verify server functionality:

# Basic server functionality test
python test.py "postgresql://username:password@hostname:port/database"

# Claude-powered natural language to SQL conversion
python example-clients/claude_cli.py "Show me the top 5 customers by total sales"

The claude_cli.py script requires environment variables:

# .env file
DATABASE_URL=postgresql://username:password@hostname:port/database
ANTHROPIC_API_KEY=your-anthropic-api-key
PG_MCP_URL=http://localhost:8000/sse

For AI Agents

Example prompt for use with agents:

Use the PostgreSQL MCP server to analyze the database. 
Available tools:
- connect: Register a database connection string and get a connection ID
- disconnect: Close a database connection
- pg_query: Execute SQL queries using a connection ID
- pg_explain: Get query execution plans

You can explore schema resources via:
pgmcp://{con

... [View full README on GitHub](https://github.com/stuzero/pg-mcp-server#readme)

Loading README…

Scored, not listed

Why this score

Five weighted categories — click any category to see the underlying evidence.

Score breakdown

64/100across 5 weighted dimensions

How we score →

0255075100

−36

Security

Maintenance

Efficiency

Documentation

Compatibility

Categoriesclick a row to see evidence

Security

OSV.dev

No known CVEs.

No package registry to scan.

Inventory

Tools (4)

Click any tool to inspect its schema.

~347 tokens total

Inventory

Resources (8)

database_description

Comprehensive database description with schema and structure information

pgmcp://{conn_id}/

schemas

List schemas with descriptions

pgmcp://{conn_id}/schemas

schema_tables

List tables in a schema with descriptions and row counts

pgmcp://{conn_id}/schemas/{schema}/tables

table_columns

Get column details with data types and descriptions for a table

pgmcp://{conn_id}/schemas/{schema}/tables/{table}/columns

table_constraints

View table constraints and indexes

pgmcp://{conn_id}/schemas/{schema}/tables/{table}/constraints

table_sample

Sample table data with pagination

pgmcp://{conn_id}/schemas/{schema}/tables/{table}/sample

table_row_count

Get approximate row count for a table

pgmcp://{conn_id}/schemas/{schema}/tables/{table}/row_count

extensions

Explore database extensions with built-in context

pgmcp://{conn_id}/extensions

Community

Reviews

Be the first to review

Have you used this server?

Share your experience — it helps other developers decide.

How easy was setup?Did it work reliably?How was the documentation?

Frequently Asked Questions

Is Pg Mcp Server safe to use?: Pg Mcp Server has no known CVEs as of the latest MCPpedia security scan. It does not require authentication, so any local process can connect — keep this in mind in shared environments. Licensed under MIT.
How do I install Pg Mcp Server?: Pg Mcp Server can be installed by cloning its GitHub repository and following the setup instructions in the README.
What can Pg Mcp Server do?: Pg Mcp Server provides 4 tools: connect, disconnect, pg_query, pg_explain. See the full tools list on the server page for descriptions and parameters.
What AI clients work with Pg Mcp Server?: Pg Mcp Server is compatible with claude-desktop, cursor, claude-code. It uses sse transport.
Is Pg Mcp Server actively maintained?: Pg Mcp Server is less actively maintained — last commit was 319 days ago. It has 540 GitHub stars.