1---
2name: azure-horizondb
3description: 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 using azure_ai SQL/embeddings, pgvector tuning, Apache AGE graphs, hybrid BM25+vector search, or LangChain, and other Azure Horizondb related development tasks. Not for Azure Cosmos DB (use azure-cosmos-db).
4compatibility: Requires network access. Uses mcp_microsoftdocs:microsoft_docs_fetch or fetch_webpage to retrieve documentation.
5metadata:
6 generated_at: "2026-09-06"
7 generator: "docs2skills/1.0.0"
8---
9
10# Azure Horizondb Skill
11
12This 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.
13
14## How to Use This Skill
15
16> **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
17
18> **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](https://github.com/MicrosoftDocs/mcp/blob/main/README.md)
19
20This skill requires **network access** to fetch documentation content:
21- **Preferred**: Use `mcp_microsoftdocs:microsoft_docs_fetch` with query string `from=learn-agent-skill`. Returns Markdown.
22- **Fallback**: Use `fetch_webpage` with query string `from=learn-agent-skill&accept=text/markdown`. Returns Markdown.
23
24## Category Index
25
26| Category | Lines | Description |
27|----------|-------|-------------|
28| Troubleshooting | L37-L44 | Diagnosing and fixing HorizonDB issues: extension management errors, TLS/cert rotation failures, autovacuum tuning, and transaction ID wraparound prevention. |
29| Best Practices | L45-L55 | Performance and operations guidance for HorizonDB: data prep for AI, pgvector tuning, partitioning, extensions, Apache AGE, Query Store, and cluster maintenance best practices. |
30| Decision Making | L56-L61 | Guidance 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. |
31| Architecture & Design Patterns | L62-L67 | Patterns for building RAG with graph data in HorizonDB and implementing hybrid BM25+vector search, including design choices and query strategies. |
32| Limits & Quotas | L68-L73 | Managing HorizonDB replica counts, read-scale limits, and how to request quota or limit increases for HorizonDB resources. |
33| Security | L74-L88 | Configuring HorizonDB security: TLS/SSL and certificates, SCRAM auth, access control/roles, users/permissions, data-at-rest encryption, deletion protection, and admin password resets. |
34| Configuration | L89-L165 | Configuring HorizonDB clusters: AI models/pipelines, search/vector indexes, extensions, networking/firewalls, HA/replication, connection/auth, performance, logging, WAL, and resource tuning. |
35| Integrations & Coding Patterns | L166-L178 | Using HorizonDB with AI: azure_ai SQL/embedding/rerank functions, LangChain vector store, building knowledge graphs, and integrating/moving data via the Azure Storage extension. |
36| Deployment | L179-L182 | Guides for migrating data by dumping PostgreSQL databases and restoring them into HorizonDB, including required tools, commands, and compatibility considerations. |
37
38### Troubleshooting
39| Topic | URL |
40|-------|-----|
41| Resolve common HorizonDB extension management errors | https://learn.microsoft.com/en-us/azure/horizondb/extensions/errors-extensions |
42| Troubleshoot TLS connection failures after HorizonDB cert rotation | https://learn.microsoft.com/en-us/azure/horizondb/security/security-tls-troubleshoot |
43| Monitor and tune autovacuum in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/troubleshoot/how-to-autovacuum-monitor-tune |
44| Prevent and resolve transaction ID wraparound in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/troubleshoot/how-to-prevent-resolve-wraparound |
45
46### Best Practices
47| Topic | URL |
48|-------|-----|
49| Prepare data in HorizonDB for AI apps and agents | https://learn.microsoft.com/en-us/azure/horizondb/ai/ai-data-preparation |
50| Optimize pgvector performance in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/optimize-pgvector-performance |
51| Plan and manage scheduled maintenance for HorizonDB clusters | https://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/concepts-maintenance |
52| Optimize HorizonDB with pg_partman partitioning | https://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-use-pg-partman |
53| Apply HorizonDB-specific considerations when using extensions | https://learn.microsoft.com/en-us/azure/horizondb/extensions/concepts-extensions-considerations |
54| Apply Apache AGE performance best practices | https://learn.microsoft.com/en-us/azure/horizondb/graph/age-performance |
55| Apply Query Store best practices in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/monitor/concepts-query-store-best-practices |
56
57### Decision Making
58| Topic | URL |
59|-------|-----|
60| Choose vector vs full-text vs hybrid search | https://learn.microsoft.com/en-us/azure/horizondb/ai/ai-search-overview |
61| Select the right HorizonDB vector index | https://learn.microsoft.com/en-us/azure/horizondb/ai/vector-index-selection-guide |
62
63### Architecture & Design Patterns
64| Topic | URL |
65|-------|-----|
66| Design graph-augmented RAG in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/graph-rag |
67| Implement hybrid search with BM25 and vectors | https://learn.microsoft.com/en-us/azure/horizondb/ai/hybrid-search |
68
69### Limits & Quotas
70| Topic | URL |
71|-------|-----|
72| Manage HorizonDB replicas and read-scale limits | https://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-add-remove-replica |
73| Request HorizonDB resource quota and limit increases | https://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-request-quota-increase |
74
75### Security
76| Topic | URL |
77|-------|-----|
78| Enable deletion protection for HorizonDB clusters | https://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-enable-deletion-protection |
79| Manage SSL configuration parameters for HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-connections-authentication-ssl |
80| Configure TLS security parameters in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-tls |
81| Configure access control and roles in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/security/security-access-control |
82| Configure SCRAM authentication for HorizonDB connections | https://learn.microsoft.com/en-us/azure/horizondb/security/security-connect-scram |
83| Understand data-at-rest encryption in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/security/security-data-encryption |
84| Manage database users and permissions in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/security/security-manage-database-users |
85| Reset administrator password in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/security/security-reset-admin-password |
86| TLS requirements and encryption behavior in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/security/security-tls |
87| Configure TLS/SSL client connections to HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/security/security-tls-how-to-connect |
88| Update trusted root certificates for HorizonDB clients | https://learn.microsoft.com/en-us/azure/horizondb/security/security-update-trusted-root-java |
89
90### Configuration
91| Topic | URL |
92|-------|-----|
93| Configure AI Model Management (AIMM) in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/ai-model-management |
94| Define and run AI pipelines in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/ai-pipelines |
95| Configure pg_textsearch BM25 search in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/full-text-search |
96| Configure DiskANN vector indexing in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/vector-index-diskann |
97| Enable and configure pgvector in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/vector-search-pgvector |
98| Use point-in-time restore for HorizonDB clusters | https://learn.microsoft.com/en-us/azure/horizondb/backup-restore/how-to-restore-custom-restore-point |
99| Configure pg_durable workflows in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/development/durable-functions |
100| HorizonDB PostgreSQL extensions by engine version | https://learn.microsoft.com/en-us/azure/horizondb/extensions/concepts-extensions-by-engine |
101| Catalog of supported HorizonDB extensions and modules | https://learn.microsoft.com/en-us/azure/horizondb/extensions/concepts-extensions-versions |
102| Allowlist and configure HorizonDB extensions | https://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-allow-extensions |
103| Configure Azure Storage extension settings in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-configure-azure-storage-extension |
104| Create extensions in Azure HorizonDB clusters | https://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-create-extensions |
105| Drop extensions safely in HorizonDB clusters | https://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-drop-extensions |
106| Configure shared_preload_libraries in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-load-libraries |
107| Update extensions in Azure HorizonDB instances | https://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-update-extensions |
108| List installed extensions and versions in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/extensions/how-to-view-installed-extensions |
109| Enable and manage high availability in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/high-availability/how-to-configure-high-availability |
110| Perform planned and forced failover in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/high-availability/how-to-perform-failover |
111| Understand HorizonDB public access networking model | https://learn.microsoft.com/en-us/azure/horizondb/network/concepts-network-public |
112| Configure networking and connectivity for HorizonDB clusters | https://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network |
113| Add public access firewall rules for HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network-cluster-public-access-add-firewall |
114| Delete HorizonDB firewall rules for public access | https://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network-cluster-public-access-delete-firewall |
115| List existing firewall rules on HorizonDB clusters | https://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network-cluster-public-access-list-firewall |
116| Update HorizonDB firewall rule IP ranges and metadata | https://learn.microsoft.com/en-us/azure/horizondb/network/how-to-network-cluster-public-access-update-firewall |
117| Configure adaptive autovacuum parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-adaptive-autovacuum |
118| Tune autovacuum parameters for HorizonDB clusters | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-autovacuum |
119| Configure other client connection defaults in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-client-connection-defaults-defaults |
120| Set client locale and formatting defaults in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-client-connection-defaults-locale-formatting |
121| Manage shared library preloading parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-client-connection-defaults-shared-library-preload |
122| Adjust statement behavior defaults for HorizonDB clients | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-client-connection-defaults-statement-behavior |
123| Configure authentication parameters for HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-connections-authentication-authentication |
124| Configure HorizonDB connection settings and max_connections | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-connections-authentication-connection-settings |
125| Tune TCP settings parameters for HorizonDB connections | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-connections-authentication-tcp-settings |
126| Use customized options parameters like blob_block_size_mb | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-customized-options |
127| Configure developer options parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-developer-options |
128| Set error handling parameters for HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-error-handling |
129| Configure file location parameters for HorizonDB storage | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-file-locations |
130| Adjust intelligent tuning parameters for HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-intelligent-tuning |
131| Manage lock management parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-lock-management |
132| Configure metrics collection parameters for HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-metrics |
133| Set migration-related parameters for HorizonDB clusters | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-migration |
134| Configure PgBouncer parameters for Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-pgbouncer |
135| Tune preset options parameters in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-preset-options |
136| Manage process title parameters in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-process-title |
137| Configure genetic query optimizer parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-query-tuning-genetic-query-optimizer |
138| Configure planner cost constants in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-query-tuning-planner-cost-constants |
139| Control planner method configuration in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-query-tuning-planner-method-configuration |
140| Adjust planner option parameters for HorizonDB queries | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-query-tuning-planner-options |
141| Set replication master server parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-master-server |
142| Understand primary replication parameters availability in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-primary-server |
143| Configure replication slots for HorizonDB high availability | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-sending-servers |
144| Manage standby server replication parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-standby-servers |
145| Configure replication subscriber parameters in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-replication-subscribers |
146| Control logging content with HorizonDB parameters | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-reporting-logging-what-log |
147| Configure logging frequency and timing in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-reporting-logging-when-log |
148| Set logging destinations with HorizonDB parameters | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-reporting-logging-where-log |
149| Tune asynchronous behavior resource usage in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-asynchronous-behavior |
150| Configure background writer resource usage in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-background-writer |
151| Adjust cost-based vacuum delay parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-cost-based-vacuum-delay |
152| Manage disk-related resource usage parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-disk |
153| Configure kernel resource usage parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-kernel-resources |
154| Configure memory and huge pages usage in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-resource-usage-memory |
155| Configure cumulative query and index statistics in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-statistics-cumulative-query-index-statistics |
156| Configure monitoring statistics parameters in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-statistics-monitoring |
157| Understand statistics collector parameter availability in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-statistics-query-index-statistics-collector |
158| Configure platform and client compatibility parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-version-platform-compatibility-platforms-clients |
159| Manage compatibility parameters for previous PostgreSQL versions | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-version-platform-compatibility-postgresql-versions |
160| Configure archive recovery write-ahead log parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-archive-recovery |
161| Set WAL archiving parameters in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-archiving |
162| Configure WAL checkpoint size parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-checkpoints |
163| Manage WAL recovery parameters in Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-recovery |
164| Configure WAL recovery target parameters in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-recovery-target |
165| Tune WAL buffer settings for Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/parameters/parameters-write-ahead-log-settings |
166
167### Integrations & Coding Patterns
168| Topic | URL |
169|-------|-----|
170| Integrate AI frameworks with Azure HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/ai-frameworks |
171| Use azure_ai SQL functions for GenAI in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/ai-functions |
172| Build knowledge graphs from text with HorizonDB AI | https://learn.microsoft.com/en-us/azure/horizondb/ai/build-knowledge-graph |
173| Use HorizonDB as LangChain vector store | https://learn.microsoft.com/en-us/azure/horizondb/ai/develop-with-langchain |
174| Use create_embeddings() AI function in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/generate-vector-embeddings |
175| Apply azure_ai.rank() semantic reranking in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/ai/semantic-rank-function |
176| Use Azure Storage extension to move data with HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/extensions/concepts-storage-extension |
177| Run quickstart examples for HorizonDB Azure Storage extension | https://learn.microsoft.com/en-us/azure/horizondb/extensions/quickstart-azure-storage-extension |
178| Use Azure Storage extension functions in HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/extensions/reference-azure-storage-extension |
179
180### Deployment
181| Topic | URL |
182|-------|-----|
183| Dump and restore PostgreSQL databases to HorizonDB | https://learn.microsoft.com/en-us/azure/horizondb/migrate/how-to-migrate-dump-restore |
microsoftdocs