HenkDz/postgresql-mcp-server

A Model Context Protocol (MCP) server that provides comprehensive PostgreSQL database management capabilities for AI assistants.
🚀 What's New: This server has been completely redesigned from 46 individual tools to 18 intelligent tools through consolidation (34→8 meta-tools) and enhancement (+4 new tools), providing better AI discovery while adding powerful data manipulation and comment management capabilities.
## Breaking Changes in 2.0.0
Version 2.0.0 introduces security boundaries that intentionally change default behavior from the 1.x line:
The server starts in readonly mode. Mutations, DDL, role administration, filesystem import/export, and arbitrary SQL require --security-mode write, --security-mode admin, or --security-mode unsafe as appropriate.
Destructive operations such as drops, resets, broad role grants, and arbitrary SQL require --allow-destructive.
Per-tool connectionString, sourceConnectionString, and targetConnectionString arguments are disabled by default. Use server-level --connection-string or POSTGRESCONNECTIONSTRING, or explicitly opt in with --allow-tool-connection-string.
Legacy string where clauses are rejected for mutation, index, export, and copy filters. Use structured where predicates, or rawWhere only with --security-mode unsafe --allow-destructive.
Multi-statement pgexecutesql calls must use transactional: true, expectRows: false, and no bind parameters.
Tool schemas reject unknown fields, so misspelled or unintended inputs fail before connection resolution.
User and target identifiers are restricted to safe simple PostgreSQL identifiers.
For the non-breaking security patch line, use @henkey/postgres-mcp-server@1.0.7.
## Quick Start
## Prerequisites
Node.js ≥18.0.0
Access to a PostgreSQL server
(Optional) An MCP client like Cursor or Claude for AI integration
### Option 1: npm (Recommended)
bash
# Install globally
npm install -g @henkey/postgres-mcp-server
# Or run directly with npx (no installation)
# Use env var for connection string (optional)
export POSTGRESCONNECTIONSTRING="postgresql://user:pass@localhost:5432/db"
npx @henkey/postgres-mcp-server
# Or pass directly:
npx @henkey/postgres-mcp-server --connection-string "postgresql://user:pass@localhost:5432/db"
# Verify installation
npx @henkey/postgres-mcp-server --help
Add to your MCP client configuration:
json
"mcpServers": {
"postgresql-mcp": {
"command": "npx",
"args": [
"@henkey/postgres-mcp-server",
"--connection-string", "postgresql://user:password@host:port/database"
### Option 2: Install via Smithery
bash
npx -y @smithery/cli install @HenkDz/postgresql-mcp-server --client claude
### Option 3: Docker (Recommended for Production)
bash
# Build the Docker image
docker build -t postgres-mcp-server .
# Run with environment variable
docker run -i --rm \
-e POSTGRESCONNECTIONSTRING="postgresql://user:password@host:port/database" \
postgres-mcp-server
Add to your MCP client configuration:
json
"mcpServers": {
"postgresql-mcp": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"henkey/postgres-mcp:latest",
"-e",
"POSTGRESCONNECTIONSTRING"
],
"env": {
"POSTGRESCONNECTIONSTRING": "postgresql://user:password@host:port/database"
### Option 4: Manual Installation (Development)