Skip to content
cccskills
FreePublished on GitHub

azure-horizondb

Expert knowledge for Azure Horizondb development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when tuning pgvector, azure_ai SQL functions, LangChain vector stores, Apache AGE graphs, or hybrid search, and other Azure Horizondb related development tasks. Not for Azure Cosmos DB (use azure-cosmos-db), Azure SQL Database (use azure-sql-database), Azure Table Storage (use azure-table-storage).

The English summary is being prepared. Showing the original description.

MicrosoftDocs/Agent-Skills
Works withAzurePostgreSQL
See how to install

Files included (1)

  • SKILL.md20.7 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Azure Horizondb Skill

This skill provides expert guidance for Azure Horizondb. 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-L44Diagnosing and fixing HorizonDB issues: extension management errors, TLS/cert rotation failures, autovacuum tuning, and transaction ID wraparound prevention.
Best PracticesL45-L55Performance and operations guidance for HorizonDB: data prep for AI, pgvector tuning, partitioning, extensions, Apache AGE, Query Store, and cluster maintenance best practices.
Decision MakingL56-L61Guidance on choosing between vector, full-text, and hybrid search in HorizonDB, and selecting the optimal vector index type for your data, queries, and performance needs.
Architecture & Design PatternsL62-L66Patterns for building RAG with graph data in HorizonDB and implementing hybrid BM25+vector search, including design choices and query strategies.
Limits & QuotasL67-L72Managing HorizonDB replica counts, read-scale limits, and how to request quota or limit increases for HorizonDB resources.
SecurityL73-L88Securing HorizonDB: TLS/SSL setup, cert management, SCRAM auth, access control/roles, user accounts, encryption at rest, deletion protection, password resets, and security best practices.
ConfigurationL89-L164Configuring HorizonDB clusters: AI models/pipelines, search/vector indexing, extensions, networking/firewalls, HA/replication, autovacuum, connections, logging, WAL, and detailed PostgreSQL parameter tuning.
Integrations & Coding PatternsL165-L177Using HorizonDB with AI: azure_ai SQL/embedding/rerank functions, LangChain vector store, building knowledge graphs, and integrating/moving data via the Azure Storage extension.
DeploymentL178-L181Guides for migrating data by dumping PostgreSQL databases and restoring them into HorizonDB, including required tools, commands, and compatibility considerations.

Troubleshooting

TopicURL
Resolve common HorizonDB extension management errorshttps://learn.microsoft.com/en-us/azure/horizondb/extensions/errors-extensions
Troubleshoot TLS connection failures after HorizonDB cert rotationhttps://learn.microsoft.com/en-us/azure/horizondb/security/security-tls-troubleshoot
Monitor and tune autovacuum in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/troubleshoot/how-to-autovacuum-monitor-tune
Prevent and resolve transaction ID wraparound in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/troubleshoot/how-to-prevent-resolve-wraparound

Best Practices

TopicURL
Prepare data in HorizonDB for AI apps and agentshttps://learn.microsoft.com/en-us/azure/horizondb/ai/ai-data-preparation
Optimize pgvector performance in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/optimize-pgvector-performance
Plan and manage scheduled maintenance for HorizonDB clustershttps://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/concepts-maintenance
Optimize HorizonDB with pg_partman partitioninghttps://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-use-pg-partman
Apply HorizonDB-specific considerations when using extensionshttps://learn.microsoft.com/en-us/azure/horizondb/extensions/concepts-extensions-considerations
Apply Apache AGE performance best practiceshttps://learn.microsoft.com/en-us/azure/horizondb/graph/age-performance
Apply Query Store best practices in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/monitor/concepts-query-store-best-practices

Decision Making

TopicURL
Choose vector vs full-text vs hybrid searchhttps://learn.microsoft.com/en-us/azure/horizondb/ai/ai-search-overview
Select the right HorizonDB vector indexhttps://learn.microsoft.com/en-us/azure/horizondb/ai/vector-index-selection-guide

Architecture & Design Patterns

TopicURL
Design graph-augmented RAG in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/graph-rag

Limits & Quotas

TopicURL
Manage HorizonDB replicas and read-scale limitshttps://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-add-remove-replica
Request HorizonDB resource quota and limit increaseshttps://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-request-quota-increase

Security

TopicURL
Enable deletion protection for HorizonDB clustershttps://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-enable-deletion-protection
Manage SSL configuration parameters for HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-connections-authentication-ssl
Configure TLS security parameters in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-tls
Configure access control and roles in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/security/security-access-control
Configure SCRAM authentication for Azure HorizonDB connectionshttps://learn.microsoft.com/en-us/azure/horizondb/security/security-connect-scram
Understand and configure data-at-rest encryption in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/security/security-data-encryption
Manage database users and accounts in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/security/security-manage-database-users
Apply security best practices for Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/security/security-overview
Reset administrator passwords securely in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/security/security-reset-admin-password
TLS requirements and encryption behavior in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/security/security-tls
Configure TLS/SSL client connections to HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/security/security-tls-how-to-connect
Update TLS client certificates for Azure HorizonDB Java appshttps://learn.microsoft.com/en-us/azure/horizondb/security/security-update-trusted-root-java

