PostgreSQL MCP Server

stdio / HTTP

PostgreSQL MCP Server lets agents inspect schemas and run approved SQL queries against PostgreSQL databases.

MCP 服务收藏 522026-06-04MIT

作者modelcontextprotocol

MCP 服务已关联来源ModelScope MCPdatabasepostgreslocalMCP Server. Review tool permissions and credentials before enabling.

PostgreSQL MCP Server

PostgreSQL MCP Server connects MCP clients to PostgreSQL for schema inspection and query workflows.

Key Features

Inspect schemas, tables, columns, and indexes.
Run read-oriented SQL during analysis and debugging.
Pair database context with coding agents.

Server Configuration

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": ["@modelcontextprotocol/server-postgres", "postgres://user:pass@localhost:5432/db"]
    }
  }
}

Security Notes

Use least-privilege database credentials and avoid production write permissions unless explicitly required.