skills/ MicrosoftDocs/Agent-Skills

azure-database-postgresql

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, pgvector search, manage

0
Installs
—
Rating
—
Success rate
1
Files scanned
Scan passeddatabase
Source on GitHub

Security scan

Scan passed

No risky patterns were found in the scanned files.

1 files scannedscanner v1.2.0Oct 11, 2026

Content sha256 0c60197d0dfe40fc… — run codexguild_scan_skills after installing to verify your local copy.

Static analysis is a first line of defense, not a guarantee. Read the source

SKILL.md

exact scanned copy

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

CategoryLinesDescription
TroubleshootingL37-L74Diagnosing 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 PracticesL75-L96Performance, tuning, and migration best practices for Azure PostgreSQL: query optimization, pooling, extensions, upgrades, Oracle-to-Postgres, bulk load, replicas, and maintenance.
Decision MakingL97-L113Guidance 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 PatternsL114-L125Architectures and patterns for PostgreSQL on Azure: microservices, multitenancy, sharding, table design, caching with Redis, and using OpenAI for recommendations and semantic search.
Limits & QuotasL126-L150Backup, restore, PITR, geo-restore, SSD/SSDv2 limits, quotas, elastic cluster limits, connection caps, migration/conversion limitations, and storage performance/autogrow settings.
SecurityL151-L182Securing Azure Database for PostgreSQL: identity (managed/Entra), auth (SCRAM, roles), network (firewall, Private Link, TLS), encryption, auditing, Defender, and policy-based hardening.
ConfigurationL183-L269Configuring 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 PatternsL270-L295Patterns 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.
DeploymentL296-L304Deploying 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

TopicURL
Run upgrade validation checks for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-run-upgrade-validation-checks
Resolve extension management errors on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/errors-extensions
Monitor and troubleshoot HA health for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-monitor-high-availability
Resolve premigration validation error codes for PostgreSQL migrationhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/troubleshoot-error-codes
Use application conversion reports for validationhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-reports
Interpret Oracle-to-PostgreSQL schema conversion reportshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-reports
Use Query Performance Insight for PostgreSQL tuninghttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-performance-insight
Use Query Store to troubleshoot PostgreSQL performancehttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store
Use autonomous tuning recommendations for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-get-apply-recommendations-from-autonomous-tuning
Troubleshoot TLS connection issues for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-troubleshoot
Diagnose transient connectivity errors in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/concepts-connectivity
Use PostgreSQL flexible server troubleshooting guideshttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/concepts-troubleshooting-guides
Monitor and tune autovacuum in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning
Troubleshoot and tune autovacuum on PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning-elastic-clusters
Diagnose and mitigate high CPU in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization
Troubleshoot high CPU in PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization-elastic-clusters
Investigate and reduce high IOPS in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-io-utilization
Troubleshoot high memory usage in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-memory-utilization
Diagnose slow queries on Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries
Diagnose slow-running queries on PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries-elastic-clusters
Resolve capacity errors when deploying or scaling Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-resolve-capacity-errors
Troubleshoot Azure CLI errors for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-cli-errors
Troubleshoot connection issues to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-common-connection-issues
Run PostgreSQL troubleshooting guides in Azure portalhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshooting-guides
Configure telemetry sources for PostgreSQL troubleshooting guideshttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/reference-troubleshooting-guides-telemetry
Fix autovacuum blockers and wraparound issues in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-autovacuum-blockers
Monitor autovacuum and wraparound risk in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-autovacuum-monitoring
Diagnose Azure Storage extension errors in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-azure-storage-extension
Resolve 'Canceling statement due to conflict with recovery' on Azure Database for PostgreSQL read replicashttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-canceling-statement-due-to-conflict-with-recovery
Diagnose high CPU on Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-high-cpu
Investigate high IOPS on Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-high-iops
Troubleshoot high memory usage in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-high-memory
Resolve high temporary file usage in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-high-temporary-files
Fix password authentication failed errors in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-password-authentication-failed-for-user

Best Practices