Configuration

TopicURL
Configure AI Model Management (AIMM) in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/ai-model-management
Configure pg_textsearch BM25 search in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/full-text-search
Configure DiskANN vector indexing in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/vector-index-diskann
Enable and configure pgvector in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/vector-search-pgvector
Use point-in-time restore for HorizonDB clustershttps://learn.microsoft.com/en-us/azure/horizondb/backup-restore/how-to-restore-custom-restore-point
Configure pg_durable workflows in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/development/durable-functions
HorizonDB PostgreSQL extensions by engine versionhttps://learn.microsoft.com/en-us/azure/horizondb/extensions/concepts-extensions-by-engine
Catalog of supported HorizonDB extensions and moduleshttps://learn.microsoft.com/en-us/azure/horizondb/extensions/concepts-extensions-versions
Allowlist and configure HorizonDB extensionshttps://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-allow-extensions
Configure Azure Storage extension settings in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-configure-azure-storage-extension
Create extensions in Azure HorizonDB clustershttps://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-create-extensions
Drop extensions safely in HorizonDB clustershttps://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-drop-extensions
Configure shared_preload_libraries in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-load-libraries
Update extensions in Azure HorizonDB instanceshttps://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-update-extensions
List installed extensions and versions in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-view-installed-extensions
Enable and manage high availability in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/high-availability/how-to-configure-high-availability
Perform planned and forced failover in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/high-availability/how-to-perform-failover
Understand HorizonDB public access networking modelhttps://learn.microsoft.com/en-us/azure/horizondb/network/concepts-network-public
Configure networking and connectivity for HorizonDB clustershttps://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network
Add public access firewall rules for HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network-cluster-public-access-add-firewall
Delete HorizonDB firewall rules for public accesshttps://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network-cluster-public-access-delete-firewall
List existing firewall rules on HorizonDB clustershttps://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network-cluster-public-access-list-firewall
Update HorizonDB firewall rule IP ranges and metadatahttps://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network-cluster-public-access-update-firewall
Configure adaptive autovacuum parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-adaptive-autovacuum
Tune autovacuum parameters for HorizonDB clustershttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-autovacuum
Configure other client connection defaults in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-client-connection-defaults-defaults
Set client locale and formatting defaults in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-client-connection-defaults-locale-formatting
Manage shared library preloading parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-client-connection-defaults-shared-library-preload
Adjust statement behavior defaults for HorizonDB clientshttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-client-connection-defaults-statement-behavior
Configure authentication parameters for HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-connections-authentication-authentication
Configure HorizonDB connection settings and max_connectionshttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-connections-authentication-connection-settings
Tune TCP settings parameters for HorizonDB connectionshttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-connections-authentication-tcp-settings
Use customized options parameters like blob_block_size_mbhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-customized-options
Configure developer options parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-developer-options
Set error handling parameters for HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-error-handling
Configure file location parameters for HorizonDB storagehttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-file-locations
Adjust intelligent tuning parameters for HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-intelligent-tuning
Manage lock management parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-lock-management
Configure metrics collection parameters for HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-metrics
Set migration-related parameters for HorizonDB clustershttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-migration
Configure PgBouncer parameters for Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-pgbouncer
Tune preset options parameters in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-preset-options
Manage process title parameters in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-process-title
Configure genetic query optimizer parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-query-tuning-genetic-query-optimizer
Configure planner cost constants in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-query-tuning-planner-cost-constants
Control planner method configuration in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-query-tuning-planner-method-configuration
Adjust planner option parameters for HorizonDB querieshttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-query-tuning-planner-options
Set replication master server parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-master-server
Understand primary replication parameters availability in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-primary-server
Configure replication slots for HorizonDB high availabilityhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-sending-servers
Manage standby server replication parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-standby-servers
Configure replication subscriber parameters in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-subscribers
Control logging content with HorizonDB parametershttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-reporting-logging-what-log
Configure logging frequency and timing in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-reporting-logging-when-log
Set logging destinations with HorizonDB parametershttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-reporting-logging-where-log
Tune asynchronous behavior resource usage in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-asynchronous-behavior
Configure background writer resource usage in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-background-writer
Adjust cost-based vacuum delay parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-cost-based-vacuum-delay
Manage disk-related resource usage parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-disk
Configure kernel resource usage parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-kernel-resources
Configure memory and huge pages usage in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-memory
Configure cumulative query and index statistics in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-statistics-cumulative-query-index-statistics
Configure monitoring statistics parameters in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-statistics-monitoring
Understand statistics collector parameter availability in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-statistics-query-index-statistics-collector
Configure platform and client compatibility parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-version-platform-compatibility-platforms-clients
Manage compatibility parameters for previous PostgreSQL versionshttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-version-platform-compatibility-postgresql-versions
Configure archive recovery write-ahead log parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-archive-recovery
Set WAL archiving parameters in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-archiving
Configure WAL checkpoint size parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-checkpoints
Manage WAL recovery parameters in Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-recovery
Configure WAL recovery target parameters in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-recovery-target
Tune WAL buffer settings for Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-settings

