Can I run SQL queries directly through this skill?

Yes, when the Azure MCP is enabled, the skill can execute SQL queries, list databases, and manage server parameters using integrated PostgreSQL tools.

Does it support managed identities for applications?

Yes, it includes specific patterns for configuring passwordless access for Azure-hosted applications like Azure App Service, Azure Functions, and Azure Container Apps.

How does this skill help with database security?

It automates the setup of passwordless authentication using Microsoft Entra ID, eliminating the risk of leaked or hardcoded database credentials in your source code or configuration files.

What versions of PostgreSQL are supported?

The skill supports Azure Database for PostgreSQL Flexible Server versions 11 through 16, with version 16 being the recommended choice for new deployments.

Can I use this with existing PostgreSQL servers?

Yes, the skill is specifically designed to manage, configure, and migrate existing Azure Database for PostgreSQL Flexible Server instances to more secure authentication methods.

Azure Database for PostgreSQL Manager

Name: Azure Database for PostgreSQL Manager
Author: microsoft

bymicrosoft

•

109

•

データベース管理

Configures and manages Azure Database for PostgreSQL Flexible Servers with a focus on Microsoft Entra ID passwordless authentication and secure access control.

This skill provides specialized capabilities for managing Azure Database for PostgreSQL Flexible Server instances, prioritizing secure, modern authentication workflows. It simplifies the transition from legacy password-based logins to Microsoft Entra ID (formerly Azure AD) for both developers and Azure-hosted applications. By automating the setup of managed identities, group-based permissions, and database role mapping, the skill ensures that PostgreSQL deployments follow Microsoft's best practices for security and operational efficiency while providing tools for direct database querying and server configuration.

主な機能

01Migrates existing PostgreSQL instances from password-based to identity-based access.

02Sets up group-based access control and developer-specific database roles.

03Implements Microsoft Entra ID (Azure AD) passwordless authentication for enhanced security.

04Executes SQL queries and manages server parameters via integrated MCP tools.

05Configures managed identities for Azure-hosted apps like Container Apps and Functions.

06109 GitHub stars

ユースケース

01Provisioning and configuring new PostgreSQL Flexible Server instances with optimized service tiers.

02Securing production PostgreSQL databases by removing reliance on static passwords.

03Granting database access to developers using their corporate Azure identities instead of shared credentials.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microsoft/github-copilot-for-azure azure-postgres

For use in Claude.ai and ChatGPT

Download Skill