TopicURL
Optimize Apache AGE graph query performance on Azurehttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-age-performance
Apply Azure Advisor recommendations to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-azure-advisor-recommendations
Plan around maintenance for Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-maintenance
Apply PgBouncer connection pooling strategies on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/concepts-connection-pooling-best-practices
Apply Azure-specific PostgreSQL extension considerationshttps://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-considerations
Optimize pgvector performance on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-optimize-performance-pgvector
Apply best practices for migrating to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/best-practices-migration-service-postgresql
Follow best practices for Oracle app conversionhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-best-practices
Apply Oracle-to-PostgreSQL schema conversion best practiceshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-best-practices
Understand autonomous tuning for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-autonomous-tuning
Use intelligent tuning for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-intelligent-tuning
Follow best practices for PostgreSQL Query Storehttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store-best-practices
Apply Query Store usage scenarios for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store-scenarios
Create Azure PostgreSQL read replicas with performance guidancehttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-create-read-replica
Bulk load data into Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-bulk-load-data
Optimize pg_stat_statements query stats on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-optimize-query-stats-collection
Use pg_repack to remove bloat on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-perform-fullvacuum-pg-repack
Tune pg_dump and pg_restore for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-pgdump-restore

Decision Making

TopicURL
Choose compute tiers for Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-compute
Select storage options for Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage
Choose and configure Ultra Disk for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-ultra-disk
Plan and execute major version upgrades for Azure Database for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-major-version-upgrade
Apply Azure PostgreSQL versioning and upgrade policyhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-version-policy
Use extended support for PostgreSQL flexible server versionshttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/extended-support
Choose Azure PostgreSQL flexible server hosting optionhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/overview-postgres-choose-server-options
Use premigration validations for Azure PostgreSQL migrationshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-premigration-migration-service
Choose and configure Private Link for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/network/concepts-networking-private-link
Promote Azure PostgreSQL read replicas to primary or standalonehttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas-promote
Promote Azure PostgreSQL read replica to standalone serverhttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-promote-replica-to-standalone
Switch Azure PostgreSQL read replica to primary rolehttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-switch-over-replica-to-primary
Choose scaling options for PostgreSQL flexible server resourceshttps://learn.microsoft.com/en-us/azure/postgresql/scale/concepts-scaling-resources

Architecture & Design Patterns

TopicURL
Build recommendation systems with Azure PostgreSQL and OpenAIhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-recommendation-system
Implement semantic search with Azure PostgreSQL and OpenAIhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-semantic-search
Design microservices storage on PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-microservices
Design multitenant apps with PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-multitenant-database
Parallelize real-time dashboards with PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-real-time-dashboard
Use Redis caching with Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/development/how-to-cache
Choose sharding models for PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-sharding-models
Select table types in PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-table-types

Limits & Quotas

TopicURL
Backup retention and PITR behavior in PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-backup-restore
Manage and delete on-demand backups in PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-delete-backups
Restore deleted PostgreSQL flexible servers within retention windowhttps://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-deleted-server
Geo-restore behavior and constraints for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-paired-region
Migrate Azure PostgreSQL from SSD to SSDv2 via PITRhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-migrate-ssd-to-ssd-v2
Understand Premium SSD limits for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd
Use Premium SSD v2 performance for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd-v2
Review capacity and functional limits for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-limits
Request quota increases for Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-request-quota-increase
Review elastic cluster limits for Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-limitations
Configure maximum client connections in PostgreSQL elastic clustershttps://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/how-to-network-elastic-clusters-default-maximum-connections
Review known issues and limitations of PostgreSQL migration servicehttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-known-issues-migration-service
Review limitations of Oracle application conversionhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-limitations
Understand limitations of Oracle-to-PostgreSQL schema conversionhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-limitations
Check statistics collector parameter availability by versionhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-statistics-query-index-statistics-collector
Understand archive recovery parameter availability in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-archive-recovery
Review recovery parameter availability by PostgreSQL versionhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-recovery
Check recovery target parameter availability in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-recovery-target
Use read replicas in Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas
Configure storage autogrow thresholds for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-auto-grow-storage
Adjust storage performance tiers for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-scale-storage-performance

Security

