Azure Database Postgresql

Organization

MicrosoftDocs

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, managed identities, Private Link/TLS, or PITR/geo-restore, 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).

Overview

Publisher	MicrosoftDocs
Repository	`Agent-Skills`
Skill name	`azure-database-postgresql`
Stars	778
Forks	126
Bundled files	Instructions only
License	CC-BY-4.0
Links	Skill source Repository Homepage

Markdown instructions
A SKILL.md file the model loads on demand, so it only costs tokens when a request actually matches.
Works with any LLM
AI skills are plain Markdown, not provider-specific code, so this works with GPT, Claude, Gemini, Grok, or a local model.
Self-contained
Everything the model needs lives in the instructions — no extra files to sync.
Open source
Published by MicrosoftDocs on GitHub. Read the source before you install it.

Installation

Install the Azure Database Postgresql AI skill in TypingMind to use it with any LLM, or drop it into another agent that reads SKILL.md.

Install in TypingMind

TypingMind installs a skill straight from its GitHub folder — it reads SKILL.md, bundles the resource files, and stores the result locally.

Open the app and go to Plugins → Skills.
Choose "Install from GitHub".
Paste the skill folder URL below and confirm.
https://github.com/MicrosoftDocs/Agent-Skills/tree/main/skills/azure-database-postgresql
Enable the skill in any chat where you want it available.

Store

Installed

Skills

Add skills

Import one or more skills from a public GitHub folder or a local .skill or .zip archive, or SKILL.md file.

From GitHub URLFrom .skill, .zip, or SKILL.md

GitHub repo or folder

https://github.com/MicrosoftDocs/Agent-Skills/tree/main/skills/azure-database-postgresql

Points to a single skill folder, or any folder that contains multiple skills. Public repos only.

CancelContinue

Plugins → Skills → Add skill → From GitHub URL, then paste the folder URL and press Continue.

Install in another agent

Any agent that reads the Agent Skills format can use this skill — copy the folder into that agent's skills directory.

Claude Code — .claude/skills

git clone --depth 1 https://github.com/MicrosoftDocs/Agent-Skills.git /tmp/Agent-Skills
mkdir -p .claude/skills
cp -r /tmp/Agent-Skills/skills/azure-database-postgresql .claude/skills/azure-database-postgresql

Restart Claude Code after copying so it picks up the new skill.

Use it in TypingMind

Enable Azure Database Postgresql in any TypingMind chat and the model takes it from there. Its name and description sit in the system prompt, and the moment a request matches, the model loads the full instructions itself — you never invoke it by hand, and it costs no tokens until it is actually used.

The model loads Azure Database Postgresql on its own as soon as a request matches it.

Works with any AI model

AI skills are plain Markdown instructions rather than provider-specific code, so Azure Database Postgresql is not tied to the model it was written for. Install it once in TypingMind and use it with GPT-5, Claude, Gemini, Grok, DeepSeek, Mistral, Llama, or a local model you run yourself — all on your own API keys.

Loaded only when it is needed
The system prompt carries just the name and description. The instructions are fetched on the first matching request, so an idle skill costs nothing.
Switch models mid-chat
Because the skill is instructions rather than code, changing model does not break it — the next model reads the same SKILL.md.

Skill instructions

