文档

KWDB Intelligent Inspection

试用

Run KaiwuDB inspection and health-check tasks. Use this skill for database health checks, metrics collection, anomaly detection, and inspection report generation.

它能做什么

Run KaiwuDB inspection and health-check tasks. Use this skill for database health checks, metrics collection, anomaly detection, and inspection report generation.

技能文档

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.mddo 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.

相关技能

Convert natural language queries to KWDB SQL for time series data, relational data and cross-model analysis. Use this skill whenever users ask to query KWDB databases, write SQL for KWDB, or convert natural language to KWDB-specific SQL syntax. Supports: CREATE DATABASE/TABLE, downsampling, interpolation, latest value queries, aggregation analysis, cross-model queries, window/session/event analysis.

10 次安装

Automates end-to-end anomaly detection for time-series data stored in KaiwuDB / KWDB. Use this skill whenever the user mentions: - anomaly detection, outliers, or unusual patterns in KWDB / KaiwuDB time-series data - inspecting sensor metrics, IoT telemetry, or monitoring data for spikes, dips, or drift - "find anomalies", "detect outliers", "3-sigma check", "STL decomposition", or "time-series anomaly" - analyzing historical trends, abnormal points, or data quality issues in TS tables Even if the user does not explicitly say "anomaly", trigger this skill when they ask to inspect, validate, or flag unusual values in time-series columns (integer, float, double).

Optimize SQL query performance for KaiwuDB time-series and relational engines. Covers: EXPLAIN analysis, time-series optimization, pagination, cross-model queries. Trigger keywords: optimize query, slow query, explain, execution plan, performance, 性能, 查询优化. NOT for: DDL, schema design, deployment, DML writes.

Automated heterogeneous database migration skill for KaiwuDB / KWDB via KDTS REST API. Use this skill whenever the user mentions: - heterogeneous migration, cross-database migration, or data migration to KaiwuDB / KWDB - KDTS, migration tool, or data transfer between different databases - Specific source databases: MySQL, Oracle, PostgreSQL, SQL Server, ClickHouse, TDengine, InfluxDB, OpenTSDB, MongoDB, FTP, HDFS - Migration operations: create migration task, configure data source, test connection, import data, sync schema, batch migration - Migration management: query task status, view migration progress, check logs, kill migration, export/import config - Data type mapping, table structure sync, DDL generation, schema validation Even if the user does not explicitly say "migration", trigger this skill when they ask to transfer or sync data between databases with different engines.

Use when diagnosing KWDB incidents from logs, metrics, or system evidence, especially crashes, OOM, slow SQL, restarts, and cluster-wide availability symptoms.

Triggered when the user wants to install or deploy KaiwuDB (kwdb, kaiwudb). Helps users complete script-based deployment of KaiwuDB clusters, including configuration file modification, installation command execution, cluster initialization, and status checks.

10 次安装