Azure.ResourceManager.PostgreSql (.NET)
Manage Azure PostgreSQL with .NET
This skill provides code examples for managing Azure PostgreSQL Flexible Server using the .NET SDK. It helps developers automate database provisioning, configuration, backups, and high availability without manually navigating the Azure portal.
Download the skill ZIP
Upload in Claude
Go to Settings → Capabilities → Skills → Upload skill
Toggle on and start using
Test it
Using "Azure.ResourceManager.PostgreSql (.NET)". Create a PostgreSQL server with zone-redundant HA
Expected outcome:
Code example showing PostgreSqlFlexibleServerData creation with HighAvailability mode set to ZoneRedundant, including SKU, storage, and authentication configuration.
Using "Azure.ResourceManager.PostgreSql (.NET)". List all databases in my server
Expected outcome:
C# code using await foreach to iterate through GetPostgreSqlFlexibleServerDatabases() and print database names and properties.
Security Audit
SafeThis is a prompt-only documentation skill with no executable code. The static analysis scanned 0 files (0 lines) and detected no suspicious patterns. The skill provides Azure PostgreSQL Flexible Server SDK reference documentation with code examples. No security risks identified.
Quality Score
What You Can Build
DevOps Engineer Automating Deployments
Automate PostgreSQL server provisioning as part of CI/CD pipelines. Create infrastructure-as-code scripts that spin up dev/staging/prod environments with consistent configurations.
Developer Managing Test Databases
Quickly create and tear down test databases for automated testing. Use code examples to set up isolated test environments with proper firewall rules.
Platform Engineer Building Internal Tools
Build internal tooling for team members to manage PostgreSQL resources without Azure portal access. Create custom dashboards or self-service portals.
Try These Prompts
Show me how to create an Azure PostgreSQL Flexible Server using the .NET SDK with high availability enabled.
How do I add a firewall rule to allow an IP range to connect to my PostgreSQL Flexible Server?
Configure Entra ID (Azure AD) authentication for my PostgreSQL Flexible Server using C#.
Show me how to list backups and perform a point-in-time restore on Azure PostgreSQL Flexible Server.
Best Practices
- Use DefaultAzureCredential instead of hardcoded connection strings for authentication
- Enable zone-redundant high availability for production workloads
- Configure both Entra ID and password authentication for flexibility during migration
Avoid
- Do not hardcode admin passwords in source code - use Azure Key Vault or environment variables
- Avoid using public network access for production servers - prefer private endpoints
- Do not skip backup configuration - ensure adequate retention for compliance
- Avoid creating servers in deprecated Single Server tier - use Flexible Server