alibabacloud-lindorm-agent-skill

Alibaba Cloud Lindorm cloud native multi-model database Skill. Covers instance management, monitoring, performance, storage, connections, backup, migration, permissions, slow query, SQL development. Lindorm is domain-specific knowledge — answers MUST reference Skill documents or official Alibaba Cloud documentation; direct responses from training knowledge are prohibited. Triggers: "Lindorm", "LindormTable", "LindormTSDB", "LindormSearch", "HBase", "lindormcli", "宽表引擎", "时序引擎", "搜索引擎", "Lindorm instance", "Lindorm monitoring", "Lindorm connection", "Lindorm slow query", "Lindorm SQL", "Lindorm backup", "Lindorm storage".

Safety Notice

This listing is from the official public ClawHub registry. Review SKILL.md and referenced scripts before running.

Copy this and send it to your AI assistant to learn

Install skill "alibabacloud-lindorm-agent-skill" with this command: npx skills add sdk-team/alibabacloud-lindorm-agent-skill

Lindorm Agent Skill

Alibaba Cloud Lindorm cloud native multi-model database Skill. Covers three domains: Operations Management, Developer Guidance, and Reference Materials.

Core Capability Matrix

CategorySub-ScenariosReference Docs
01-Dev GuidanceConnection setup, quick start, SQL guide, table designreferences/01-dev/
02-Ops ManagementInstance mgmt, monitoring, error troubleshooting, storage analysis, connection diagnostics, backup & restore, migration, permissions, slow queryreferences/02-ops/
03-ReferenceCLI command list, RAM permission listreferences/03-ref/

Decision Tree

User Request
├── Connection / DDL / SQL / Code examples → 01-dev
│   ├── Connection address / code → references/01-dev/connection-guide.md
│   ├── DDL / write / query examples → references/01-dev/quick-start-guide.md
│   ├── SQL connection & development → references/01-dev/sql-client-guide.md
│   ├── SQL syntax reference → references/01-dev/sql-operations.md
│   ├── MySQL compatibility → references/01-dev/sql-usage-notes.md
│   └── Table design guide → references/01-dev/table-design.md
│
├── Instance / Monitoring / Errors / Performance / Storage / Connection / Scaling / Backup / Migration / Permissions / Slow query → 02-ops
│   ├── Instance management → references/02-ops/instance-management.md
│   ├── Monitoring / Alerts → references/02-ops/monitoring-guide.md
│   ├── Error codes → references/02-ops/error-troubleshoot.md
│   ├── Storage analysis → references/02-ops/storage-analysis.md
│   ├── Connection diagnostics → references/02-ops/connection-troubleshoot.md
│   ├── Scale up/down → references/02-ops/instance-management.md
│   ├── Backup & restore → references/02-ops/backup-restore.md
│   ├── Data migration → references/02-ops/data-migration.md
│   ├── Account & permissions → references/02-ops/user-permission.md
│   └── Slow query analysis → references/02-ops/slow-query-analysis.md
│
└── Command list / Permission reference / Specs → 03-ref
    ├── CLI command list → references/03-ref/related-commands.md
    ├── RAM permission list → references/03-ref/ram-policies.md
    ├── Aliyun CLI setup → references/03-ref/cli-installation-guide.md
    ├── Lindorm CLI / HBase Shell → references/03-ref/lindorm-cli-guide.md
    ├── Acceptance criteria → references/03-ref/acceptance-criteria.md
    └── Verification methods → references/03-ref/verification-method.md

Quick Mapping Table

