Pular para o conteúdo
Kitbay
Enviar
Servidor MCPPreview

@microsoft/postgres-mcp

Roda localmenteProprietáriaAtualizado em 5 de nov. de 202681Estrelas no GitHubPode alterar dadosExige chave de API

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.

Resumo

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.

O que faz

  • 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