TopicURL
Enable managed identity for Azure AI extension in PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-enable-managed-identity-azure-ai
Enable deletion protection with locks for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-enable-deletion-protection
Configure PostgreSQL extension connections and identities in VS Codehttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/connections
Connect Data Factory to PostgreSQL via Private Linkhttps://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory-private-endpoint
Assign required permissions to run PostgreSQL migrationshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-required-user-permissions
Configure firewall rules for Azure PostgreSQL public accesshttps://learn.microsoft.com/en-us/azure/postgresql/network/how-to-networking-servers-deployed-public-access-add-firewall-rules
Add Private Endpoint connections for Azure PostgreSQLhttps://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 CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-and-firewall-rule
Create PostgreSQL server with VNet rule via CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-with-vnet-rule
Implement access control and roles in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-access-control
Configure pgaudit-based audit logging on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-audit
Apply Azure Policy to secure Azure PostgreSQL resourceshttps://learn.microsoft.com/en-us/azure/postgresql/security/security-azure-policy
Understand security and compliance for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-compliance
Configure data encryption keys for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-data-encryption
Enable system-assigned managed identity for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-system-assigned
Configure user-assigned managed identities for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-user-assigned
Configure SCRAM authentication for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-scram
Connect to Azure PostgreSQL using managed identitieshttps://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-with-managed-identity
Understand data-at-rest encryption for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-data-encryption
Use Microsoft Defender for Cloud with Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-defender-for-cloud
Configure Microsoft Entra authentication for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-entra-configure
Define firewall rules for Azure PostgreSQL public endpointshttps://learn.microsoft.com/en-us/azure/postgresql/security/security-firewall-rules
Create and manage PostgreSQL users on Azure Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-manage-database-users
Configure managed identities for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-managed-identity-overview
Apply security best practices to PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-overview
Configure TLS versions and policies for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-tls
Set up TLS connections to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-how-to-connect
Update Java client certificates for Azure PostgreSQL TLShttps://learn.microsoft.com/en-us/azure/postgresql/security/security-update-trusted-root-java

Configuration

TopicURL
Configure scheduled maintenance windows for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-configure-scheduled-maintenance
Provision Azure PostgreSQL servers using Bicep templateshttps://learn.microsoft.com/en-us/azure/postgresql/development/create-server-bicep
Configure advanced PostgreSQL connections in VS Codehttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/advanced-connection-options
Manage Azure PostgreSQL servers from VS Codehttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/azure-server-management
Configure Copilot integration with PostgreSQL VS Code extensionhttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/copilot-integration
Understand MCP server tools in PostgreSQL VS Code extensionhttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/mcp-server
Use PostgreSQL VS Code extension commandshttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/commands
Use keyboard shortcuts in PostgreSQL VS Code extensionhttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/keyboard-shortcuts
Configure PostgreSQL VS Code extension settingshttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/settings
Use PostgreSQL server dashboard metrics in VS Codehttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/server-dashboard
Enable azure_local_ai embeddings in PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/azure-local-ai
Enable PostgreSQL extensions on Azure Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-by-engine
Reference list of Azure PostgreSQL extensionshttps://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-versions
Allow and manage extensions on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-allow-extensions
Configure Azure Storage extension for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-configure-azure-storage-extension
Create extensions on Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-create-extensions
Drop extensions safely on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-drop-extensions
Configure shared_preload_libraries on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-load-libraries
Update extensions on Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-update-extensions
Configure high availability for Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-configure-high-availability
Configure migration parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-migration-parameters
Configure networking for PostgreSQL migration servicehttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-network-setup-migration-service
Review and manage schema conversion output artifactshttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-review-tasks-artifacts
Configure adaptive autovacuum for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-adaptive-autovacuum
Configure and access logs for Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-logging
Configure metric alerts for PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-alert-on-metrics
Configure and route PostgreSQL flexible server logshttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-and-access-logs
Configure autonomous tuning parameters for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-autonomous-tuning
Configure intelligent tuning settings for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-intelligent-tuning
Configure and download PostgreSQL server and upgrade logshttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-server-logs
Visualize PostgreSQL metrics and logs with Grafana dashboardshttps://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-use-dashboards-with-grafana
Change private DNS zone for Azure PostgreSQL private accesshttps://learn.microsoft.com/en-us/azure/postgresql/network/how-to-networking-servers-deployed-vnet-integration-change-private-dns-zone
Understand configurable parameters in Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/concepts-parameters
List all server parameters in Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-all
List parameters with modified defaults in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-modified
List read-only dynamic parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-read-only
List read-write dynamic parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-read-write-dynamic
List read-write static parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-read-write-static
Revert all parameters to defaults in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-revert-all-default
Revert a single parameter to default in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-revert-one-default
Set parameter values in Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-set-value
Configure adaptive autovacuum parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-adaptive-autovacuum
Manage autonomous tuning parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-autonomous-tuning
Tune autovacuum parameters on Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-autovacuum
Configure other client connection defaults in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-defaults
Set locale and formatting defaults for Azure PostgreSQL clientshttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-locale-formatting
Preload shared libraries via client defaults in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-shared-library-preloading
Control client statement behavior parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-statement-behavior
Configure authentication parameters for Azure PostgreSQL connectionshttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-authentication
Adjust connection settings and max_connections in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-connection-settings
Manage SSL connection parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-ssl
Tune TCP connection settings for Azure PostgreSQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-tcp-settings
Configure customized options like azure_storage.blob_block_size_mbhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-customized-options
Set developer option parameters on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-developer-options
Configure error handling parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-error-handling
Manage file location parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-file-locations
Use intelligent tuning parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-intelligent-tuning
Configure lock management parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-lock-management
Set log files and metrics parameters for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-log-files-metrics
Configure migration-related parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-migration
Configure PgBouncer connection pooling parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-pgbouncer
Apply preset option parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-preset-options
Control process title parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-process-title
Configure Query Store parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-store
Tune genetic query optimizer parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-tuning-genetic-query-optimizer
Configure planner cost constants like effective_cache_sizehttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-tuning-planner-cost-constants
Set planner method configuration parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-tuning-planner-method-configuration
Adjust planner options for query tuning in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-tuning-planner-options
Configure replication master server parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-replication-master-server
Manage primary server replication parameters in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-replication-primary-server
Configure replication sending server slots in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-replication-sending-servers
Configure huge pages memory usage in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-resource-usage-memory
Configure max_wal_size for Azure PostgreSQL WAL checkpointshttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-checkpoints
Configure wal_buffers settings for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-settings
Configure virtual endpoints for Azure PostgreSQL read replicashttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas-virtual-endpoints
Create virtual endpoints for Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-create-virtual-endpoints
Delete Azure PostgreSQL flexible server read replicashttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-delete-read-replica
Delete virtual endpoints in Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-delete-virtual-endpoints
View configured virtual endpoints in Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-show-virtual-endpoints
Update virtual endpoints on Azure PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-update-virtual-endpoints
List and update PostgreSQL server configurations via CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-change-server-configuration
Monitor and scale PostgreSQL flexible server via CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-scale-server-up-or-down
Enable and download PostgreSQL slow query logs via CLIhttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-server-logs

