azure-postgresql-mcp

azure-postgresql-mcp

17

Azure Database for PostgreSQL MCP Server is a tool that connects AI models to Azure-hosted PostgreSQL databases using the MCP standard, enabling seamless and secure interaction with business data. It supports both password and Microsoft Entra authentication methods, and can be integrated with applications like Claude Desktop and Visual Studio Code.

Azure Database for PostgreSQL MCP Server (Preview)

  • A Model Context Protocol (MCP) Server for connecting AI models to Azure PostgreSQL databases.
  • Features include listing databases and tables, executing read queries, inserting records, and more with both password and Microsoft Entra authentication.
  • Tools can be integrated with AI agents, applications, or tools like Claude Desktop and Visual Studio Code.

Getting Started

  • Prerequisites: Python 3.10 or above, Azure Database for PostgreSQL instance, MCP Client.
  • Installation involves cloning the repository, creating a virtual environment, and installing dependencies.

Usage

  • Setup instructions are provided for Claude Desktop and Visual Studio Code.
  • Both environments support integration with natural language queries to interact with database data.

Contributing

  • Currently in Preview, contributions are welcome.

License

  • Licensed under the MIT License.