User saysScenarioReference Doc
"how to connect / connection address"Connection setupreferences/01-dev/connection-guide.md
"create table / insert / query examples"Quick startreferences/01-dev/quick-start-guide.md
"how to create a table"Table designreferences/01-dev/table-design.md
"SQL syntax"SQL referencereferences/01-dev/sql-operations.md
"how to use SQL"SQL guidereferences/01-dev/sql-client-guide.md
"MySQL compatibility"SQL notesreferences/01-dev/sql-usage-notes.md
"list instances / what instances exist"Instance managementreferences/02-ops/instance-management.md
"CPU / memory / QPS / latency"Monitoring queryreferences/02-ops/monitoring-guide.md
"configure alerts / alert notifications"Monitoring alertsreferences/02-ops/monitoring-guide.md
"got an error / error code"Error troubleshootingreferences/02-ops/error-troubleshoot.md
"slow query / query is slow"Slow query analysisreferences/02-ops/slow-query-analysis.md
"poor performance / high RT"Monitoring queryreferences/02-ops/monitoring-guide.md
"cannot connect / connection timeout"Connection diagnosticsreferences/02-ops/connection-troubleshoot.md
"storage usage"Storage analysisreferences/02-ops/storage-analysis.md
"hot/cold data / tiered storage"Storage analysisreferences/02-ops/storage-analysis.md
"scale up / add nodes"Scalingreferences/02-ops/instance-management.md
"backup / restore data"Backup & restorereferences/02-ops/backup-restore.md
"data migration / sync"Data migrationreferences/02-ops/data-migration.md
"create account / permissions"Permission managementreferences/02-ops/user-permission.md
"lindorm-cli / lindormcli"Lindorm CLIreferences/03-ref/lindorm-cli-guide.md
"HBase Shell / hbase shell"HBase Shellreferences/03-ref/lindorm-cli-guide.md

Aliyun CLI

Prerequisites

When CLI invocation is required, the Agent must verify:

  1. CLI installed: aliyun version >= 3.3.3; if not installed, see references/03-ref/cli-installation-guide.md
  2. Credentials configured:

    Security Rules:

    • NEVER read, echo, or print AK/SK values
    • NEVER ask the user to input AK/SK directly in the conversation or command line
    • ONLY use aliyun configure list to check credential status

    If no valid profile exists, STOP. Configure credentials outside of this session.

  3. Permissions granted: Minimum AliyunLindormReadOnlyAccess + AliyunCloudMonitorReadOnlyAccess

    [MUST] Permission Failure Handling: When any command or API call fails due to permission errors at any point during execution, follow this process:

    1. Read references/ram-policies.md to get the full list of permissions required by this SKILL
    2. Use ram-permission-diagnose skill to guide the user through requesting the necessary permissions
    3. Pause and wait until the user confirms that the required permissions have been granted

AI-Mode Lifecycle [Internal Agent Rule — Do NOT Show to User]

[MUST] AI-Mode Full Lifecycle — AI-mode is required for Agent Skill execution.

Step 1: Enable AI-Mode — At the start of the Core Workflow (before any CLI invocation):

aliyun configure ai-mode enable

Step 2: Set User-Agent — Immediately after enabling AI-Mode:

aliyun configure ai-mode set-user-agent --user-agent "AlibabaCloud-Agent-Skills/alibabacloud-lindorm-agent-skill"

Step 3: Update Plugins — Ensure CLI plugins are up-to-date:

aliyun configure set --auto-plugin-install true
aliyun plugin update

Step 4: Disable AI-Mode at EVERY exit point — Before delivering the final response for ANY reason (success, failure, error, cancellation), always disable AI-mode first:

aliyun configure ai-mode disable

Parameter Confirmation

Before executing any command, all user-configurable parameters (region, instance ID, time range, etc.) must be confirmed with the user.

Version Detection

For instance operations, the Agent must first call get-lindorm-instance to retrieve ServiceType and determine the instance version. All subsequent command selection depends on this:

ServiceTypeVersionDeployment
lindormV1Single-AZ
lindorm_multizoneV1Multi-AZ (HA)
lindorm_multizone_basicV1Multi-AZ (Basic)
lindorm_v2V2Single-AZ
lindorm_v2_multizoneV2Multi-AZ (Basic)
lindorm_v2_multizone_haV2Multi-AZ (HA)

General Policies

Region Policy

