About Postgres MCP Server
Postgres MCP Server is an MCP server published by mgorunuch in the Data category: a Model Control Protocol (MCP) server that allows Claude to interact with PostgreSQL databases using natural language queries.
The repository has 1 stars and 0 forks, with the last commit 2 months ago. Recent commit activity is the strongest signal that reported issues will get attention.
Install
git clone https://github.com/mgorunuch/postgres-mcp-serverThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Ask AI
Ask AI about Postgres MCP Server
Powered by Claude · Grounded in docs
Security checks
Static checks derived from the repository 21 hours ago. Heuristics on the source, not an audit.
- ✓README presentThe repository ships documentation.
- ✓License declaredUsable under a stated license.
- !Tests presentNo tests found. Behaviour changes may go unnoticed between versions.
- ✓Dependencies pinnedA lockfile pins dependency versions.
- ✓No dynamic code executionSource scan found no eval, dynamic Function, or shell execution.
- !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.
Releases
README
PostgreSQL MCP Server
A Model Control Protocol (MCP) server for PostgreSQL databases that allows Claude to interact with your PostgreSQL databases.
Using with Claude Code
The easiest way to use this server with Claude Code:
# Generate MCP config and add it to Claude
JSON=$(postgres-mcp-server --json --connection-string '...') \
&& claude mcp add-json "$JSON"
Installation
Using Homebrew
# Add the tap
brew tap mgorunuch/postgres-mcp-server https://github.com/mgorunuch/postgres-mcp-server
# Install the server
brew install mgorunuch/postgres-mcp-server/postgres-mcp-server
Manual Installation
Download the appropriate binary for your platform from the releases page.
Setup
There are two ways to use this server:
1. Running Directly
-
Set your PostgreSQL connection string as an environment variable (optional):
export POSTGRES_CONNECTION_STRING="postgresql://user:password@host:port/dbname?sslmode=disable"If not provided, defaults to
postgresql://postgres:postgres@localhost:5432/postgres?sslmode=disable -
Launch the server:
postgres-mcp-server -
Use with Claude by setting up the MCP connection to this server.
2. Using with Claude's MCP Configuration
-
Generate the MCP configuration JSON:
postgres-mcp-server --json --connection-string "postgresql://user:password@host:port/dbname?sslmode=disable"This will output a JSON configuration you can use with Claude's MCP tools.
Example output:
{"type":"stdio","command":"/path/to/postgres-mcp-server","args":["--connection-string","postgresql://user:password@host:port/dbname?sslmode=disable"],"env":{}} -
Copy this JSON output and use it to configure the MCP connection in Claude.
Command Line Options
--version: Displays version information--json: Outputs MCP configuration JSON for use with Claude--connection-string: PostgreSQL connection string (overrides environment variable)
Security
For safety, potentially destructive queries (DROP, TRUNCATE, DELETE, UPDATE, ALTER, CREATE, INSERT) are blocked by default.
To execute these queries, you must explicitly set unsafe: true when using the pg_query tool.
README fetched from the repository 21 hours ago. The original is authoritative.