Microsoft Postgres MCP

Tools provided

Tools the agent exposes — your AI client calls them automatically when it needs them.

• postgres_mcp_list_connection_profiles — List saved connection profiles.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_add_connection — Add a connection profile.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_remove_connection — Remove a connection profile.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_connect — Open a pooled connection by profile.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_disconnect — Close a connection.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_list_databases — List databases on the server.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_db_context — CREATE scripts for tables, indexes, functions and sequences.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_query — Run a read-only SQL query.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_modify — Run DDL or DML — CREATE, ALTER, INSERT, UPDATE.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_describe_csv — Describe a CSV file structure.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_bulk_load_csv — Bulk-load a CSV into a table via COPY.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_get_server_capabilities — Probe which diagnostic capabilities are available.

  runs when your client calls it …ran · ✓ done
• postgres_mcp_get_metrics_group — Collect a group of performance and diagnostic metrics.

  runs when your client calls it …ran · ✓ done