kwdb-intelligent-inspection

name	kwdb-intelligent-inspection
description	Run KaiwuDB inspection and health-check tasks. Use this skill for database health checks, metrics collection, anomaly detection, and inspection report generation.
triggers	["show me all database metrics","database metrics for my KWDB cluster","kwdb cluster metrics","check database health","inspect KWDB cluster","database health check","collect database metrics","kwdb inspection","巡检","数据库指标","查看数据库指标","检查数据库健康"]

Critical Constraints (non-negotiable)

❝ Never skip Step 1. Collecting metrics before confirming node addresses, ports, and inspection scope with the user is forbidden. The inspection must not proceed until the user explicitly confirms the node addresses, ports, and inspection scope. ❞

❝ Never call a script without reading its usage doc first. Before running any script under scripts/, you MUST read the corresponding references/*-script-usage.md file. This is the only way to know the correct parameters, defaults, and required arguments. Guessing parameters is forbidden. ❞

❝ Anomaly rules are user-driven. If user does not request alerting, skip alerting. If user requests alerting without specific thresholds, apply default rules from references/anomaly-rules.md. If user provides custom thresholds, use those instead. ❞

Workflow

Step 1: Confirm target and scope

Before collecting any metrics, follow references/inspection-requirements-confirmation.md EXACTLY in order:

1. Parse user intent → confirm target (host, ports)
2. Probe connectivity → verify ports reachable (see references/inspection-port-listening-reference.md)
3. TLS mode detection → determine if inspection supported
4. Present scope menu → user confirms before proceeding

Step 2: Collect metrics

MANDATORY: Read the script usage doc BEFORE calling any script.

• references/ts-metrics-script-usage.md — for get_kwdb_ts_metrics.py
• references/statements-script-usage.md — for get_kwdb_statements.py

Do not call any script without first reading its usage doc. Verify the parameter names, required arguments, and defaults match what you are about to pass.

• Port listener status: Use Step 1 connectivity probe results.
• Most metrics: Use scripts/get_kwdb_ts_metrics.py per references/ts-metrics-script-usage.md.
• Slow queries: Use scripts/get_kwdb_statements.py per references/statements-script-usage.md.

Step 3: Apply anomaly rules

Apply anomaly judgment rules only when user requests alerting. See references/anomaly-rules.md for default rules and configurable rules.

Step 4: Generate report

Produce a Markdown inspection report with metric values, anomaly judgments, and data-source notes per references/output-rules.md.

Anomaly Rules

See references/anomaly-rules.md for default rules and configurable rules.

Output Rules

See references/output-rules.md — do not deviate from these rules when producing any inspection report.

Limitations

• Windows is not supported: This skill does not support Windows operating systems.
• TLS mode inspection is not supported: This skill does not support inspecting KaiwuDB deployed with TLS mode enabled.