This is the SKILL.md content the model loads. Read it before installing — a skill is instructions your model will follow.

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
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
Use PostgreSQL flexible server troubleshooting guides	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/concepts-troubleshooting-guides
Monitor and tune autovacuum in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning
Troubleshoot and tune autovacuum on PostgreSQL elastic clusters	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning-elastic-clusters
Diagnose and mitigate high CPU in PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization
Troubleshoot high CPU in PostgreSQL elastic clusters	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization-elastic-clusters
Investigate and reduce high IOPS in PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-io-utilization
Troubleshoot high memory usage in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-memory-utilization
Diagnose slow queries on Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries
Diagnose slow-running queries on PostgreSQL elastic clusters	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries-elastic-clusters
Resolve capacity errors when deploying or scaling Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-resolve-capacity-errors
Troubleshoot Azure CLI errors for PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-cli-errors
Troubleshoot connection issues to Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-common-connection-issues
Run PostgreSQL troubleshooting guides in Azure portal	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshooting-guides
Configure telemetry sources for PostgreSQL troubleshooting guides	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/reference-troubleshooting-guides-telemetry
Fix autovacuum blockers and wraparound issues in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-autovacuum-blockers
Monitor autovacuum and wraparound risk in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-autovacuum-monitoring
Diagnose Azure Storage extension errors in PostgreSQL	https://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 replicas	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-canceling-statement-due-to-conflict-with-recovery
Diagnose high CPU on Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-high-cpu
Investigate high IOPS on Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-high-iops
Troubleshoot high memory usage in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-high-memory
Resolve high temporary file usage in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-high-temporary-files
Fix password authentication failed errors in PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-password-authentication-failed-for-user

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
Apply PgBouncer connection pooling strategies on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/connectivity/concepts-connection-pooling-best-practices
Apply Azure-specific PostgreSQL extension considerations	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
Apply Oracle-to-PostgreSQL schema conversion best practices	https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-best-practices
Understand autonomous tuning for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-autonomous-tuning
Use intelligent tuning for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-intelligent-tuning
Follow best practices for PostgreSQL Query Store	https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store-best-practices
Apply Query Store usage scenarios for PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store-scenarios
Create Azure PostgreSQL read replicas with performance guidance	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-create-read-replica
Bulk load data into Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-bulk-load-data
Optimize pg_stat_statements query stats on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-optimize-query-stats-collection
Use pg_repack to remove bloat on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-perform-fullvacuum-pg-repack
Tune pg_dump and pg_restore for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-pgdump-restore

Decision Making

Topic	URL
Choose compute tiers for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-compute
Select storage options for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage
Choose and configure Ultra Disk for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-ultra-disk
Plan and execute major version upgrades for Azure Database for PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-major-version-upgrade
Apply Azure PostgreSQL versioning and upgrade policy	https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-version-policy
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
Choose and configure Private Link for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/network/concepts-networking-private-link
Promote Azure PostgreSQL read replicas to primary or standalone	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas-promote
Promote Azure PostgreSQL read replica to standalone server	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-promote-replica-to-standalone
Switch Azure PostgreSQL read replica to primary role	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-switch-over-replica-to-primary
Choose scaling options for PostgreSQL flexible server resources	https://learn.microsoft.com/en-us/azure/postgresql/scale/concepts-scaling-resources

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
Use Redis caching with Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/development/how-to-cache
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
Review elastic cluster limits for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-limitations
Configure maximum client connections in PostgreSQL elastic clusters	https://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 service	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-known-issues-migration-service
Review limitations of Oracle application conversion	https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-application/app-conversions-limitations
Understand limitations of Oracle-to-PostgreSQL schema conversion	https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-limitations
Check statistics collector parameter availability by version	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-statistics-query-index-statistics-collector
Understand archive recovery parameter availability in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-archive-recovery
Review recovery parameter availability by PostgreSQL version	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-recovery
Check recovery target parameter availability in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-recovery-target
Use read replicas in Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas
Configure storage autogrow thresholds for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-auto-grow-storage
Adjust storage performance tiers for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-scale-storage-performance

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
Implement access control and roles in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-access-control
Configure pgaudit-based audit logging on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-audit
Apply Azure Policy to secure Azure PostgreSQL resources	https://learn.microsoft.com/en-us/azure/postgresql/security/security-azure-policy
Understand security and compliance for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/security/security-compliance
Configure data encryption keys for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-data-encryption
Enable system-assigned managed identity for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-system-assigned
Configure user-assigned managed identities for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-configure-managed-identities-user-assigned
Configure SCRAM authentication for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-scram
Connect to Azure PostgreSQL using managed identities	https://learn.microsoft.com/en-us/azure/postgresql/security/security-connect-with-managed-identity
Understand data-at-rest encryption for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-data-encryption
Use Microsoft Defender for Cloud with Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-defender-for-cloud
Configure Microsoft Entra authentication for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-entra-configure
Define firewall rules for Azure PostgreSQL public endpoints	https://learn.microsoft.com/en-us/azure/postgresql/security/security-firewall-rules
Create and manage PostgreSQL users on Azure Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/security/security-manage-database-users
Configure managed identities for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/security/security-managed-identity-overview
Apply security best practices to PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/security/security-overview
Configure TLS versions and policies for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-tls
Set up TLS connections to Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-how-to-connect
Update Java client certificates for Azure PostgreSQL TLS	https://learn.microsoft.com/en-us/azure/postgresql/security/security-update-trusted-root-java

Configuration

