Skip to content
Kitbay
Submit
MCP serverPreview

@microsoft/postgres-mcp

Runs locallyProprietaryUpdated on Nov 5, 202681GitHub starsCan change dataNeeds an API key

Microsoft's MCP server that connects a coding agent to any PostgreSQL database, whether local, on-premises or hosted on Azure, AWS or Google Cloud.

What it does

Microsoft's MCP server that connects a coding agent to any PostgreSQL database, whether local, on-premises or hosted on Azure, AWS or Google Cloud. Connection profiles are saved once from the command line, with passwords kept in the operating system keyring rather than in client configuration, and Microsoft Entra ID is used for Azure databases. The agent can run read-only queries, run statements that change data or schema, fetch create scripts for tables and other objects, load a CSV file with COPY, and collect performance metrics. Profiles allow writes unless set to read-only. It runs locally over stdio through npx, needs Node.js 22 and is marked as a preview.

Capabilities

  • Save PostgreSQL connection profiles with keyring passwords
  • Run read-only SQL queries
  • Run DDL and DML statements when the profile allows writes
  • Fetch create scripts for tables, indexes and functions
  • Bulk-load a CSV file with COPY
  • Collect server performance metrics