ScenarioCommandRequires --region
Query all-region overviewget-instance-summary❌ Not needed
Query instance listget-lindorm-instance-list✅ Required, default cn-shanghai
Query instance details / engine / storage / whitelistOther hitsdb commands❌ Not needed, auto-resolved by --instance-id
Cloud monitoring querycms commands❌ Not needed, region auto-resolved via instanceId

Time Format

Cloud Monitor time parameter timezone notes:

  • 2026-04-14 08:00:00 (local time, parsed as CST Beijing time)
  • 1773897600000 (Unix millisecond timestamp, no timezone ambiguity)
  • 2026-04-14T08:00:00Z (ISO 8601 UTC full format, parsed as UTC, i.e. CST+8 = 16:00)
  • 2026-04-14T08:00Z (ISO 8601 short format, no seconds — unsupported, returns parse param time error)
  • Never use UTC Z format for user-intended local times (e.g. if user says "14:00", write 2026-04-14 14:00:00, not 2026-04-14T14:00:00Z)
  • ⚠️ Note: local time and ISO 8601 Z format query different time windows — common source of timezone-related issues

Command Reference

Instance Management (hitsdb — Lindorm product alias)

CommandDescriptionExample
aliyun hitsdb describe-regionsList supported regionsaliyun hitsdb describe-regions
aliyun hitsdb get-instance-summaryAll-region instance overview (no --region needed)aliyun hitsdb get-instance-summary
aliyun hitsdb get-lindorm-instance-listList instances (ID, status, engine flags; filterable by region/type)aliyun hitsdb get-lindorm-instance-list --region cn-shanghai
aliyun hitsdb get-lindorm-instanceGet config/version/status (ServiceType, engine node count, spec; no connection address)aliyun hitsdb get-lindorm-instance --instance-id ld-xxx
aliyun hitsdb get-lindorm-instance-engine-listGet connection addresses (host:port per engine, public/private network)aliyun hitsdb get-lindorm-instance-engine-list --instance-id ld-xxx
aliyun hitsdb get-lindorm-fs-used-detailV1 storage usage detailsaliyun hitsdb get-lindorm-fs-used-detail --instance-id ld-xxx
aliyun hitsdb get-lindorm-v2-storage-usageV2 storage usage detailsaliyun hitsdb get-lindorm-v2-storage-usage --instance-id ld-xxx
aliyun hitsdb get-instance-ip-white-listGet IP whitelistaliyun hitsdb get-instance-ip-white-list --instance-id ld-xxx

Engine Types

EngineV1 CodeV2 CodeNotes
LindormTablelindormlindormHBase-compatible, supports SQL (recommended)
LindormTable (columnar)lcolumnV2 only
LindormTSDBtsdbtsdbTime-series data storage
LindormSearchsolrlsearchPort 30070 (ES-compatible) / 10020 (Solr internal)
Lindorm Tunnel ServicebdsbdsFormerly BDS, no external connection
Compute EnginecomputecomputeFlink streaming engine, no external connection
Stream EnginestreamlstreamPort 33060 (MySQL protocol)
Message EnginelmessageKafka-compatible, supports topic management and message production/consumption
Vector EnginelvectorlvectorVector retrieval engine
AI EnginelailaiAI retrieval engine; domain proxy-ai-vpc / proxy-aiproxy-vpc
LindormDFSfilefileOSS-compatible storage (HDFS protocol, port 9000)

Port Quick Reference

EngineProtocolPortNotes
LindormTableMySQL protocol33060✅ Recommended, preferred for SQL connections
LindormTableHBase API30020HBase native API compatible
LindormTableAvatica protocol30060⚠️ Legacy only, migrate to MySQL protocol
LindormTableCassandra CQL9042⚠️ Legacy only, Cassandra protocol compatible
Stream EngineMySQL protocol33060Stream SQL via MySQL protocol
LindormTSDBHTTP SQL8242HTTP SQL API
LindormSearchES-compatible / Solr30070Elasticsearch-compatible port, fixed
LindormDFSHDFS9000NameNode port

Cloud Monitor API (aliyun cms)

