Skills azure-resource-manager-postgresql-dotnet
๐Ÿ“ฆ

azure-resource-manager-postgresql-dotnet

Content revision r2 Medium Risk โš™๏ธ External commands๐ŸŒ Network access๐Ÿ“ Filesystem access

Manage Azure PostgreSQL with .NET

Managing PostgreSQL Flexible Server through the Azure .NET SDK requires many resource-specific APIs. This skill provides focused patterns for common provisioning and operations tasks.

Supports: Claude Codex Code(CC)
๐Ÿ“Š 69 Adequate

Install with my Agent

Copy this request to your Agent. It includes the canonical Skill page and manifest.

Agent request
Review the Skillstore skill "azure-resource-manager-postgresql-dotnet" from https://skillstore.io/skills/sickn33-azure-resource-manager-postgresql-dotnet.md and its manifest at https://skillstore.io/api/skills/sickn33-azure-resource-manager-postgresql-dotnet/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

Your Agent should still show its plan and request any confirmation required by the security policy.

Test it

Using "azure-resource-manager-postgresql-dotnet". Create a secure development server plan for West Europe with PostgreSQL 16 and seven-day backups.

Expected outcome:

  • Authentication: use DefaultAzureCredential and confirm the target subscription before changes.
  • Server: use PostgreSQL 16, a development SKU, encrypted storage, and seven-day backup retention.
  • Network: prefer private access or one approved client range. Do not enable the broad Azure-services rule.
  • Credentials: load the administrator password from a secret provider and require certificate validation.

Using "azure-resource-manager-postgresql-dotnet". Explain how to restore a server from two hours ago.

Expected outcome:

Create a new server in point-in-time restore mode, reference the source resource ID, and set the UTC restore time. Validate backup availability first.

Using "azure-resource-manager-postgresql-dotnet". Review a planned production scaling operation.

Expected outcome:

  • Confirm the target SKU and storage tier are available in the selected region.
  • Estimate cost and expected service impact before applying the update.
  • Capture current settings, monitor the long-running operation, and define rollback criteria.

Security Audit

Medium Risk
v5 โ€ข 7/23/2026 Open versioned report

Most static alerts are false positives caused by Markdown fences, inline code, official documentation URLs, and example private addresses. The 0.0.0.0 firewall example is a confirmed medium risk because it enables broad Azure-services access. A separate medium finding covers a hardcoded password example and disabled certificate validation.

1
Files scanned
443
Lines analyzed
2
Review items
0
False positives ignored

Confirmed security concerns (1)

Medium
Insecure Password Connection Example
The connection example embeds a password and enables Trust Server Certificate. Copying it can expose credentials and bypass TLS certificate validation.
The example directly contains a password literal and Trust Server Certificate=true. Both insecure settings are visible in the documented connection string.
Capability review items (2)

These are real local capabilities that may be expected for this skill, so they require review but are not counted as confirmed malicious behavior.

