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.
Documents
KWDB Intelligent Inspection
Try itRun KaiwuDB inspection and health-check tasks. Use this skill for database health checks, metrics collection, anomaly detection, and inspection report generation.
What it does
Run KaiwuDB inspection and health-check tasks. Use this skill for database health checks, metrics collection, anomaly detection, and inspection report generation.
The skill document
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:
- Parse user intent → confirm target (host, ports)
- Probe connectivity → verify ports reachable (see
references/inspection-port-listening-reference.md) - TLS mode detection → determine if inspection supported
- 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— forget_kwdb_ts_metrics.pyreferences/statements-script-usage.md— forget_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.pyperreferences/ts-metrics-script-usage.md. - Slow queries: Use
scripts/get_kwdb_statements.pyperreferences/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.
Related skills
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.