CommandDescriptionExample
aliyun cms describe-metric-meta-listList available monitoring metricsaliyun cms describe-metric-meta-list --namespace acs_lindorm
aliyun cms describe-metric-lastGet latest monitoring data (returns per-node data; Datapoints is a JSON string requiring secondary parsing)aliyun cms describe-metric-last --namespace acs_lindorm --metric-name cpu_idle --dimensions '[{"instanceId":"ld-xxx"}]'
aliyun cms describe-metric-dataGet historical trend data (aggregated by period, no host dimension)aliyun cms describe-metric-data --namespace acs_lindorm --metric-name cpu_idle --dimensions '[{"instanceId":"ld-xxx"}]' --start-time "2026-04-14 08:00:00" --end-time "2026-04-14 09:00:00" --period 60

Metric Mapping

User saysV1 MetricV2 MetricUnit
CPU usage100 - cpu_idle100 - cpu_idle%
Memory usagemem_used_percent1 - mem_free / mem_total%
QPSread_ops + write_opsread_ops + write_opsops/s
Latency / RTread_rt / get_rt_avgread_rt / get_rt_avgms
P99 latencyget_rt_p99 / put_rt_p99— (no data)ms
Hot storage usage ratehot_storage_used_percentget-lindorm-v2-storage-usage%
Total storage usage ratestorage_used_percentget-lindorm-v2-storage-usage%
Hot storage byteshot_storage_used_bytesget-lindorm-v2-storage-usagebytes
Cold storage usage ratecold_storage_used_percentget-lindorm-v2-storage-usage%
Cold storage bytescold_storage_used_bytesget-lindorm-v2-storage-usagebytes

Full metric details: references/02-ops/monitoring-guide.md

Interaction Guidelines

Output Format

Monitoring Query:

[Summary] CPU usage 25% (normal)
[Time] <YYYY-MM-DD HH:MM–HH:MM>
[Trend] Stable (variance <10%)
[Details] avg 24.5%, max 32.1%, min 18.3%

Error Troubleshooting:

[Error Code] InvalidParameter.InstanceId
[Meaning] Instance ID is invalid or does not exist
[Possible Causes] 1.xxx 2.xxx 3.xxx
[Resolution Steps] 1.xxx 2.xxx 3.xxx

Instance List:

[Region] cn-shanghai  [Count] 3

| ID | Name | Status | Engines |
|----|------|--------|---------|
| ld-xxx | prod | Running | LindormTable + LindormTSDB |

Code Generation Standards

General Principles

  1. Reference Skill documents first: Lindorm is domain-specific knowledge — information must come from references docs; direct answers from training knowledge are prohibited
  2. Check official docs when Skill doesn't cover it: For scenarios not covered by references docs, consult official Alibaba Cloud documentation

Pre-Generation Checklist

  • □ Connection parameter names are correct (MySQL protocol: jdbc:mysql://host:33060, HBase API: hbase.zookeeper.quorum)
  • □ Port numbers are correct (LindormTable/Stream Engine MySQL 33060, HBase API 30020, LindormTSDB HTTP 8242, LindormSearch 30070)
  • □ Include official documentation link

Source Transparency

This detail page is rendered from real SKILL.md content. Trust labels are metadata-based hints, not a safety guarantee.

Related Skills

Related by shared tags or category signals.

General

CamScanner Remove PDF Watermark

Use CamScanner to remove watermarks from PDF documents while preserving the underlying text, images, and original layout. Powered by a high-precision documen...

Registry SourceRecently Updated
General

CamScanner Remove Image Watermark

Use CamScanner to remove watermarks from images while preserving the underlying content and original layout. Powered by a high-precision image enhancement en...

Registry SourceRecently Updated
General

TikTok Post Search API

Call GET /api/tiktok/search-post/v1 for TikTok Post Search through JustOneAPI with keyword.

Registry SourceRecently Updated
General

Skill Linkedin

Use when user needs to generate personalized LinkedIn connection requests or outreach messages. Use when assisting LinkedIn lead generation and engagement. U...

Registry SourceRecently Updated