Medium
Hardcoded IP address
StartIPAddress = System.Net.IPAddress.Parse("0.0.0.0"),
In Azure PostgreSQL, the special 0.0.0.0 rule enables connections from Azure services. Copying this example creates broader access than a private or client-specific rule.
Medium
Hardcoded IP address
EndIPAddress = System.Net.IPAddress.Parse("0.0.0.0")
This line completes the special 0.0.0.0 firewall range that permits Azure-services access. The broad rule increases exposure if copied without additional controls.
Audited by: codex View Audit History โ†’
Share & cite this report

Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/sickn33-azure-resource-manager-postgresql-dotnet/audits/5?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/sickn33-azure-resource-manager-postgresql-dotnet/security.svg)](https://skillstore.io/skills/sickn33-azure-resource-manager-postgresql-dotnet?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/sickn33-azure-resource-manager-postgresql-dotnet?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/sickn33-azure-resource-manager-postgresql-dotnet/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/sickn33-azure-resource-manager-postgresql-dotnet.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>
Academic citations (APA ยท BibTeX ยท CFF)

APA citation

sickn33. (2026). azure-resource-manager-postgresql-dotnet security audit report (audit version 5) [Author version unspecified]. Skillstore. https://skillstore.io/skills/sickn33-azure-resource-manager-postgresql-dotnet/audits/5

BibTeX citation

@techreport{sickn33-sickn33-azure-resource-manager-postgresql-dotnet-2026, author = {sickn33}, title = {azure-resource-manager-postgresql-dotnet security audit report (audit version 5)}, institution = {Skillstore}, year = {2026}, number = {5}, url = {https://skillstore.io/skills/sickn33-azure-resource-manager-postgresql-dotnet/audits/5}, note = {Author version unspecified} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "azure-resource-manager-postgresql-dotnet security audit report (audit version 5)" version: "unspecified" type: report authors: - name: "sickn33" date-released: "2026-07-23" url: "https://skillstore.io/skills/sickn33-azure-resource-manager-postgresql-dotnet/audits/5" identifiers: - type: other value: "skillstore:sickn33-azure-resource-manager-postgresql-dotnet:audit:5" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: High
55
Architecture
85
Maintainability
87
Content
68
Community
83
Spec Compliance

What You Can Build

Provision a Development Database

Generate a reviewed C# workflow for a Flexible Server, database, storage, backups, and authentication.

Standardize Production Configuration

Draft infrastructure code for high availability, Entra ID, firewall boundaries, and server parameters.

Plan Database Operations

Compare SDK patterns for scaling, replicas, backups, point-in-time restore, and controlled lifecycle actions.

Try These Prompts

Authenticate to Azure
Show the minimum C# setup for ArmClient with DefaultAzureCredential. Use subscription ID [subscription-id] and explain required local authentication.
Create a Flexible Server
Draft C# to create PostgreSQL 16 server [server-name] in [region]. Use secret-backed credentials, [sku], [storage-gb], backups, and no broad firewall rule.
Configure Secure Production Access
Create a production configuration for server [server-name]. Include Entra ID, private networking guidance, zone-redundant availability, backup retention, and least-privilege firewall settings.
Design a Restore and Replica Workflow
Design an idempotent C# workflow for point-in-time restore and a cross-region read replica. Include validation, failure handling, cost impacts, and rollback steps.

Best Practices

  • Use DefaultAzureCredential and store passwords in Azure Key Vault or another approved secret provider.
  • Prefer private networking and narrowly scoped firewall ranges for production servers.
  • Validate subscription, resource group, region, costs, and destructive actions before applying changes.

Avoid

  • Do not hardcode administrator passwords or access tokens in source code or connection strings.
  • Do not use the 0.0.0.0 Azure-services firewall rule without a documented security review.
  • Do not run delete, restore, failover, or scaling operations without explicit confirmation and recovery planning.

Frequently Asked Questions

Does this skill connect to my Azure subscription?
No. It provides guidance and examples. Your environment must supply credentials, permissions, SDK packages, and execution tooling.
Which Azure database service does it cover?
It focuses on Azure Database for PostgreSQL Flexible Server. It does not target the retired Single Server service.
Can it create production-ready infrastructure?
It can draft useful C# patterns. Production deployment still requires security, networking, reliability, cost, and compliance review.
How should administrator credentials be handled?
Load credentials from an approved secret provider. Prefer Entra ID authentication and never commit passwords or tokens.
Does it support backup and disaster recovery workflows?
Yes. It covers backup inspection, point-in-time restore, read replicas, and high availability configuration.
Can examples change or delete live resources?
Yes. Generated operations can create, scale, stop, restart, restore, or delete resources when executed with sufficient permissions.

Developer Details

Author

sickn33

License

MIT

Skillstore revision

r2

Version notice

The author did not declare a version.

Ref

f9e2c34b4f19c7f3e6b0a1e93227b5f77cc12526

Maintenance freshness

7/26/2026

Usage

8 downloads ยท 93 views

File structure

๐Ÿ“„ SKILL.md

More from sickn33

View all
View all