Microsoft Postgres MCP

Query, design, diagnose and load PostgreSQL — with the password in your OS keyring.

Before you connect: what this server would do

A preview derived from this server’s definition — not a live run. Nothing runs and no key is sent until you connect. You run this server on your own machine — FindAgent never runs it.

Tools it can use (13)

postgres_mcp_list_connection_profiles
List saved connection profiles.
postgres_mcp_add_connection
Add a connection profile.
postgres_mcp_remove_connection
Remove a connection profile.
postgres_mcp_connect
Open a pooled connection by profile.
postgres_mcp_disconnect
Close a connection.
postgres_mcp_list_databases
List databases on the server.
postgres_mcp_db_context
CREATE scripts for tables, indexes, functions and sequences.
postgres_mcp_query
Run a read-only SQL query.
postgres_mcp_modify
Run DDL or DML — CREATE, ALTER, INSERT, UPDATE.
postgres_mcp_describe_csv
Describe a CSV file structure.
postgres_mcp_bulk_load_csv
Bulk-load a CSV into a table via COPY.
postgres_mcp_get_server_capabilities
Probe which diagnostic capabilities are available.
postgres_mcp_get_metrics_group
Collect a group of performance and diagnostic metrics.

What FindAgent checked

It passed an automated security scan and a human review before it was published here.
You run this server yourself, so FindAgent’s run-time protections — the prompt-injection deny-list on what you send, the secret-leak scan on every result, the credential-to-host binding, the approval gates — do not apply to what you send or receive here.

How FindAgent keeps servers safe

Run locally

This MCP server runs on your own machine — FindAgent only points you at it. Run the command below, then add it to your MCP client. Nothing is hosted or proxied on our side.

terminal

npx -y @microsoft/postgres-mcp run

Add it to your MCP client

Paste this into your client config (e.g. claude_desktop_config.json or a Cursor mcp.json), then restart the client.

mcp client config

{
  "mcpServers": {
    "microsoft-postgres-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "@microsoft/postgres-mcp",
        "run"
      ]
    }
  }
}

View the source repository