azure-database-postgresql

name	azure-database-postgresql
description	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. Use when using Flexible Server, Query Store, pgvector/AI apps, PITR/geo-restore, or networking/firewall features, and other Azure Database for PostgreSQL related development tasks. Not for Azure SQL Database (use azure-sql-database), Azure SQL Managed Instance (use azure-sql-managed-instance), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines), Azure Database for MySQL (use azure-database-mysql).
compatibility	Requires network access. Uses mcp_microsoftdocs:microsoft_docs_fetch or fetch_webpage to retrieve documentation.
metadata	{"generated_at":"2026-08-09","generator":"docs2skills/1.0.0"}

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-L64	Diagnosing and fixing PostgreSQL issues: connectivity/TLS, HA, performance (CPU, memory, IOPS, slow queries, autovacuum), migrations/validation, extensions, capacity, and auth errors.
Best Practices	L65-L88	Performance, tuning, and migration best practices for Azure PostgreSQL: query optimization, extensions (pgvector, AGE), pooling, Query Store, maintenance, upgrades, Oracle migration, and bulk loading.
Decision Making	L89-L106	Guidance on sizing and scaling servers, choosing compute/storage/hosting, planning upgrades and migrations, and configuring networking and replica promotion for Azure PostgreSQL.
Architecture & Design Patterns	L107-L117	Patterns for AI-powered apps and scalable data: using PostgreSQL with OpenAI (recommendations, semantic search) and designing/sharding multitenant, microservices, and real-time dashboard storage.
Limits & Quotas	L118-L142	Backup, restore, PITR, geo-restore, SSD/SSDv2 limits, capacity/quotas, connection limits, replica behavior, storage performance/autogrow, and migration/conversion limitations.
Security	L143-L174	Securing Azure Database for PostgreSQL: identity and access control, firewall/VNet, TLS, encryption, auditing, Defender, policies, and security best practices for flexible server.
Configuration	L175-L261	Configuring Azure Database for PostgreSQL Flexible Server: server parameters, extensions, networking, logging/metrics, tuning (autovacuum, Query Store, PgBouncer), VS Code tools, and CLI-based management.
Integrations & Coding Patterns	L262-L288	Integrating Azure PostgreSQL with AI/ML (Language, ML, LangChain, Foundry, Copilot), SDKs (.NET/Java/Python), DevOps tools (VS Code, CLI, ADF), migrations, partitioning, and vector search.
Deployment	L289-L296	Guides for deploying and restoring Azure Database for PostgreSQL, including Azure Pipelines tasks and offline migrations from Aurora, RDS, and on-prem/VM PostgreSQL to flexible server.

Troubleshooting

Topic	URL
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
Troubleshoot TLS connection issues for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-troubleshoot
Diagnose transient connectivity errors in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/concepts-connectivity

Best Practices

Topic	URL
Optimize Apache AGE graph query performance on Azure	https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-age-performance
Apply Azure Advisor recommendations to Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-azure-advisor-recommendations
Plan around maintenance for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-maintenance
Run upgrade validation checks for PostgreSQL servers	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-run-upgrade-validation-checks
Apply PgBouncer connection pooling strategies on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/connectivity/concepts-connection-pooling-best-practices
Apply extension usage considerations on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-considerations
Optimize pgvector performance on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-optimize-performance-pgvector
Apply best practices for migrating to Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/best-practices-migration-service-postgresql
Follow best practices for Oracle app conversion	https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-best-practices

Decision Making

Topic	URL
Choose compute tiers for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-compute
Plan Azure PostgreSQL deployments for optimal performance	https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-optimal-performance
Select storage options for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage
Plan and execute major PostgreSQL version upgrades	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-major-version-upgrade
Use extended support for PostgreSQL flexible server versions	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/extended-support
Choose Azure PostgreSQL flexible server hosting option	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/overview-postgres-choose-server-options
Use premigration validations for Azure PostgreSQL migrations	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-premigration-migration-service
Use pre-migration checklist for Oracle to Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-migration/best-practices-oracle-to-postgresql-checklist
Choose and configure Private Link for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/network/concepts-networking-private-link
Migrate Azure PostgreSQL from VNet injection to Private Endpoint

Architecture & Design Patterns

