jpskill.com
🛠️ 開発・MCP コミュニティ

azure-database-postgresql

Azure Database for PostgreSQLのトラブルシューティング、ベストプラクティス、アーキテクチャ設計、セキュリティ、構成、デプロイなど、開発に関する専門知識を提供するSkill。

📜 元の英語説明(参考)

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, HA/replicas, VNet/TLS security, vector search extensions, or AI/ML app integrations, 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 Cosmos DB (use azure-cosmos-db).

🇯🇵 日本人クリエイター向け解説

一言でいうと

Azure Database for PostgreSQLのトラブルシューティング、ベストプラクティス、アーキテクチャ設計、セキュリティ、構成、デプロイなど、開発に関する専門知識を提供するSkill。

※ jpskill.com 編集部が日本のビジネス現場向けに補足した解説です。Skill本体の挙動とは独立した参考情報です。

⚡ おすすめ: コマンド1行でインストール(60秒)

下記のコマンドをコピーしてターミナル(Mac/Linux)または PowerShell(Windows)に貼り付けてください。 ダウンロード → 解凍 → 配置まで全自動。

🍎 Mac / 🐧 Linux 
mkdir -p ~/.claude/skills && cd ~/.claude/skills && curl -L -o azure-database-postgresql.zip https://jpskill.com/download/5676.zip && unzip -o azure-database-postgresql.zip && rm azure-database-postgresql.zip
🪟 Windows (PowerShell) 
$d = "$env:USERPROFILE\.claude\skills"; ni -Force -ItemType Directory $d | Out-Null; iwr https://jpskill.com/download/5676.zip -OutFile "$d\azure-database-postgresql.zip"; Expand-Archive "$d\azure-database-postgresql.zip" -DestinationPath $d -Force; ri "$d\azure-database-postgresql.zip"

完了後、Claude Code を再起動 → 普通に「動画プロンプト作って」のように話しかけるだけで自動発動します。

💾 手動でダウンロードしたい(コマンドが難しい人向け)
  1. 1. 下の青いボタンを押して azure-database-postgresql.zip をダウンロード
  2. 2. ZIPファイルをダブルクリックで解凍 → azure-database-postgresql フォルダができる
  3. 3. そのフォルダを C:\Users\あなたの名前\.claude\skills\(Win)または ~/.claude/skills/(Mac)へ移動
  4. 4. Claude Code を再起動
⬇ .zip でダウンロード(推奨) ⬇ .skill 形式(上級者用) 元のソース ↗

⚠️ ダウンロード・利用は自己責任でお願いします。当サイトは内容・動作・安全性について責任を負いません。

🎯 このSkillでできること

下記の説明文を読むと、このSkillがあなたに何をしてくれるかが分かります。Claudeにこの分野の依頼をすると、自動で発動します。

📦 インストール方法 (3ステップ)

  1. 1. 上の「ダウンロード」ボタンを押して .skill ファイルを取得
  2. 2. ファイル名の拡張子を .skill から .zip に変えて展開(macは自動展開可)
  3. 3. 展開してできたフォルダを、ホームフォルダの .claude/skills/ に置く
    • · macOS / Linux: ~/.claude/skills/
    • · Windows: %USERPROFILE%\.claude\skills\

Claude Code を再起動すれば完了。「このSkillを使って…」と話しかけなくても、関連する依頼で自動的に呼び出されます。

詳しい使い方ガイドを見る →
最終更新
2026-05-17
取得日時
2026-05-17
同梱ファイル
1

📖 Skill本文(日本語訳)

※ 原文(英語/中国語)を Gemini で日本語化したものです。Claude 自身は原文を読みます。誤訳がある場合は原文をご確認ください。

Azure Database for PostgreSQL スキル

このスキルは、Azure Database for PostgreSQL に関する専門的なガイダンスを提供します。トラブルシューティング、ベストプラクティス、意思決定、アーキテクチャと設計パターン、制限とクォータ、セキュリティ、構成、統合とコーディングパターン、デプロイメントを網羅しています。ローカルのクイックリファレンスコンテンツとリモートのドキュメント取得機能を組み合わせています。

