Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Azure Database for PostgreSQL Skill · microsoftdocs | DecimalAI

databy microsoftdocs

Azure Database for PostgreSQL Skill

microsoftdocs/azure-database-postgresql

Source microsoftdocs/agent-skills ↗License CC-BY-4.0

Expert knowledge for Azure Database for PostgreSQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment.

SkillScore64Maintained

Automatic

Data Engineer pack

Last verified 9/2/2026

What it changes

Passed 10 of 16 test cases with the skill, and 2 of 16 without it.

Without skill14%

With skill64%

Checks it passed that the model alone missed

recommends analyzing Query Store execution statistics to isolate resource-intensive queries
includes link https://learn.microsoft.com/en-us/azure/postgresql/development/create-server-bicep
includes link https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning

and 9 more in the full report

11 fixed3 passed either way8 still failing0 broke

Pass-rate lift: +50 pp
Tokens: +473%
Agent turns: 0%
Response time: -38%

Model gemini-3.6-flashMeasured 9/2/2026v4 · latest is v814 of 22 cases passed with skill · 16 comparable

Tokens, turns and time describe resource use, not a dollar price.

This benchmark measured an earlier version of the skill.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/microsoftdocs-azure-database-postgresql/SKILL.md https://app.decimal.ai/s/microsoftdocs-azure-database-postgresql/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add microsoftdocs-azure-database-postgresql, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/microsoftdocs-azure-database-postgresql/ and pins it in .decimal/skills.lock

decimalai skills add microsoftdocs-azure-database-postgresql

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/microsoftdocs-azure-database-postgresql/SKILL.md https://app.decimal.ai/s/microsoftdocs-azure-database-postgresql/SKILL.md

Raw file: /s/microsoftdocs-azure-database-postgresql/SKILL.md ↗ · machine-readable summary at /s/microsoftdocs-azure-database-postgresql.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 11 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 11

Prompt

Our DevOps platform team automates cloud infrastructure using Infrastructure as Code templates. What official Microsoft reference link provides Bicep template deployment patterns for Azure Database for PostgreSQL Flexible Server?

What was checked, without and with the skill
Checked	Without skill	With skill
includes link https://learn.microsoft.com/en-us/azure/postgresql/development/create-server-bicep	Missed	Passed

case-14 · gemini-3.6-flash · 9/2/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md296 linessingle file

Azure Database for PostgreSQL Skill

This skill provides expert guidance for Azure Database for PostgreSQL. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.

How to Use This Skill

IMPORTANT for Agent: Use the Category Index below to locate relevant sections. For categories with line ranges (e.g., L35-L120), use read_file with the specified lines. For categories with file links (e.g., [security.md](security.md)), use read_file on the linked reference file

IMPORTANT for Agent: If metadata.generated_at is more than 3 months old, suggest the user pull the latest version from the repository. If mcp_microsoftdocs tools are not available, suggest the user install it: Installation Guide

This skill requires network access to fetch documentation content:

Preferred: Use mcp_microsoftdocs:microsoft_docs_fetch with query string from=learn-agent-skill. Returns Markdown.
Fallback: Use fetch_webpage with query string from=learn-agent-skill&accept=text/markdown. Returns Markdown.

Category Index

Category	Lines	Description
Troubleshooting	L37-L74	Diagnosing and fixing PostgreSQL issues on Azure: connectivity/TLS, HA and replicas, performance (CPU, IOPS, memory, slow queries, autovacuum), migrations, extensions, CLI, and troubleshooting guides.
Best Practices	L75-L96	Performance, tuning, and migration best practices for Azure PostgreSQL: query optimization, pooling, extensions, upgrades, Oracle-to-Postgres, bulk load, replicas, and maintenance.
Decision Making	L97-L113	Guidance on sizing and scaling Flexible Server (compute, storage, Ultra Disk), networking/Private Link, hosting choices, replicas promotion, and PostgreSQL versioning, upgrades, and support.
Architecture & Design Patterns	L114-L125	Architectures and patterns for PostgreSQL on Azure: microservices, multitenancy, sharding, table design, caching with Redis, and using OpenAI for recommendations and semantic search.
Limits & Quotas	L126-L150	Backup, restore, PITR, geo-restore, SSD/SSDv2 limits, quotas, elastic cluster limits, connection caps, migration/conversion limitations, and storage performance/autogrow settings.
Security	L151-L182	Securing Azure Database for PostgreSQL: identity (managed/Entra), auth (SCRAM, roles), network (firewall, Private Link, TLS), encryption, auditing, Defender, and policy-based hardening.
Configuration	L183-L269	Configuring Azure Database for PostgreSQL servers: maintenance windows, extensions, tuning (autovacuum, Query Store, planner), logging/metrics, networking, HA, replication, VS Code tools, and CLI-based management.
Integrations & Coding Patterns	L270-L295	Patterns and code for integrating Azure PostgreSQL with AI/ML (Language, AML, LangChain, Foundry, MCP), vector search (pgvector, DiskANN), SDK automation, Data Factory, CLI, and VS Code/Copilot tools.
Deployment	L296-L304	Deploying and migrating PostgreSQL to Azure: CI/CD with Azure Pipelines, offline migrations from Aurora/RDS/on-prem/VM, VNet-to-private endpoint moves, and point-in-time restore.

Troubleshooting

Topic	URL
Run upgrade validation checks for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-run-upgrade-validation-checks
Resolve extension management errors on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/extensions/errors-extensions
Monitor and troubleshoot HA health for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-monitor-high-availability
Resolve premigration validation error codes for PostgreSQL migration	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/troubleshoot-error-codes
Use application conversion reports for validation	https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-reports
Interpret Oracle-to-PostgreSQL schema conversion reports	https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-reports
Use Query Performance Insight for PostgreSQL tuning	https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-performance-insight
Use Query Store to troubleshoot PostgreSQL performance	https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store
Use autonomous tuning recommendations for PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-get-apply-recommendations-from-autonomous-tuning

Track record

Benchmark

10 / 16

test cases passed, vs 2 / 16 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v5 — 10/9/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

microsoftdocs / agent-skills

skills/azure-database-postgresql/SKILL.md

View on GitHub ↗

License CC-BY-4.0Imported 10/9/2026Version v8

Other skills for the same job

Published skills whose descriptions closely match this one, with their headline benchmark lift.

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

Azure Database for PostgreSQL Skill

How to Use This Skill

Category Index

Troubleshooting

Track record

Benchmark

Adoption

SkillSafety

Source

Other skills for the same job

Related skills