Topic	URL
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	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/settings
Use PostgreSQL server dashboard metrics in VS Code	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/server-dashboard
Enable azure_local_ai embeddings in PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/extensions/azure-local-ai
Enable PostgreSQL extensions on Azure Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-by-engine
Reference list of Azure PostgreSQL extensions	https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-versions
Allow and manage extensions on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-allow-extensions
Configure Azure Storage extension for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-configure-azure-storage-extension
Create extensions on Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-create-extensions
Drop extensions safely on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-drop-extensions
Configure shared_preload_libraries on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-load-libraries
Update extensions on Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-update-extensions
Configure high availability for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-configure-high-availability
Configure migration parameters for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-migration-parameters
Configure networking for PostgreSQL migration service	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-network-setup-migration-service
Review and manage schema conversion output artifacts	https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-review-tasks-artifacts
Configure adaptive autovacuum for Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-adaptive-autovacuum
Configure and access logs for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-logging
Configure metric alerts for PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-alert-on-metrics
Configure and route PostgreSQL flexible server logs	https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-and-access-logs
Configure autonomous tuning parameters for PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-autonomous-tuning
Configure intelligent tuning settings for PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-intelligent-tuning
Configure and download PostgreSQL server and upgrade logs	https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-server-logs
Visualize PostgreSQL metrics and logs with Grafana dashboards	https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-use-dashboards-with-grafana
Change private DNS zone for Azure PostgreSQL private access	https://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 Server	https://learn.microsoft.com/en-us/azure/postgresql/parameters/concepts-parameters
List all server parameters in Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-all
List parameters with modified defaults in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-modified
List read-only dynamic parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-read-only
List read-write dynamic parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-read-write-dynamic
List read-write static parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-list-read-write-static
Revert all parameters to defaults in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-revert-all-default
Revert a single parameter to default in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-revert-one-default
Set parameter values in Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/parameters/how-to-parameters-set-value
Configure adaptive autovacuum parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-adaptive-autovacuum
Manage autonomous tuning parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-autonomous-tuning
Tune autovacuum parameters on Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-autovacuum
Configure other client connection defaults in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-defaults
Set locale and formatting defaults for Azure PostgreSQL clients	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-locale-formatting
Preload shared libraries via client defaults in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-shared-library-preloading
Control client statement behavior parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-client-connection-defaults-statement-behavior
Configure authentication parameters for Azure PostgreSQL connections	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-authentication
Adjust connection settings and max_connections in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-connection-settings
Manage SSL connection parameters for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-ssl
Tune TCP connection settings for Azure PostgreSQL Flexible Server	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-connections-authentication-tcp-settings
Configure customized options like azure_storage.blob_block_size_mb	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-customized-options
Set developer option parameters on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-developer-options
Configure error handling parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-error-handling
Manage file location parameters for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-file-locations
Use intelligent tuning parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-intelligent-tuning
Configure lock management parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-lock-management
Set log files and metrics parameters for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-log-files-metrics
Configure migration-related parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-migration
Configure PgBouncer connection pooling parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-pgbouncer
Apply preset option parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-preset-options
Control process title parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-process-title
Configure Query Store parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-store
Tune genetic query optimizer parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-tuning-genetic-query-optimizer
Configure planner cost constants like effective_cache_size	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-tuning-planner-cost-constants
Set planner method configuration parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-tuning-planner-method-configuration
Adjust planner options for query tuning in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-query-tuning-planner-options
Configure replication master server parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-replication-master-server
Manage primary server replication parameters in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-replication-primary-server
Configure replication sending server slots in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-replication-sending-servers
Configure huge pages memory usage in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-resource-usage-memory
Configure max_wal_size for Azure PostgreSQL WAL checkpoints	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-checkpoints
Configure wal_buffers settings for Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/parameters/parameters-write-ahead-log-settings
Configure virtual endpoints for Azure PostgreSQL read replicas	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas-virtual-endpoints
Create virtual endpoints for Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-create-virtual-endpoints
Delete Azure PostgreSQL flexible server read replicas	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-delete-read-replica
Delete virtual endpoints in Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-delete-virtual-endpoints
View configured virtual endpoints in Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-show-virtual-endpoints
Update virtual endpoints on Azure PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/read-replica/how-to-update-virtual-endpoints
List and update PostgreSQL server configurations via CLI	https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-change-server-configuration
Monitor and scale PostgreSQL flexible server via CLI	https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-scale-server-up-or-down
Enable and download PostgreSQL slow query logs via CLI	https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-server-logs

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
Use PostgreSQL chat participants with Copilot Chat	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/chat-participant
Use PostgreSQL Copilot tools in VS Code	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/copilot-tools
Use MCP server providers in PostgreSQL VS Code extension	https://learn.microsoft.com/en-us/azure/postgresql/development/vs-code-extension/reference/mcp-server
Enable and use DiskANN with Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgdiskann
Use pgvector for vector search on Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgvector
Use Azure Storage extension function reference for PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/extensions/reference-azure-storage-extension
Automate start/stop for PostgreSQL flexible servers	https://learn.microsoft.com/en-us/azure/postgresql/integration/create-automation-tasks
Connect Azure Data Factory to PostgreSQL flexible server	https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-connect-data-factory
Use Data Factory copy activity with PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-copy-activity-azure
Run PostgreSQL scripts via Data Factory script activity	https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-script-activity-azure
Use pg_dump and pg_restore with Azure PostgreSQL	https://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-using-dump-and-restore
Set up Azure CLI integration for PostgreSQL migration service	https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-setup-azure-cli-commands-postgresql

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
Migrate PostgreSQL flexible server VNet to private endpoint	https://learn.microsoft.com/en-us/azure/postgresql/network/how-to-migrate-vnet-private-endpoint-capable-server
Restore PostgreSQL flexible server to a point in time	https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-point-in-time-restore

