KWDB

KaiwuDB 数据库源码编译和构建技能。用于从源码构建、编译或测试 KaiwuDB (KWDB)。使用 CMake 构建系统处理构建配置、单元测试、代码检查和安装。触发条件：(1) 编译询问："编译 KaiwuDB"、"构建 kwdbts2"、"cmake 构建"、"清理构建"；(2) C++ 单元测试询问："C++ 单元测试"、"运行C++单元测试"、"run C++ unittest"；(3) Go 单元测试询问："golang 单元测试"、"Go 单元测试"、"run golang test"。重要：执行任何操作前必须向用户确认所有配置选项，不得跳过询问步骤。

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.

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

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

Describe what the skill does and when it should trigger.

Design KWDB schemas and minimal DDL for relational, time-series, and mixed workloads.

Use when users want to create a new skill or improve an existing one, especially when they need help defining scope, choosing a skill pattern, designing activation boundaries, structuring references or scripts, or validating the final package.

Use when CI or local verification fails in this KWDB repository and the first goal is to classify the failure, identify the most likely module, pick the first files to inspect, and choose the smallest reproduction command before attempting a fix

KWDB-specific code review skill. Reviews current git changes (C++ / Go) focusing on database-specific risks: persistence correctness, concurrency safety, SQL/TS semantics, cross-module contracts, error code mapping, compatibility, and performance regression. Triggers on: code review, PR review, code quality check, reviewing changes. Covers: Go (kwbase/) and C++ (common/ + kwdbts2/) code review.

Use when the user requests writing functional specifications, design documents, PRDs, technical design documents, or needs to analyze KWDB database requirements.

Use when the user asks to investigate KWDB performance via TSBS workloads. Routes to tsbs-benchmark for standard benchmarks, and coordinates tsbs-benchmark + perf-event-profiling pipelines for hotspot analysis. Currently only supports TSBS-based performance analysis. Do not use for general JDBC tests, SQL correctness tests, or non-TSBS performance issues.

Code refactoring for the KWDB database repository (Go/C++). Covers planning, complexity reduction, code smell elimination, and behavior-preserving verification.

MUST USE this skill for ANY Go unit test task in KWDB — even a simple "generate a _test.go" or "add tests" request. Covers file naming, 单元测试 conventions, package foo vs foo_test, leaktest goroutine detection, table-driven give/want tests with t.Run, testutils.IsError error assertions, testutils.SucceedsSoon async helpers, skip.UnderShort/UnderRace, TestMain + serverutils.InitTestServerFactory, StartServer for in-process SQL tests, testcluster.New for multi-node cluster tests, benchmark templates, testdata directories, and Makefile targets (test/testshort/testrace/stress/bench). Trigger whenever user says 单元测试/单测/测试文件/测试/unit test, references _test.go files, asks about testing conventions, or needs to write/generate/add tests for any Go code under kwbase/. Even for trivial one-file requests, the skill enforces leaktest, table-driven patterns, and proper error assertions. Covers kwdbts2 Google Test conventions as well.

Use when profiling a running server process with Linux perf — capturing performance events (cycles, cache-misses, instructions) while a client script triggers the workload, then analyzing perf.data for hot functions and hardware event metrics. Profiling and analysis can be invoked independently or combined.

Use when running KWDB local TSBS benchmark workflows. Covers two entry points: the full-pipeline qa/run_tsbs_test.sh for standard benchmarks, and the scripts under .agents/skills/tsbs-benchmark/scripts/ for workload setup (called by the kwdb-perf-investigation orchestrator). Do not use for general JDBC tests, SQL correctness tests, or non-TSBS performance issues.

Interactively guide users through the KWDB SampleDB project demos. Use when users ask to quickly experience, run, test, demonstrate, or learn this repository's examples, including smart-meter, multi-mode, window functions, or aggregate functions, on either a local/bare-metal KWDB binary or a Docker/container KWDB deployment. This skill must inspect the environment, prepare or start KWDB, ask which example to run, ask before each step, explain every step and concept, offer both full query.sh and single-query demo options, summarize results, return to example selection, and clean up temporary kwbase-data directories when the user stops.

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