本文へスキップ
Kitbay
掲載依頼
MCPサーバーPreview

@microsoft/postgres-mcp

ローカルで動作プロプライエタリ2026年11月5日 更新81GitHubスターデータ変更可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.

インストールリポジトリ 2026年11月12日 確認

このサーバーについて

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.

できること

  • 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

PostgreSQL向けのほかのMCPサーバーとスキル