Integrations & Coding Patterns

TopicURL
Integrate AI frameworks with Azure HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/ai-frameworks
Use azure_ai SQL functions for GenAI in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/ai-functions
Build knowledge graphs from text with HorizonDB AIhttps://learn.microsoft.com/en-us/azure/horizondb/ai/build-knowledge-graph
Use HorizonDB as LangChain vector storehttps://learn.microsoft.com/en-us/azure/horizondb/ai/develop-with-langchain
Use create_embeddings() AI function in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/generate-vector-embeddings
Apply azure_ai.rank() semantic reranking in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/semantic-rank-function
Use Azure Storage extension to move data with HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/extensions/concepts-storage-extension
Run quickstart examples for HorizonDB Azure Storage extensionhttps://learn.microsoft.com/en-us/azure/horizondb/extensions/quickstart-azure-storage-extension
Use Azure Storage extension functions in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/extensions/reference-azure-storage-extension

Deployment

TopicURL
Dump and restore PostgreSQL databases to HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/migrate/how-to-migrate-dump-restore

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

azure-active-directory-b2c

Free

Expert knowledge for Azure Active Directory B2C development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when building B2C user flows/custom policies, configuring IdPs/MFA, securing APIs, automating CI/CD, or monitoring with Sentinel, and other Azure Active Directory B2C related development tasks. Not for Azure Role-based access control (use azure-rbac), Azure Information Protection (use azure-information-protection), Azure Security (use azure-security), Azure Sentinel (use azure-sentinel).

The English summary is being prepared. Showing the original description.

MicrosoftDocs/Agent-Skills787Updated Oct 19, 2026

azure-advisor

Free

Expert knowledge for Azure Advisor development including best practices, decision making, limits & quotas, security, configuration, and integrations & coding patterns. Use when managing Advisor alerts, digests, recommendation states, Resource Graph queries, or RBAC access, and other Azure Advisor related development tasks. Not for Cost Management (use azure-cost-management), Azure Monitor (use azure-monitor), Azure Policy (use azure-policy), Azure Security (use azure-security).

The English summary is being prepared. Showing the original description.

MicrosoftDocs/Agent-Skills787Updated Oct 19, 2026

azure-ai-vision

Free

Expert knowledge for Azure AI Vision development including decision making, limits & quotas, configuration, integrations & coding patterns, and deployment. Use when using Image Analysis, Read OCR containers, smart-crop thumbnails, background removal, or video frame analysis, and other Azure AI Vision related development tasks. Not for Azure AI Custom Vision (use azure-custom-vision), Azure AI Video Indexer (use azure-video-indexer), Azure AI Document Intelligence (use azure-document-intelligence), Azure AI Immersive Reader (use azure-immersive-reader).

The English summary is being prepared. Showing the original description.

MicrosoftDocs/Agent-Skills787Updated Oct 19, 2026

azure-aks-edge-essentials

Free

Expert knowledge for Azure Kubernetes Service Edge Essentials development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when deploying AKS Edge/Hybrid with Arc, Azure Local, GitOps, IoT/OPC/ONVIF, or Key Vault-integrated workloads, and other Azure Kubernetes Service Edge Essentials related development tasks. Not for Azure Kubernetes Service (AKS) (use azure-kubernetes-service), Azure IoT Edge (use azure-iot-edge), Azure Stack Edge (use azure-stack-edge), Azure Container Apps (use azure-container-apps).

The English summary is being prepared. Showing the original description.

MicrosoftDocs/Agent-Skills787Updated Oct 19, 2026

azure-analysis-services

Free

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

The English summary is being prepared. Showing the original description.

MicrosoftDocs/Agent-Skills787Updated Oct 19, 2026

azure-anyscale-on-azure

Free

Expert knowledge for Azure Anyscale On Azure development including limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when registering AKS as Anyscale clouds, wiring ACR images, enabling Private Link/RBAC, ARM-based deployments, or region checks, and other Azure Anyscale On Azure related development tasks. Not for Azure Databricks (use azure-databricks), Azure Kubernetes Service (AKS) (use azure-kubernetes-service), Azure Machine Learning (use azure-machine-learning), Azure HDInsight (use azure-hdinsight).

The English summary is being prepared. Showing the original description.

MicrosoftDocs/Agent-Skills787Updated Oct 19, 2026

See all skills by MicrosoftDocs

Report a problem with this skill