Frequently asked questions

What does the Azure Database Postgresql AI skill do?

Why use Azure Database Postgresql on TypingMind?

Because you install it once and use it with any model. Azure Database Postgresql is plain Markdown rather than provider-specific code, so the same skill runs on GPT-5, Claude, Gemini, Grok, or a local model — and you can switch model mid-chat without it breaking. TypingMind runs on your own API keys, so you pay providers directly instead of a per-seat subscription, and your skills and chats stay in your own storage.

How do I install Azure Database Postgresql in TypingMind?

Open Plugins → Skills → Install from GitHub in TypingMind and paste https://github.com/MicrosoftDocs/Agent-Skills/tree/main/skills/azure-database-postgresql. TypingMind reads its SKILL.md and installs it as a skill you can enable per chat.

Which AI models can use Azure Database Postgresql?

Any model you connect in TypingMind. AI skills are plain Markdown instructions rather than provider-specific code, so GPT, Claude, Gemini, Grok, and local models can all load this skill when a request matches it.

How many AI models can I use with Azure Database Postgresql?

As many as you like. As long as a model supports skills, you can use Azure Database Postgresql with it — GPT, Claude, Gemini, Grok, DeepSeek, Mistral, Llama and more — all on TypingMind with your own API keys.

Is the Azure Database Postgresql AI skill free?

Yes. It is published on GitHub by MicrosoftDocs under the CC-BY-4.0 license. You only pay your own AI provider for the tokens you use.

What are AI skills?

An AI skill is a reusable instruction bundle that teaches an AI model how to do one specific task. It follows the open Agent Skills format: a SKILL.md file with a name and description, plus any scripts, templates or reference files the model may need. The model reads the instructions only when your request matches the skill, so an installed skill costs nothing until it is used.

How are AI skills different from plugins or MCP servers?

A plugin or MCP server gives a model new tools to call — code that runs somewhere and returns a result. An AI skill gives the model knowledge and process instead: how to approach a task, which steps to follow, what good output looks like. Skills are plain Markdown, so they need no server, no API key and no runtime, and they work with any model.

View all

Mcp Apps Builder

Shubhamsaboo

CommunityPopular

**MANDATORY for ALL MCP server work** - mcp-use framework best practices and patterns. **READ THIS FIRST** before any MCP server work, including: - Creating new MCP servers - Modifying existing MCP…

Canary

Post-deploy canary monitoring. (gstack)

Land And Deploy

Land and deploy workflow. (gstack)

Clawsweeper

Use for all ClawSweeper work: OpenClaw issue/PR sweep reports, repair jobs, cloud fix PRs, @clawsweeper maintainer mention commands, trusted ClawSweeper-reviewed autofix/automerge, GitHub Actions…

Overview

Installation

Install in TypingMind

Install in another agent

Use it in TypingMind

Works with any AI model

Skill instructions

Azure Database for PostgreSQL Skill

How to Use This Skill

Category Index

Troubleshooting

Best Practices

Decision Making

Architecture & Design Patterns

Limits & Quotas

Security

Configuration

Integrations & Coding Patterns

Deployment

Frequently asked questions

Related AI Skills

Set up your own AI workspace now