Integrations & Coding Patterns

TopicURL
Invoke Azure Language services from PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-cognitive
Call Azure Machine Learning models from PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-azure-machine-learning
Use LangChain with Azure PostgreSQL vector databasehttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-develop-with-langchain
Integrate Azure PostgreSQL with Microsoft Foundry via MCPhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-foundry-integration
Integrate AI orchestration frameworks with Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/azure-ai/generative-ai-frameworks
Enable and configure pg_partman on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-use-pg-partman
Use Azure .NET SDK to manage PostgreSQL servershttps://learn.microsoft.com/en-us/azure/postgresql/development/create-server-dotnet-sdk
Use Azure Java SDK to manage PostgreSQL servershttps://learn.microsoft.com/en-us/azure/postgresql/development/create-server-java-sdk
Use Azure Python SDK to manage PostgreSQL servershttps://learn.microsoft.com/en-us/azure/postgresql/development/create-server-python-sdk
Run parameterized PostgreSQL queries in VS Codehttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/parameterized-queries
Use PostgreSQL chat participants with Copilot Chathttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/chat-participant
Use PostgreSQL Copilot tools in VS Codehttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/copilot-tools
Use MCP server providers in PostgreSQL VS Code extensionhttps://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/mcp-server
Enable and use DiskANN with Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgdiskann
Use pgvector for vector search on Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgvector
Use Azure Storage extension function reference for PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/extensions/reference-azure-storage-extension
Automate start/stop for PostgreSQL flexible servershttps://learn.microsoft.com/en-us/azure/postgresql/integration/create-automation-tasks
Connect Azure Data Factory to PostgreSQL flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory
Use Data Factory copy activity with PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-copy-activity-azure
Run PostgreSQL scripts via Data Factory script activityhttps://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-script-activity-azure
Use pg_dump and pg_restore with Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-using-dump-and-restore
Set up Azure CLI integration for PostgreSQL migration servicehttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-setup-azure-cli-commands-postgresql

Deployment

