Is it safe to connect my production database?

It is best practice to connect a local development or read-only staging database replica.

PostgreSQL MCP Server Config Template

Target Standard & File Format

Select runtime specification

AI Agent Rules & Skills

Context Shields & Privacy (Ignore Files)

Integrations & Machine Documentation

AI Governance & Multi-Agent Planning Suite

MCP Server

Valid

Server key

Command

Arguments one per line

Env variable optional

Value

Draft data rules from your schema

Paste SQL DDL or a Prisma schema.

Valid for Claude Code (.mcp.json) and Claude Desktop (claude_desktop_config.json).

claude_desktop_config.json13 lines

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://${DB_USER}:${DB_PASSWORD}@localhost:5432/${DB_NAME}"
      ]
    }
  }
}

Click or focus to edit

JSON•UTF-8•13 Lines•Spaces: 2

Target File Location

Project Placement

Save as .mcp.json in project root for Claude Code, or merge its mcpServers block into Claude Desktop claude_desktop_config.json.

What's in the ZIP export (20 files)

Unzip into your project root. Every file is already in the folder its tool reads from.

Include extras: Claude Code subagent, Gemini CLI, Aider, Copilot and Kiro scoped rules, CI audit workflow

.claude/settings.json
.claude/skills/codebase-auditor/SKILL.md
.claude/skills/codebase-auditor/scripts/verify.sh
.claudeignore
.cursor/rules/codebase-auditor.mdc
.cursorignore
.github/copilot-instructions.md
.mcp.json (open in editor)
.windsurf/rules/codebase-auditor.md
AGENTS.md
ARCHITECTURE.md
CLAUDE.md
DESIGN.md
MEMORY.md
PRD.md
README.md
TASK.md
llms.txt
prompts/gemini-system-instructions.json
prompts/openai-custom-instructions.md

What this file changes for PostgreSQL Database MCP

Without it

Enables your AI assistant to read database schemas, explain query execution plans, and write accurate SQL queries directly against your Postgres database.

What the file tells the agent

Uses `@modelcontextprotocol/server-postgres`.

Pass connection string securely via command arguments or environment variables.

Recommended to use a read-only database user for development inspection.

How to Install PostgreSQL Database MCP Model Context Protocol (MCP) via Terminal

Step 1: Open Project Directory & Verify Target Placement

Open your terminal and navigate to your project root folder where the claude_desktop_config.json file will reside. Ensure the file is placed at the exact path below relative to your project root so the AI engine automatically loads it:

claude_desktop_config.json

Step 2: Fetch Rule File via Terminal Command

Run curl, PowerShell, or wget to stream the rule directly from the DevScratchpad raw API endpoint and write it to claude_desktop_config.json:

Terminal One-Liner Install

Run directly in your project root to stream and write this rule file with one command.

Raw API Stream

$curl -fsSL "https://www.devscratchpad.tech/api/raw/mcp-config/postgres" -o "claude_desktop_config.json"

Step 3: Check that Claude Code, Claude Desktop, Cursor uses it

Restart the client so it starts the server. Claude Code asks you to approve servers from .mcp.json; run /mcp to check their status.

Target Standard & File Format

MCP Server

Target File Location

PostgreSQL MCP Server Config Generator

What this file changes for PostgreSQL Database MCP

How to Install PostgreSQL Database MCP Model Context Protocol (MCP) via Terminal

Step 1: Open Project Directory & Verify Target Placement

Step 2: Fetch Rule File via Terminal Command

Terminal One-Liner Install

Step 3: Check that Claude Code, Claude Desktop, Cursor uses it

MCP config generator: .mcp.json for Claude Code, Claude Desktop and Cursor

Tools for PostgreSQL Database MCP work

SQL Formatter

UUID / ULID / NanoID Generator

JSON Formatter & Validator

Hash Generator (MD5, SHA256, SHA512)

Live Repository & Schema Ingestion

Migrating from Legacy .cursorrules or CLAUDE.md?

Technical FAQ: PostgreSQL Database MCP AI Rulebooks

Is it safe to connect my production database?