MCPInstall

azure-database-postgresql

by microsoftdocsData & Databases

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/AI search, Private Link/TLS, PITR/restore, or replicas/sharding, 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).

Installs
246
Last 24h
—
Trending rank
—
Security
Not audited

Install

Works with every agent the skills CLI supports.

npx skills add https://github.com/microsoftdocs/agent-skills --skill azure-database-postgresql
  1. 01

    Install

    Run the command in your project. The CLI asks which agents to install for.

  2. 02

    Describe the task

    Ask your agent for something this skill covers. It loads azure-database-postgresql automatically when relevant.

  3. 03

    Review the result

    The agent follows the SKILL.md steps, scripts and references bundled with the skill.

SKILL.md

The instructions your agent reads when the skill is triggered.

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-L73Diagnosing 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 PracticesL74-L95Performance, tuning, and migration best practices for Azure PostgreSQL: query/store tuning, pgvector/Apache AGE, pooling, maintenance, bulk load, bloat removal, and Oracle-to-Postgres conversion.
Decision MakingL96-L112Guidance 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 PatternsL113-L124Architectures and patterns for PostgreSQL on Azure: microservices, multitenancy, sharding, table design, caching with Redis, and using OpenAI for recommendations and semantic search.
Limits & QuotasL125-L149Backup, storage, and capacity limits for Azure PostgreSQL, including PITR/restore behavior, SSD/SSDv2 performance, quotas, elastic cluster limits, and migration/conversion constraints.
SecurityL150-L181Securing Azure Database for PostgreSQL: identity and auth (Entra, managed identities, SCRAM), network/firewall/Private Link, TLS, encryption, auditing, roles, policies, and Defender integration.
ConfigurationL182-L268Configuring Azure Database for PostgreSQL Flexible Server: maintenance windows, HA, networking, logging/metrics, extensions, tuning/parameters, PgBouncer, VS Code tools, CLI, and read replica virtual endpoints.
Integrations & Coding PatternsL269-L294Patterns 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.
DeploymentL295-L304Guides for deploying and migrating PostgreSQL to Azure flexible server (from Aurora, RDS, on-prem/VM, Oracle), configuring VNet/private endpoints, 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
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 best practices for Oracle schema conversionhttps://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
Tune Premium SSD v2 storage for PostgreSQL flexible servershttps://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 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 controls to Azure PostgreSQL flexible servershttps://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
Configure built-in PgBouncer for Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/connectivity/concepts-pgbouncer
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
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
Deploy converted Oracle schemas to Azure PostgreSQLhttps://learn.microsoft.com/en-us/azure/postgresql/migrate/oracle-conversions-schema/schema-conversions-setup
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

FAQ

What does the azure-database-postgresql skill do?

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/AI search, Private Link/TLS, PITR/restore, or replicas/sharding, 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).

How do I install azure-database-postgresql?

Run npx skills add https://github.com/microsoftdocs/agent-skills --skill azure-database-postgresql in your project. The skills CLI detects the agents you use and copies the skill into the right folder. For Claude Code you can also place the skill folder at ~/.claude/skills/azure-database-postgresql/ (personal) or .claude/skills/azure-database-postgresql/ (project).

Which AI agents can use azure-database-postgresql?

Any agent that supports the open Agent Skills format (a folder with a SKILL.md file), including Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, Windsurf, Cline, OpenCode and more.

Is azure-database-postgresql safe to install?

No partner security audit is available yet. Skills can run commands and scripts, so read the SKILL.md and any bundled files before installing.

Who maintains azure-database-postgresql?

It is published by microsoftdocs in microsoftdocs/agent-skills. It has 246 recorded installs.

More from microsoftdocs/agent-skills

View all →

azure-container-apps

microsoftdocs/agent-skills

Expert knowledge for Azure Container Apps development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when configuring ACA auth/networking, workload profiles/GPUs, CI/CD deployments, KEDA/Dapr scaling, or Java microservices, and other Azure Container Apps related development tasks. Not for Azure App Service (use azure-app-service), Azure Functions (use azure-functions), Azure Kubernetes Service (AKS) (use azure-kubernetes-service), Azure Spring Apps (use azure-spring-apps).