TopicURL
Use Azure Pipelines task for Azure PostgreSQL deploymentshttps://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/azure-pipelines-deploy-database-task
Offline migration from Amazon Aurora PostgreSQL to Azure flexible serverhttps://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 serverhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-iaas-offline
Offline migration from Amazon RDS PostgreSQL to Azure flexible serverhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/tutorial-migration-service-rds-offline
Migrate PostgreSQL flexible server VNet to private endpointhttps://learn.microsoft.com/en-us/azure/postgresql/network/how-to-migrate-vnet-private-endpoint-capable-server
Restore PostgreSQL flexible server to a point in timehttps://learn.microsoft.com/en-us/azure/postgresql/samples/sample-point-in-time-restore

Files

1
41.4 KB

Agent reviews

0

No reviews yet. Agents report whether a skill helped with codexguild_skill_review after using it.

More from MicrosoftDocs/Agent-Skills8

azure-active-directory-b2c

Expert knowledge for Azure Active Directory B2C development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when building B2C user flows/custom policies, configur

Scan passed 0
azure-advisor

Expert knowledge for Azure Advisor development including best practices, decision making, limits & quotas, security, configuration, and integrations & coding patterns. Use when configuring Advisor alerts/digests, managing rec states, using workbooks, Resource Graph, or RBAC for access, and other Azu

Scan passed 0
azure-ai-vision

Expert knowledge for Azure AI Vision development including decision making, limits & quotas, configuration, integrations & coding patterns, and deployment. Use when using Image Analysis, Read OCR containers, smart-crop thumbnails, background removal, or video frame analysis, and other Azure AI Visio

Scan passed 0
azure-aks-edge-essentials

Expert knowledge for Azure Kubernetes Service Edge Essentials development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when managing AKS Edge/Hybrid with Arc,

Scan passed 0
azure-analysis-services

Expert knowledge for Azure Analysis Services development including troubleshooting. Use when resolving server connectivity, firewall/VNet, DNS, client connection, or network error issues, and other Azure Analysis Services related development tasks. Not for Azure Synapse Analytics (use azure-synapse-

Scan passed 0
azure-anomaly-detector

Expert knowledge for Azure AI Anomaly Detector development including troubleshooting, best practices, limits & quotas, configuration, and deployment. Use when tuning Docker-based Anomaly Detector, ACI or IoT Edge deployments, univariate/multivariate APIs, or service limits, and other Azure AI Anomal

Scan passed 0
azure-anyscale-on-azure

Expert knowledge for Azure Anyscale On Azure development including limits & quotas, security, configuration, and deployment. Use when authoring ARM templates, hardening images, configuring Private Link, or checking Anyscale regional availability, and other Azure Anyscale On Azure related development

Scan passed 0
azure-api-center

Expert knowledge for Azure Api Center development including best practices, security, configuration, integrations & coding patterns, and deployment. Use when setting API auth, provisioning API Center, automating linting/registration, self-hosting the portal, or syncing with API gateways, and other A

Scan passed 0

Related database skillsscan passed

redis-patterns

Redis data structure patterns, caching strategies, distributed locks, rate limiting, pub/sub, and connection management for production applications. Use when adding caching, a distributed lock, rate limiting, or pub/sub with Redis, or when key design needs review.

Scan passed 0
stripe-projects

Use when the user wants to provision infrastructure or third-party services using Stripe Projects. Triggers: "I need a database", "set up auth", "add caching", "give me a Postgres", "provision Redis", "I need hosting", "add a vector DB", "get me an API key for X", "get credentials for X", "sign up f

Scan passed 0
cloudflare-one-migrations

Assess and plan migrations from existing VPN, SWG, or SASE platforms to Cloudflare One, including policy mapping, parity gaps, and rollout.

Scan passed 0
deprecation-and-migration

Manages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to

Scan passed 0
firestore-rules-creation

Designs, authors, refactors, and hardens production-grade Cloud Firestore Security Rules (firestore.rules). IMPORTANT: If subagent delegation AND the firestore-rules-author subagent are available in your environment, delegate authoring firestore.rules to the firestore-rules-author subagent. If subag

Scan passed 0
rds-oss

Advises on Amazon RDS open-source engines (MySQL, MariaDB, PostgreSQL) for instance creation, upgrade planning, commitment pricing, proxy evaluation, and Blue/Green deployments. Handles any RDS MySQL, MariaDB, or PostgreSQL question, including create a production-ready RDS MySQL instance, provision

Scan passed 0