postgres_mcp

<!-- mcp-name: io.github.JaviMaligno/postgresql -->

[](https://github.com/JaviMaligno/postgres_mcp/actions/workflows/ci.yml) [](https://pypi.org/project/postgresql-mcp/) [](https://www.npmjs.com/package/postgresql-mcp) [](https://opensource.org/licenses/MIT)

MCP server for PostgreSQL database operations. Works with Claude Code, Claude Desktop, Cursor, and any MCP-compatible client.

This repository contains both TypeScript and Python implementations:

| Version | Directory | Status | Installation | |---------|-----------|--------|--------------| | TypeScript | /typescript | ✅ Recommended (Smithery) | npm install -g postgresql-mcp | | Python | /python | ✅ Stable | pipx install postgresql-mcp |

> Note: The TypeScript version is used for Smithery deployments. Both versions provide identical functionality.

• Query Execution: Execute SQL queries with read-only protection by default
• Schema Exploration: List schemas, tables, views, and functions
• Table Analysis: Describe structure, indexes, constraints, and statistics
• Performance Tools: EXPLAIN queries and analyze table health
• Security First: SQL injection prevention, credential protection, read-only by default
• MCP Prompts: Guided workflows for exploration, query building, and documentation
• MCP Resources: Browsable database structure as markdown

# Install globally
npm install -g postgresql-mcp

# Or run directly with npx
npx postgresql-mcp

# Install
pipx install postgresql-mcp

# Configure Claude Code
claude mcp add postgres -s user \
  -e