このスキルの使用方法

エージェントへの重要事項: 以下のカテゴリインデックスを使用して、関連するセクションを見つけてください。行範囲が指定されているカテゴリ (例: L35-L120) の場合は、指定された行で read_file を使用してください。ファイルリンクが指定されているカテゴリ (例: [security.md](security.md)) の場合は、リンクされた参照ファイルで read_file を使用してください。

エージェントへの重要事項: metadata.generated_at が3ヶ月以上前の場合は、リポジトリから最新バージョンをプルするようユーザーに提案してください。mcp_microsoftdocs ツールが利用できない場合は、ユーザーにインストールを提案してください: インストールガイド

このスキルは、ドキュメントコンテンツを取得するためにネットワークアクセスを必要とします。

  • 推奨: クエリ文字列 from=learn-agent-skill を指定して mcp_microsoftdocs:microsoft_docs_fetch を使用してください。Markdown を返します。
  • フォールバック: クエリ文字列 from=learn-agent-skill&accept=text/markdown を指定して fetch_webpage を使用してください。Markdown を返します。

カテゴリインデックス

カテゴリ 行 説明
トラブルシューティング L37-L60 Azure PostgreSQL の問題の診断と修正: 接続性/TLS、HA ヘルス、移行検証、autovacuum、高 CPU/IOPS/メモリ、低速クエリ、レプリカ、拡張機能、認証/CLI エラー。
ベストプラクティス L61-L79 Azure PostgreSQL のパフォーマンス、移行、セキュリティに関するベストプラクティス: クエリ/拡張機能のチューニング、プーリング、バルクロード、HA、スキーマ/アプリ/Oracle 移行、運用最適化。
意思決定 L80-L95 Azure Database for PostgreSQL のコンピューティング/ストレージのサイズ設定とスケーリング、バージョンとサポートの選択、アップグレード計画、geo レプリケーション、移行前チェックに関するガイダンス。
アーキテクチャと設計パターン L96-L106 Azure PostgreSQL (多くの場合 OpenAI と共に) を使用して、レコメンデーション/セマンティック検索アプリ、マイクロサービス、マルチテナンシー、リアルタイムダッシュボード、シャーディング/エラスティックデータアーキテクチャを構築するためのパターン。
制限とクォータ L107-L125 Azure Database for PostgreSQL のバックアップ/復元動作、ストレージとパフォーマンスの制限、クォータ、クライアント/レプリカの制限、エラスティッククラスターの制限、既知の移行/変換の制約。
セキュリティ L126-L157 Azure Database for PostgreSQL のセキュリティ保護: ネットワーク/VNet とファイアウォール、TLS/SSL、ID と認証 (Entra、SCRAM、マネージド ID)、暗号化、監査、Defender、セキュリティポリシー。
構成 L158-L236 Azure Database for PostgreSQL Flexible Server の構成: サーバーパラメーター、HA、ネットワーク、ログ/監視、メンテナンス、スケーリング、拡張機能、ベクトル検索、チューニングオプションの管理。
統合とコーディングパターン L237-L263 Azure PostgreSQL を AI/ML (Language、AML、LangChain、Foundry)、アプリ SDK (C#、Java、Python、Go、PHP)、VS Code/Copilot、Storage、Data Factory、移行ツールと統合するためのパターンとコード。
デプロイメント L264-L274 Azure PostgreSQL への CI/CD デプロイメント、アプリ統合 (AKS/Django、Web Apps + VNet)、フレキシブルサーバー Bicep プロビジョニング、メジャーアップグレード、ネットワーク移行、ポイントインタイムリカバリ。

トラブルシューティング

トピック URL
Azure での PostgreSQL 拡張機能管理エラーのトラブルシューティング https://learn.microsoft.com/en-us/azure/postgresql/extensions/errors-extensions
Azure PostgreSQL サーバーの HA ヘルス状態の解釈 https://learn.microsoft.com/en-us/azure/postgresql/high-availability/how-to-monitor-high-availability
PostgreSQL 移行の移行前検証エラーコードの解決 https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/troubleshoot-error-codes
自律チューニングの推奨事項の解釈と適用 https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-get-apply-recommendations-from-autonomous-tuning
Azure PostgreSQL での TLS 接続失敗のトラブルシューティング https://learn.microsoft.com/en-us/azure/postgresql/security/security-tls-troubleshoot
Azure PostgreSQL での一時的な接続エラーの診断 https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/concepts-connectivity
Azure PostgreSQL での autovacuum の監視とチューニング https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning
PostgreSQL エラスティッククラスターでの autovacuum のトラブルシューティングとチューニング https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-autovacuum-tuning-elastic-clusters
PostgreSQL での高 CPU の診断と軽減 https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization
PostgreSQL エラスティッククラスターでの高 CPU のトラブルシューティング https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-cpu-utilization-elastic-clusters
PostgreSQL での高 IOPS の調査と削減 https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-io-utilization
PostgreSQL での高メモリ使用量の診断と修正 https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-high-memory-utilization
Azure PostgreSQL フレキシブルサーバーでの低速クエリの診断 https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries
PostgreSQL エラスティッククラスターでの低速実行クエリの診断 https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-identify-slow-queries-elastic-clusters
Azure PostgreSQL のデプロイまたはスケーリング時の容量エラーの解決 https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-resolve-capacity-errors
PostgreSQL 用 Azure CLI エラーのトラブルシューティング https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/how-to-troubleshoot-cli-errors
📜 原文 SKILL.md(Claudeが読む英語/中国語)を展開

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-L60 Diagnosing and fixing Azure PostgreSQL issues: connectivity/TLS, HA health, migration validation, autovacuum, high CPU/IOPS/memory, slow queries, replicas, extensions, and auth/CLI errors.
Best Practices L61-L79 Performance, migration, and security best practices for Azure PostgreSQL: tuning queries/extensions, pooling, bulk load, HA, schema/app/Oracle migration, and operational optimization.
Decision Making L80-L95 Guidance on sizing and scaling compute/storage, choosing versions and support, planning upgrades, geo-replication, and pre-migration checks for Azure Database for PostgreSQL.
Architecture & Design Patterns L96-L106 Patterns for using Azure PostgreSQL (often with OpenAI) to build recommendation/semantic search apps, microservices, multitenancy, real-time dashboards, and sharded/elastic data architectures.
Limits & Quotas L107-L125 Backup/restore behavior, storage and performance limits, quotas, client/replica caps, elastic cluster limits, and known migration/conversion constraints for Azure Database for PostgreSQL.
Security L126-L157 Securing Azure Database for PostgreSQL: network/VNet and firewall, TLS/SSL, identities and auth (Entra, SCRAM, managed identities), encryption, auditing, Defender, and security policies.
Configuration L158-L236 Configuring Azure Database for PostgreSQL Flexible Server: server parameters, HA, networking, logging/monitoring, maintenance, scaling, and managing extensions, vector search, and tuning options.
Integrations & Coding Patterns L237-L263 Patterns and code to integrate Azure PostgreSQL with AI/ML (Language, AML, LangChain, Foundry), app SDKs (C#, Java, Python, Go, PHP), VS Code/Copilot, Storage, Data Factory, and migration tools.
Deployment L264-L274 CI/CD deployment to Azure PostgreSQL, app integration (AKS/Django, Web Apps + VNet), flexible server Bicep provisioning, major upgrades, network migration, and point-in-time restore.

Troubleshooting

Topic URL
Troubleshoot PostgreSQL extension management errors on Azure https://learn.microsoft.com/en-us/azure/postgresql/extensions/errors-extensions
Interpret HA health states for Azure PostgreSQL servers 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
Interpret and apply autonomous tuning recommendations https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-get-apply-recommendations-from-autonomous-tuning
Troubleshoot TLS connection failures in 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
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
Diagnose and fix high memory usage in 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
Troubleshoot Azure Storage extension errors in PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-azure-storage-extension
Resolve read replica conflict with recovery errors https://learn.microsoft.com/en-us/azure/postgresql/troubleshoot/troubleshoot-canceling-statement-due-to-conflict-with-recovery
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
Use pg_partman to partition large tables on Azure https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-use-pg-partman
Apply connection pooling best practices for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/connectivity/concepts-connection-pooling-best-practices
Optimize pgvector performance on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-optimize-performance-pgvector
Use best practices for Oracle-to-Azure PostgreSQL migrations https://learn.microsoft.com/en-us/azure/postgresql/migrate/best-practices-oracle-to-postgresql
Apply best practices for migrating to Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/best-practices-migration-service-postgresql
Apply best practices for Oracle-to-PostgreSQL app conversion https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-application-conversions/app-conversions-best-practices
Apply best practices for Oracle-to-PostgreSQL schema conversion https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-schema-conversions/schema-conversions-best-practices
Apply query store best practices in PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-query-store-best-practices
Apply security best practices to Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/security/security-overview
Configure max_replication_slots for Azure PostgreSQL HA https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-replication-sending-servers
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
Plan Azure PostgreSQL compute and storage for performance https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-optimal-performance
Plan and execute PostgreSQL major version upgrades https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-major-version-upgrade
Decide on reserved capacity purchases for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-reserved-pricing
Select supported PostgreSQL versions on Azure Flexible Server https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-supported-versions
Apply Azure Database for PostgreSQL version policy https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-version-policy
Use extended support for Azure PostgreSQL versions https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/extended-support
Choose Azure PostgreSQL hosting and deployment options https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/overview-postgres-choose-server-options
Use pre-migration checklist to size Azure PostgreSQL targets https://learn.microsoft.com/en-us/azure/postgresql/migrate/best-practices-oracle-to-postgresql-checklist
Use premigration validations for Azure PostgreSQL migrations https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-premigration-migration-service
Plan geo-replication for Azure PostgreSQL flexible server https://learn.microsoft.com/en-us/azure/postgresql/read-replica/concepts-read-replicas-geo
Scale compute tiers for Azure PostgreSQL flexible server https://learn.microsoft.com/en-us/azure/postgresql/scale/how-to-scale-compute

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 data architecture with PostgreSQL elastic clusters https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-microservices
Design multitenant apps with Azure PostgreSQL elastic clusters https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/tutorial-multitenant-database
Design 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 Azure PostgreSQL elastic clusters https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-sharding-models
Select table types in Azure PostgreSQL elastic clusters https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-table-types

Limits & Quotas

Topic URL
Understand backup and restore behavior for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/concepts-backup-restore
Recover dropped Azure PostgreSQL flexible servers from backups https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-dropped-server
Perform geo-restore to paired regions for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/backup-restore/how-to-restore-paired-region
Understand storage limits for Azure PostgreSQL flexible server https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage
Use Premium SSD storage with Azure PostgreSQL flexible server https://learn.microsoft.com/en-us/azure/postgresql/compute-storage/concepts-storage-premium-ssd
Tune Premium SSD v2 storage performance limits 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 capacity and functional limits https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/concepts-elastic-clusters-limitations
Understand max 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
Understand limitations of Oracle-to-PostgreSQL schema conversion tool https://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-schema-conversions/schema-conversions-limitations
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 for Azure 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 for Azure PostgreSQL flexible server https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-enable-deletion-protection
Configure private access and VNet for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/connectivity/quickstart-create-connect-server-vnet
Secure Data Factory–PostgreSQL connectivity 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
Create PostgreSQL server and firewall via CLI https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-and-firewall-rule
Create PostgreSQL VNet rule with Azure CLI https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-create-server-with-vnet-rule
Configure access control and roles for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/security/security-access-control
Configure pgaudit-based audit logging in Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/security/security-audit
Apply Azure Policy to secure Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/security/security-azure-policy
Review security and compliance certifications for Azure PostgreSQL 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 encryption at rest in Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/security/security-data-encryption
Use 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
Configure firewall rules for Azure PostgreSQL public access https://learn.microsoft.com/en-us/azure/postgresql/security/security-firewall-rules
Manage PostgreSQL database users on Azure flexible server https://learn.microsoft.com/en-us/azure/postgresql/security/security-manage-database-users
Use managed identities with Azure PostgreSQL securely https://learn.microsoft.com/en-us/azure/postgresql/security/security-managed-identity-overview
Configure TLS requirements for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/security/security-tls
Configure TLS/SSL 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
Configure authentication parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-authentication
Manage SSL connection parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-ssl
Configure TLS server parameters for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-tls

Configuration

Topic URL
Apply server configuration concepts for Azure PostgreSQL flexible server https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/concepts-servers
Schedule maintenance windows for Azure PostgreSQL flexible server https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-configure-scheduled-maintenance
Deploy PostgreSQL elastic clusters using ARM templates https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/quickstart-create-elastic-cluster-arm-template
Deploy PostgreSQL elastic clusters using Bicep templates https://learn.microsoft.com/en-us/azure/postgresql/elastic-clusters/quickstart-create-elastic-cluster-bicep
Configure retired azure_local_ai extension for in-database embeddings https://learn.microsoft.com/en-us/azure/postgresql/extensions/azure-local-ai
Check which PostgreSQL extensions Azure Flexible Server supports https://learn.microsoft.com/en-us/azure/postgresql/extensions/concepts-extensions-by-engine
Allow and allowlist PostgreSQL extensions on Azure 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 PostgreSQL extensions on Azure flexible server https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-create-extensions
Drop PostgreSQL extensions on Azure flexible server https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-drop-extensions
Configure shared_preload_libraries for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-load-libraries
Update PostgreSQL extensions on Azure flexible server https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-update-extensions
Configure and use DiskANN vector indexing in PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgdiskann
Enable and use pgvector for vector search in PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-use-pgvector
View installed PostgreSQL extensions and versions on Azure https://learn.microsoft.com/en-us/azure/postgresql/extensions/how-to-view-installed-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 server parameters for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/concepts-migration-server-parameters
Configure networking scenarios for PostgreSQL migration service https://learn.microsoft.com/en-us/azure/postgresql/migrate/migration-service/how-to-network-setup-migration-service
Configure and access server logs in Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-logging
Configure Azure Monitor workbooks for PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/monitor/concepts-workbooks
Set up metric alerts for PostgreSQL in Azure https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-alert-on-metrics
Configure and access PostgreSQL diagnostic 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 and download PostgreSQL and upgrade logs https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-configure-server-logs
Manage intelligent tuning settings with Azure CLI https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-enable-intelligent-performance-cli
Configure intelligent tuning via Azure portal https://learn.microsoft.com/en-us/azure/postgresql/monitor/how-to-enable-intelligent-performance-portal
List and change PostgreSQL server configuration via CLI https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-change-server-configuration
Scale PostgreSQL server compute and storage via CLI https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-scale-server-up-or-down
Enable and download PostgreSQL server logs via CLI https://learn.microsoft.com/en-us/azure/postgresql/samples/sample-server-logs
Understand server parameters for Azure PostgreSQL flexible server https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/concepts-server-parameters
List all server parameters for Azure PostgreSQL flexible server https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-all
List Azure PostgreSQL parameters with modified defaults https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-modified
List read-only dynamic parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-only
List read-write dynamic parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-write-dynamic
List read-write static parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-list-read-write-static
Revert all Azure PostgreSQL parameters to defaults https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-revert-all-default
Revert a single Azure PostgreSQL parameter to default https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-revert-one-default
Set Azure PostgreSQL server parameter values safely https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/how-to-server-parameters-set-value
Configure autovacuum parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-autovacuum
Configure client connection default options on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-defaults
Set locale and formatting defaults on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-locale-formatting
Preload shared libraries via client defaults on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-shared-library-preloading
Control statement behavior defaults on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-client-connection-defaults-statement-behavior
Tune connection settings and max_connections on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-connection-settings
Configure TCP settings for Azure PostgreSQL connections https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-connections-authentication-tcp-settings
Use customized server options like azure_storage.blob_block_size_mb https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-customized-options
Developer options server parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-developer-options
Configure error handling parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-error-handling
File location server parameters for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-file-locations
Lock management server parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-lock-management
Migration-related server parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-migration
Configure PgBouncer parameters and tier support on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-pgbouncer
Preset options server parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-preset-options
Process title server parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-process-title
Genetic query optimizer parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-genetic-query-optimizer
Tune planner cost constants like effective_cache_size https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-cost-constants
Planner method configuration parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-method-configuration
Other planner options for query tuning on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-query-tuning-planner-options
Tune asynchronous behavior parameters for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-asynchronous-behavior
Configure background writer parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-background-writer
Adjust cost-based vacuum delay on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-cost-based-vacuum-delay
Configure disk-related resource usage for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-disk
Configure kernel resource usage for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-kernel-resources
Configure memory and huge pages for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-resource-usage-memory
Configure cumulative query and index stats in Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-cumulative-query-index-statistics
Configure monitoring statistics parameters for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-monitoring
Understand query and index stats collector parameters by version https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-statistics-query-index-statistics-collector
Set compatibility parameters for other clients on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-version-platform-compatibility-platforms-clients
Configure compatibility with previous PostgreSQL versions in Azure https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-version-platform-compatibility-postgresql-versions
Check archive recovery parameters availability by Azure PostgreSQL version https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-archive-recovery
Configure WAL archiving parameters on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-archiving
Tune WAL checkpoint parameters for Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-checkpoints
Check WAL recovery parameters availability across Azure PostgreSQL versions https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-recovery
Check WAL recovery target parameters availability by version https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-recovery-target
Configure WAL settings and buffers on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/server-parameters/param-write-ahead-log-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
Connect to Azure PostgreSQL from C# applications https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-csharp
Access Azure PostgreSQL using Go database drivers https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-go
Use Java and JDBC with Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-java
Connect PHP applications to Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-php
Connect to Azure Database for PostgreSQL with Python https://learn.microsoft.com/en-us/azure/postgresql/connectivity/connect-python
Manage Azure PostgreSQL servers using .NET SDK https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-dotnet-sdk
Create and manage Azure PostgreSQL via Java SDK https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-java-sdk
Provision Azure PostgreSQL with Python SDK https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-python-sdk
Connect PostgreSQL databases via VS Code extension https://learn.microsoft.com/en-us/azure/postgresql/developer/vs-code-extension/vs-code-connect
Use GitHub Copilot with VS Code PostgreSQL extension https://learn.microsoft.com/en-us/azure/postgresql/developer/vs-code-extension/vs-code-github-copilot
Use Azure Storage extension examples for PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/extensions/quickstart-azure-storage-extension
Use Azure Storage extension function reference for PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/extensions/reference-azure-storage-extension
Configure Azure Data Factory connector for PostgreSQL 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 script activity in Data Factory https://learn.microsoft.com/en-us/azure/postgresql/integration/how-to-data-factory-script-activity-azure
Migrate Oracle schemas to Azure PostgreSQL using Ora2Pg https://learn.microsoft.com/en-us/azure/postgresql/migrate/how-to-migrate-oracle-ora2pg
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
Deploy database updates via Azure Pipelines to Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/azure-pipelines-deploy-database-task
Use GitHub Actions to deploy changes to Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-deploy-github-action
Perform in-place major version upgrades on Azure PostgreSQL https://learn.microsoft.com/en-us/azure/postgresql/configure-maintain/how-to-perform-major-version-upgrade
Deploy Azure PostgreSQL flexible server using Bicep https://learn.microsoft.com/en-us/azure/postgresql/developer/create-server-bicep
Deploy Django on AKS with Azure PostgreSQL backend https://learn.microsoft.com/en-us/azure/postgresql/developer/django-aks-database
Deploy Azure Web App and PostgreSQL in same VNet https://learn.microsoft.com/en-us/azure/postgresql/developer/webapp-server-vnet
Migrate Azure PostgreSQL from VNet injection to private endpoints 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