azure-horizondb

Name: azure-horizondb
Author: microsoftdocs

github.com/microsoftdocsData & databases79663 installsUpdated 3d ago

About azure-horizondb

A guidance skill for Azure HorizonDB users covering operations, architecture, security, configuration, and deployment. Its reference index links focused topics spanning PostgreSQL tuning, AI search, integrations, and migration.

Key features

01Troubleshooting and maintenance guidance
02Vector, full-text, and hybrid search choices
03Security and access-control configuration
04Cluster and PostgreSQL parameter tuning
05AI, graph, and storage integrations
06PostgreSQL migration guidance

Use cases

01Diagnose TLS or extension errors
02Choose a search mode and vector index
03Secure database access and encryption
04Tune clusters and migrate PostgreSQL data

MCP support

The skill recommends using mcp_microsoftdocs microsoft_docs_fetch to retrieve documentation, with fetch_webpage as a fallback.

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/microsoftdocs/agent-skills --skill azure-horizondb

After installing, type/azure-horizondbin Claude Code to confirm it loaded.

Details

From the project README

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

Category	Lines	Description
Troubleshooting	L37-L44	Diagnosing and fixing HorizonDB issues: extension management errors, TLS/cert rotation failures, autovacuum tuning, and transaction ID wraparound prevention.
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.
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.
Architecture & Design Patterns	L62-L66	Patterns for building RAG with graph data in HorizonDB and implementing hybrid BM25+vector search, including design choices and query strategies.
Limits & Quotas	L67-L72	Managing HorizonDB replica counts, read-scale limits, and how to request quota or limit increases for HorizonDB resources.
Security	L73-L88	Securing HorizonDB: TLS/SSL setup, cert management, SCRAM auth, access control/roles, user accounts, encryption at rest, deletion protection, password resets, and security best practices.
Configuration	L89-L164	Configuring HorizonDB clusters: AI models/pipelines, search/vector indexing, extensions, networking/firewalls, HA/replication, autovacuum, connections, logging, WAL, and detailed PostgreSQL parameter tuning.
Integrations & Coding Patterns	L165-L177	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.
Deployment	L178-L181	Guides for migrating data by dumping PostgreSQL databases and restoring them into HorizonDB, including required tools, commands, and compatibility considerations.

Troubleshooting

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

Best Practices

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

Decision Making

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

Architecture & Design Patterns

Topic	URL
Design graph-augmented RAG in HorizonDB	https://learn.microsoft.com/en-us/azure/horizondb/ai/graph-rag

Limits & Quotas

Topic	URL
Manage HorizonDB replicas and read-scale limits	https://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-add-remove-replica
Request HorizonDB resource quota and limit increases	https://learn.microsoft.com/en-us/azure/horizondb/configure-maintain/how-to-request-quota-increase

Security

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

Configuration

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

Integrations & Coding Patterns

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

Deployment

Topic	URL
Dump and restore PostgreSQL databases to HorizonDB	https://learn.microsoft.com/en-us/azure/horizondb/migrate/how-to-migrate-dump-restore

Comments

Markdown supported

Details

Author: microsoftdocs
Repository: microsoftdocs/agent-skills
Category: Data & databases
Installs: 63
GitHub stars: 796

Report

More skills

All skills

hyperframes-core

github.com/heygen-com

930.6k

The HyperFrames composition contract — build one renderable project. Use for composition structure, the `data-*` timing attributes, `class="clip"`, tracks, sub-compositions, variables, framework-owned media playback, deterministic-render rules, and validation. Also covers Tailwind projects and the STORYBOARD.md / SCRIPT.md plan formats. Read before writing composition HTML.

lark-base

open.feishu.cn

823.2k

Operate on Feishu Base: create tables, fields, records, and views; handle statistics, formulas/lookups, forms, dashboards, app mode (BaseApp/AppMode pages and components), Workspace directories, workflows, role permissions, and the template center (Base template categories, lists, and search). Use when encountering Base/multidimensional tables/bitable, BaseApp/AppMode, or /base/ or /app/ links. Do not use lark-apps for BaseApp; route file import/export to lark-drive and authentication/authorization to lark-shared.

lark-sheets

open.feishu.cn

821.8k

Feishu Spreadsheets: create and operate spreadsheets. Supports worksheets and row/column structures (add/delete/merge/size/hide/freeze/group), cell read/write (values/formulas/styles/comments/cell images), range copy/move/sort/fill, find and replace, bulk updates, and creating and maintaining objects such as charts, pivot tables, conditional formatting, filters and filter views, dropdown lists, sparklines, and floating images. Also supports formula validation, restoring historical versions, and importing/exporting local Excel/CSV files and Feishu spreadsheets. Use when users need to create or edit spreadsheets, summarize and visualize data, format spreadsheets, calculate formulas (including migrating Excel formulas), or build financial models (DCF, three statements, budgets, Sensitivity, etc.). For multidimensional tables (Base/bitable), use lark-base. If users want to search for spreadsheet files in cloud storage (Drive/cloud storage) by name or keyword, use lark-drive's drive +search to locate resources first. When users provide a doubao.com /sheets/ URL/token, use this skill directly; do not fall back to WebFetch because the domain is not Feishu. Routing is based on the URL path pattern and token, not the domain.

remotion-best-practices

github.com/remotion-dev

701.4k

Best practices and domain knowledge for building videos programmatically with Remotion (videos in React/TypeScript, rendered to MP4). Use whenever writing or editing Remotion code — scaffolding a video project, animating with interpolate/spring over useCurrentFrame(), sequencing scenes and transitions, captions/subtitles, audio, GIFs/Lottie/3D, charts, visual effects, dynamic duration via calculateMetadata, or rendering. Consult before reaching for a Remotion API, since its components and props evolve (e.g. @remotion/media).