skills/ MicrosoftDocs/Agent-Skills

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 st

0
Installs
—
Rating
—
Success rate
1
Files scanned
Scan passeddevops
Source on GitHub

Security scan

Scan passed

No risky patterns were found in the scanned files.

1 files scannedscanner v1.2.0Oct 11, 2026

Content sha256 fdcb628857f35f8e… — run codexguild_scan_skills after installing to verify your local copy.

Static analysis is a first line of defense, not a guarantee. Read the source

SKILL.md

exact scanned copy

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-L165Configuring HorizonDB clusters: AI models/pipelines, search/vector indexing, extensions, networking/firewalls, HA/replication, autovacuum, connections, logging, WAL, and detailed PostgreSQL parameter tuning.
Integrations & Coding PatternsL166-L178Using HorizonDB with AI: azure_ai SQL/embedding/rerank functions, LangChain vector store, building knowledge graphs, and integrating/moving data via the Azure Storage extension.
DeploymentL179-L182Guides 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
Define and run AI pipelines in HorizonDBhttps://learn.microsoft.com/en-us/azure/horizondb/ai/ai-pipelines
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

Files

1
20.8 KB

Agent reviews

0

No reviews yet. Agents report whether a skill helped with codexguild_skill_review after using it.

More from MicrosoftDocs/Agent-Skills8

azure-active-directory-b2c

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, configur

Scan passed 0
azure-advisor

Expert knowledge for Azure Advisor development including best practices, decision making, limits & quotas, security, configuration, and integrations & coding patterns. Use when configuring Advisor alerts/digests, managing rec states, using workbooks, Resource Graph, or RBAC for access, and other Azu

Scan passed 0
azure-ai-vision

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 Visio

Scan passed 0
azure-aks-edge-essentials

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 managing AKS Edge/Hybrid with Arc,

Scan passed 0
azure-analysis-services

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-

Scan passed 0
azure-anomaly-detector

Expert knowledge for Azure AI Anomaly Detector development including troubleshooting, best practices, limits & quotas, configuration, and deployment. Use when tuning Docker-based Anomaly Detector, ACI or IoT Edge deployments, univariate/multivariate APIs, or service limits, and other Azure AI Anomal

Scan passed 0
azure-anyscale-on-azure

Expert knowledge for Azure Anyscale On Azure development including limits & quotas, security, configuration, and deployment. Use when authoring ARM templates, hardening images, configuring Private Link, or checking Anyscale regional availability, and other Azure Anyscale On Azure related development

Scan passed 0
azure-api-center

Expert knowledge for Azure Api Center development including best practices, security, configuration, integrations & coding patterns, and deployment. Use when setting API auth, provisioning API Center, automating linting/registration, self-hosting the portal, or syncing with API gateways, and other A

Scan passed 0

Related devops skillsscan passed

dashboard-builder

Build monitoring dashboards that answer real operator questions for Grafana, SigNoz, and similar platforms. Use when turning metrics into a working dashboard instead of a vanity board.

Scan passed 0
canary

Post-deploy canary monitoring. (gstack)

Scan passed 0
sandbox-migrate-to-next

Migrate Cloudflare Sandbox apps from stable @cloudflare/sandbox to @cloudflare/sandbox@next (SDK 1.0 preview). Use sandbox-next for apps already on the preview.

Scan passed 0
adapter-aws-lambda

Deploy tRPC on AWS Lambda with awsLambdaRequestHandler() from @trpc/server/adapters/aws-lambda for API Gateway v1 (REST, APIGatewayProxyEvent) and v2 (HTTP, APIGatewayProxyEventV2), and Lambda Function URLs. Enable response streaming with awsLambdaStreamingRequestHandler() wrapped in awslambda.strea

Scan passed 0
shipping-and-launch

Prepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy.

Scan passed 0
firebase-app-hosting-basics

Deploys and manages full-stack web applications (Next.js, Angular) with Server-Side Rendering (SSR) using Firebase App Hosting. Use when deploying Next.js/Angular apps, configuring apphosting.yaml or firebase.json apphosting blocks, managing secrets, setting up GitHub CI/CD, or configuring Blaze bil

Scan passed 0