Zum Inhalt springen
Kitbay
Einreichen
MCP-ServerPreview

@microsoft/postgres-mcp

Läuft lokalProprietärAktualisiert am 5. Nov. 202681GitHub-SterneKann Daten ändernBraucht einen 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.

Was er kann

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.

Funktionen

  • 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