P
Install Command
npx -y @modelcontextprotocol/server-postgresClaude Desktop Config
{"command": "npx", "args": ["-y", "@modelcontextprotocol/server-postgres"], "env": {"DATABASE_URL": "postgresql://..."}}PostgreSQL is an officially maintained MCP server in the Databases category, developed by Anthropic. It runs locally on your machine, keeping your data private and giving you full control over the connection. This makes it easy to query and manage your data without leaving your AI assistant.
About PostgreSQL
Connects your AI to PostgreSQL databases for data analysis, schema exploration, and querying.
Who Should Use PostgreSQL?
- 1Run natural-language queries against your database without writing SQL
- 2Inspect schemas, tables, and relationships during development
- 3Automate data exports, migrations, and reporting tasks
- 4Let AI assistants answer questions directly from your live data
How to Install PostgreSQL
Before you start
You will need Node.js (v18 or later) installed on your machine — download it from nodejs.org if you haven't already.
- 1Open a terminal (Terminal on Mac, Command Prompt or PowerShell on Windows).
- 2Paste the install command above and press Enter — Node.js will download and run the server automatically.
- 3Add the server to your Claude Desktop config file (see the JSON snippet above) and restart Claude.
The Claude Desktop config snippet above can be copied and pasted directly into your claude_desktop_config.json file — no editing required.
How PostgreSQL Compares
✦It is an officially maintained server — unlike community alternatives, it is built and supported by the original project team, ensuring compatibility with upstream changes.
✦It runs entirely on your local machine, so no data leaves your environment — important for teams with privacy or compliance requirements.
✦It is distributed as an npm package, making version management and updates straightforward with a single `npm update` command.
Tags
sqldatabasepostgresdata