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. It has been installed 0 times through Conduid.
The repository has 1 stars and 0 forks, with the last commit a year ago. Six months or more without a commit doesn't mean the server is broken, but check the open issues (0) before depending on it in production.
Install
npx 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
- ·README presentNot checked yet.
- ·License declaredNot checked yet.
- ·Tests presentNot checked yet.
- ·Dependencies pinnedNot checked yet.
- ·No dynamic code executionNot checked yet.
- !Scoped permissionsDoesn't declare a permission scope. Assume it can do anything its process can.
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 mirrored from the source repository 3 months ago. The original is authoritative.