How do I handle expired connection tokens?

The skill includes troubleshooting guides and commands to refresh access tokens using 'az account get-access-token', ensuring continuous secure connectivity.

What is the benefit of using Entra ID with Azure PostgreSQL?

Using Entra ID eliminates the need for static passwords, significantly reducing the risk of credential leakage by utilizing identity-based access tokens and managed identities.

Can I migrate existing password-based servers to passwordless?

Yes, this skill provides specific implementation patterns and CLI commands to transition existing PostgreSQL Flexible Servers from password-based to Entra ID authentication.

Does this skill support PostgreSQL Flexible Server?

Yes, it is specifically optimized for Azure Database for PostgreSQL Flexible Server, including support for versions 11 through 16.

Azure PostgreSQL Manager

Name: Azure PostgreSQL Manager
Author: microsoft

bymicrosoft

•

1,777

•

Database Management

Configure and manage Azure Database for PostgreSQL with a focus on passwordless Entra ID authentication and secure access control.

This skill streamlines the management of Azure Database for PostgreSQL Flexible Servers, emphasizing high-security standards through Microsoft Entra ID integration. It enables developers to automate the creation of PostgreSQL instances, migrate from traditional password-based authentication to passwordless managed identities, and configure fine-grained, group-based permissions. Whether setting up developer access or securing application-to-database connections, this skill provides the necessary MCP tools and CLI commands to maintain a secure, compliant, and scalable relational database infrastructure on Azure.

Key Features

01Group-based access control and PostgreSQL role management

02Automated Microsoft Entra ID (Azure AD) authentication setup

031,777 GitHub stars

04Database discovery and SQL query execution via MCP tools

05Managed identity configuration for Azure-hosted applications

06Migration workflows from password-based to passwordless authentication

Use Cases

01Migrating legacy PostgreSQL instances to modern Azure security standards

02Onboarding development teams with identity-based database access

03Securing production PostgreSQL workloads by removing static credentials

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microsoft/skills azure-postgres

For use in Claude.ai and ChatGPT

Download Skill