DevOps & Cloud1.3K installs

azure-sql-database

microsoftdocs/agent-skills

Expert knowledge for Azure SQL Database development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when choosing DTU/vCore tiers, configuring serverless or Hyperscale, geo-replication/DR, CI/CD, or Terraform, and other Azure SQL Database related development tasks. Not for 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 Data Factory (use azure-data-factory).

Data & Databases1.3K installs

azure-well-architected

microsoftdocs/agent-skills

Expert guidance for designing, assessing, and optimizing Azure workloads using Azure Well Architected. Covers design review checklists, recommendations, design principles, tradeoffs, service guides, workload patterns, and assessment questions. Use when designing AI/HPC/SaaS workloads, AVD/AVS deployments, WAF assessments, or App Service/AKS/SQL architectures, and other Azure Well Architected related development tasks.

DevOps & Cloud646 installs

azure-pipelines

microsoftdocs/agent-skills

Expert knowledge for Azure Pipelines development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when configuring YAML pipelines, agents, service connections, Key Vault secrets, or Kubernetes/web app deployments, and other Azure Pipelines related development tasks. Not for Azure DevOps (use azure-devops), Azure Boards (use azure-boards), Azure Repos (use azure-repos), Azure Test Plans (use azure-test-plans).

DevOps & Cloud439 installs

azure-architecture

microsoftdocs/agent-skills

Expert guidance for designing Azure solutions using Azure Architecture. Covers reference architectures, solution ideas, design patterns, technology choices, architecture styles, best practices, anti-patterns, example workloads, and migration guides. Use when designing AKS or App Service apps, SAP/ERP or IoT workloads, hybrid/Arc setups, or AI/ML solutions on Azure, and other Azure Architecture related development tasks.

Code Quality & Workflow419 installs

azure-devops

microsoftdocs/agent-skills

Expert knowledge for Azure DevOps development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when managing org/projects, repos, pipelines, work items, dashboards/analytics, or Azure DevOps Server deployments, and other Azure DevOps related development tasks. Not for Azure Boards (use azure-boards), Azure Pipelines (use azure-pipelines), Azure Repos (use azure-repos), Azure Test Plans (use azure-test-plans).

DevOps & Cloud407 installs

Popular data & databases skills

View category →

supabase-postgres-best-practices

supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pgcron, pgmq), vector/semantic search (pgvector), and restoring dumps (pgrestore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.

OfficialData & Databases462.2K installs

prisma-client-api

prisma/skills

Prisma Client API reference covering model queries, filters, operators, and client methods. Use when writing database queries, using CRUD operations, filtering data, or configuring Prisma Client. Triggers on "prisma query", "findMany", "create", "update", "delete", "$transaction".

OfficialData & Databases393.5K installs

prisma-database-setup

prisma/skills

Deprecated compatibility name for prisma-orm-setup. Use only when a user or existing integration explicitly invokes prisma-database-setup; otherwise select prisma-orm-setup.

OfficialData & Databases392.3K installs

prisma-cli

prisma/skills

Prisma ORM 7 CLI reference for existing Prisma 7 applications or explicitly selected Prisma 7 workflows. Covers prisma init, generate, migrate, db, dev, studio, and mcp. For setup, connection repair, or Prisma 8, use prisma-orm-setup; not the Prisma Platform CLI.

OfficialData & Databases390.8K installs

prisma-postgres

prisma/skills

Deprecated compatibility name for prisma-postgres-setup. Use only when a user or existing integration explicitly invokes prisma-postgres; otherwise select prisma-postgres-setup.

OfficialData & Databases384.4K installs

prisma-driver-adapter-implementation

prisma/skills

Required reference for Prisma ORM 7 SQL driver adapter work. Use when implementing or modifying adapters, adding database drivers, or touching SqlDriverAdapter, Transaction, savepoint, result mapping, or DriverAdapterError behavior. Covers current transaction lifecycle, optional savepoint hooks, original database-error preservation, and verification.

OfficialData & Databases378.9K installs