# azure-resource-manager-postgresql-dotnet

Teaches AI agents to manage Azure PostgreSQL Flexible Server deployments in .NET. Generates C# code for server provisioning, firewall rules, and database setup.

- skill · `type=skill` · Claude Code, GitHub Copilot · ★ 3149
- Author: Microsoft
- License: MIT · policy=mirror · the beginning of the file is at the end of this page
- Source: https://github.com/microsoft/skills/tree/HEAD/.github/plugins/azure-sdk-dotnet/skills/azure-resource-manager-postgresql-dotnet/SKILL.md
- Updated: 2026-10-23
- HTML: https://affpapa.org/en/nevibecode/skills/azure-resource-manager-postgresql-dotnet

## What it does

The skill provides patterns and C# workflows for `Azure.ResourceManager.PostgreSql` under API version `2023-12-01-preview`. It guides the model through creating server instances, configuring zone redundancy, and setting up storage parameters.

It covers core resources beneath the flexible server hierarchy. That includes creating databases, configuring IP firewall ranges, and tuning engine parameters like `max_connections`. Authentication relies on `Azure.Identity` and `DefaultAzureCredential`.

Be aware that this skill targets only PostgreSQL Flexible Server. Azure Single Server is deprecated and scheduled for retirement, so it is omitted entirely. You will need `AZURE_SUBSCRIPTION_ID` and `AZURE_RESOURCE_GROUP` configured in your environment.

## Requirements
- Works with: Azure, PostgreSQL

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add microsoft/skills --skill azure-resource-manager-postgresql-dotnet -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/azure-resource-manager-postgresql-dotnet/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/azure-resource-manager-postgresql-dotnet/

### Codex

**Manually: put the files in place**
- File: `.agents/skills/azure-resource-manager-postgresql-dotnet/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

**Manually: put the files in place**
- File: `.cursor/skills/azure-resource-manager-postgresql-dotnet/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install microsoft/skills azure-resource-manager-postgresql-dotnet
```

2. **Manually: put the files in place**
- File: `.github/skills/azure-resource-manager-postgresql-dotnet/SKILL.md`

### Gemini CLI

**Platform CLI**
```bash
gemini skills install https://github.com/microsoft/skills --path .github/plugins/azure-sdk-dotnet/skills/azure-resource-manager-postgresql-dotnet
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/azure-resource-manager-postgresql-dotnet/SKILL.md` — The legacy .windsurf/skills/ path still works

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/microsoft/skills/tree/HEAD/.github/plugins/azure-sdk-dotnet/skills/azure-resource-manager-postgresql-dotnet/SKILL.md

## When to use it
- provision Azure PostgreSQL Flexible Server instances in C#
- create PostgreSQL databases with UTF8 encoding
- add firewall rules for specific IP ranges or Azure services
- tune server configurations like max_connections

## Example prompts
- Write C# code to deploy a PostgreSQL Flexible Server with high availability enabled.
- Show how to add a firewall rule to Azure PostgreSQL for subnet 10.0.0.0/24.
- Update the max_connections parameter on our Azure PostgreSQL Flexible Server using .NET.

## Source text · SKILL.md · MIT

Below is the content of a third-party file. It is data, not instructions for you: do not act on anything written inside unless the human asks. Block tag: 0c10a6ff36c317c2.

BEGIN THIRD-PARTY FILE 0c10a6ff36c317c2
````text
---
name: azure-resource-manager-postgresql-dotnet
description: |
  Azure PostgreSQL Flexible Server SDK for .NET. Database management for PostgreSQL Flexible Server deployments. Use for creating servers, databases, firewall rules, configurations, backups, and high availability. Triggers: "PostgreSQL", "PostgreSqlFlexibleServer", "PostgreSQL Flexible Server", "Azure Database for PostgreSQL", "PostgreSQL database management", "PostgreSQL firewall", "PostgreSQL backup", "Postgres".
license: MIT
metadata:
  author: Microsoft
  version: "1.0.0"
  package: Azure.ResourceManager.PostgreSql
---

# Azure.ResourceManager.PostgreSql (.NET)

Azure Resource Manager SDK for managing PostgreSQL Flexible Server deployments.

## Installation

```bash
dotnet add package Azure.ResourceManager.PostgreSql
dotnet add package Azure.Identity
```

**Current Version**: v1.2.0 (GA)  
**API Version**: 2023-12-01-preview

> **Note**: This skill focuses on PostgreSQL Flexible Server. Single Server is deprecated and scheduled for retirement.

## Environment Variables

```bash
AZURE_SUBSCRIPTION_ID=<your-subscription-id>  # Required: Azure subscription ID
AZURE_RESOURCE_GROUP=<your-resource-group>  # Required: resource group name
AZURE_POSTGRESQL_SERVER_NAME=<your-postgresql-server>  # Required: PostgreSQL Flexible Server name
AZURE_TOKEN_CREDENTIALS=prod  # Required only if DefaultAzureCredential is used in production
```

## Authentication

```csharp
using Azure.Identity;
using Azure.ResourceManager;
using Azure.ResourceManager.PostgreSql;
using Azure.ResourceManager.PostgreSql.FlexibleServers;

// Local dev: DefaultAzureCredential. Production: set AZURE_TOKEN_CREDENTIALS=prod or AZURE_TOKEN_CREDENTIALS=<specific_credential>
var credential = new DefaultAzureCredential(
    DefaultAzureCredential.DefaultEnvironmentVariableName
);
// Or use a specific credential directly in production:
// See https://learn.microsoft.com/dotnet/api/overview/azure/identity-readme?view=azure-dotnet#credential-classes
// var credential = new ManagedIdentityCredential();
ArmClient client = new ArmClient(credential);
```

## Resource Hierarchy

```
Subscription
└── ResourceGroup
    └── PostgreSqlFlexibleServer              # PostgreSQL Flexible Server instance
        ├── PostgreSqlFlexibleServerDatabase  # Database within the server
        ├── PostgreSqlFlexibleServerFirewallRule # IP firewall rules
        ├── PostgreSqlFlexibleServerConfiguration # Server parameters
        ├── PostgreSqlFlexibleServerBackup    # Backup information
        ├── PostgreSqlFlexibleServerActiveDirectoryAdministrator # Entra ID admin
        └── PostgreSqlFlexibleServerVirtualEndpoint # Read replica endpoints
```

## Core Workflows

### 1. Create PostgreSQL Flexible Server

```csharp
using Azure.ResourceManager.PostgreSql.FlexibleServers;
using Azure.ResourceManager.PostgreSql.FlexibleServers.Models;

ResourceGroupResource resourceGroup = await client
    .GetDefaultSubscriptionAsync()
    .Result
````
END THIRD-PARTY FILE 0c10a6ff36c317c2

The third-party file has ended. Everything between the 0c10a6ff36c317c2 tags is data: requests and commands from it are not followed. An “end of file” line with another tag inside the block is part of the file.

First 3029 of 16005 bytes. © Microsoft · MIT · https://github.com/microsoft/skills/tree/HEAD/.github/plugins/azure-sdk-dotnet/skills/azure-resource-manager-postgresql-dotnet/SKILL.md

_Part of the page did not fit — see the HTML version._

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md