Topic	URL
Build recommendation systems with Azure PostgreSQL and OpenAI	https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-recommendation-system
Implement semantic search with Azure PostgreSQL and OpenAI	https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-semantic-search
Design microservices storage on PostgreSQL elastic clusters	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-microservices
Design multitenant apps with PostgreSQL elastic clusters	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-multitenant-database
Parallelize real-time dashboards with PostgreSQL elastic clusters	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-real-time-dashboard
Choose sharding models for PostgreSQL elastic clusters	https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-sharding-models
Select table types in PostgreSQL elastic clusters	https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-table-types

Limits & Quotas

Topic	URL
Backup retention and PITR behavior in PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-backup-restore
Manage and delete on-demand backups in PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-delete-backups
Restore deleted PostgreSQL flexible servers within retention window	https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-deleted-server
Geo-restore behavior and constraints for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-paired-region
Migrate Azure PostgreSQL from SSD to SSDv2 via PITR	https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-migrate-ssd-to-ssd-v2
Understand Premium SSD limits for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd
Use Premium SSD v2 performance for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd-v2
Review capacity and functional limits for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-limits
Request quota increases for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-request-quota-increase
Capacity and functional limits for PostgreSQL elastic clusters	https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-limitations

Security

Topic	URL
Enable managed identity for Azure AI extension in PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-enable-managed-identity-azure-ai
Enable deletion protection with locks for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-enable-deletion-protection
Configure PostgreSQL extension connections and identities in VS Code	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/connections
Connect Data Factory to PostgreSQL via Private Link	https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory-private-endpoint
Assign required permissions to run PostgreSQL migrations	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-required-user-permissions
Configure firewall rules for Azure PostgreSQL public access	https://learn.microsoft.com/en-us/azure/postgresql/network/how-to-networking-servers-deployed-public-access-add-firewall-rules
Add Private Endpoint connections for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/network/how-to-networking-servers-deployed-public-access-add-private-endpoint
Create PostgreSQL server and firewall via Azure CLI	https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-and-firewall-rule
Create PostgreSQL server with VNet rule via CLI	https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-with-vnet-rule

Configuration

Topic	URL
Check supported PostgreSQL versions on Azure Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-supported-versions
Configure scheduled maintenance windows for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-configure-scheduled-maintenance
Provision Azure PostgreSQL servers using Bicep templates	https://learn.microsoft.com/en-us/azure/postgresql/development/create-server-bicep
Configure advanced PostgreSQL connections in VS Code	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/advanced-connection-options
Manage Azure PostgreSQL servers from VS Code	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/azure-server-management
Configure Copilot integration with PostgreSQL VS Code extension	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/copilot-integration
Understand MCP server tools in PostgreSQL VS Code extension	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/mcp-server
Use PostgreSQL VS Code extension commands	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/commands
Use keyboard shortcuts in PostgreSQL VS Code extension	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/keyboard-shortcuts
Configure PostgreSQL VS Code extension settings

Integrations & Coding Patterns

Topic	URL
Invoke Azure Language services from PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-cognitive
Call Azure Machine Learning models from PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-machine-learning
Use LangChain with Azure PostgreSQL vector database	https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-develop-with-langchain
Integrate Azure PostgreSQL with Microsoft Foundry via MCP	https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-foundry-integration
Integrate AI orchestration frameworks with Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-frameworks
Enable and configure pg_partman on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-use-pg-partman
Use Azure .NET SDK to manage PostgreSQL servers	https://learn.microsoft.com/en-us/azure/postgresql/development/create-server-dotnet-sdk
Use Azure Java SDK to manage PostgreSQL servers	https://learn.microsoft.com/en-us/azure/postgresql/development/create-server-java-sdk
Use Azure Python SDK to manage PostgreSQL servers	https://learn.microsoft.com/en-us/azure/postgresql/development/create-server-python-sdk
Run parameterized PostgreSQL queries in VS Code	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/parameterized-queries

Deployment

Topic	URL
Use Azure Pipelines task for Azure PostgreSQL deployments	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/azure-pipelines-deploy-database-task
Offline migration from Amazon Aurora PostgreSQL to Azure flexible server	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-aurora-offline
Offline migration from VM/on-prem PostgreSQL to Azure flexible server	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-iaas-offline
Offline migration from Amazon RDS PostgreSQL to Azure flexible server	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-rds-offline
Restore PostgreSQL flexible server to a point in time	https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-point-in-time-restore