# PostgreSQL MCP Server (Microsoft)
> Microsoft-maintained local MCP server for connecting an AI client to PostgreSQL databases. It is a community integration, not a PostgreSQL core project or official PostgreSQL service.
Canonical: https://www.mcpfolio.com/servers/postgresql-microsoft
Last updated: 2026-10-28
## Catalog record

- Publisher: Microsoft (maintained; PostgreSQL community project not affiliated)
- Categories: database

## Website

https://github.com/microsoft/postgres-mcp

## Repository

https://github.com/microsoft/postgres-mcp

## Transports

stdio

## Authentication

PostgreSQL connection credentials are saved as named profiles. The documented CLI offers a hidden password prompt; use a least-privilege database account.

## Tools

- **postgres_mcp_connect**: Connect using a configured PostgreSQL connection profile.
- **postgres_mcp_query**: Run a query against the configured PostgreSQL database.
- **postgres_mcp_db_context**: Retrieve database/schema context.

## Sources

- [maintainer_setup_and_tool_documentation](https://github.com/microsoft/postgres-mcp/blob/main/README.md)
- [official_tool_documentation](https://github.com/microsoft/postgres-mcp)

## Setup

Use the interactive setup panel on [the detail page](https://www.mcpfolio.com/servers/postgresql-microsoft) to view instructions for each supported client.