SKILLEMALL.ai
GitHub ↗ RU Sign in

BB timeplus-sql-guide

Write and execute Timeplus streaming SQL for real-time analytics. Use this skill when the user wants to create streams, run streaming queries, build materialized views, ingest data, send data to sinks, write UDFs, or simulate data with random streams. Executes SQL via the ClickHouse-compatible HTTP interface on port 8123 using environment variables TIMEPLUS_HOST, TIMEPLUS_USER, and TIMEPLUS_PASSWORD. Covers full Timeplus SQL syntax including window functions, JOINs, CTEs, UDFs, data types, aggregations, and all DDL/DML statements.s

ClawHub Agent Skills author: Gang Tao v1.1.0 MIT-0 12 files body ≈ 2 415 tokens Open the sourceclawhub.ai↗ analyzed 3 d ago

As a process B 73/100 · Nearly there — weak spots: inputs and preconditions

GeneratorInfrastructureData and analyticstype and topics are labelled automatically from the skill text
Runs in: OpenClaw Claude / Claude Code ChatGPT / Codex Gemini CLI Cursor GitHub Copilot / VS Code Qwen Code Kimi Code CLI Z.ai (GLM) DeepSeek (Deep Code) Mistral Vibe LangChain (deepagents) Goose OpenCode
JSON
Technical rating
B
86/100
safety, quality, tests
Safety 60%
83
Quality 40%
91
Run on models
none yet
Process rating
B
73/100
Nearly there
Inputs and preconditions w 11
0
Tools and files w 18
60
Result and completion w 14
60
the three weakest of ten parameters · all ten

What is at stake

Medium-severity findings: the skill is probably honest, but read what alarmed the scanner.

Exfiltration medium severity

Below is the worst case for this category. The finding here is medium: the guard saw a sign, not a proof.

If you install

The instructions or scripts send data out: environment variables, keys, file contents, chat history. You may never notice, because the agent performs the upload as "part of the task".

For the author

If the upload is not needed for the task, remove it: catalogs flag such skills and delist them. If it is needed, name the destination explicitly, say what leaves the machine, and give the user a switch.

How to improve

    For the model run — optional
    • Your own cases (evals/evals.json, 4–6 real requests with expected answers): the full check would then run those instead of a model-drafted suite.
    • A spec.yaml with trigger phrases and assertions — a behaviour contract for CI; `skilltest init` writes a template.

    Guard findings · 5

    ✓ No critical or high findings

    Medium and low: 5
    • medium Exfiltration exfil-webhook-url references/ALERT.md:36
      Webhook / callback URL commonly used for exfiltration (verify the destination) (quoted — discussed, not commanded)
      "https://hooks.slack.com/services/T123/B456/other_id",
      quoted
    • medium Exfiltration exfil-webhook-url references/SINKS.md:167
      Webhook / callback URL commonly used for exfiltration (verify the destination) (quoted — discussed, not commanded)
      URL 'https://hooks.slack.com/services/xxx/yyy/zzz'
      quoted
    • medium Exfiltration exfil-webhook-url references/SINKS.md:238
      Webhook / callback URL commonly used for exfiltration (verify the destination) (quoted — discussed, not commanded)
      "url": "https://hooks.slack.com/services/xxx/yyy/zzz"
      quoted
    • low Exfiltration net-credential-use references/INGESTION.md:147
      Credential used in a network call (verify the destination is the intended service) (destination host is a configured variable)
      curl -s -X POST "http://${TIMEPLUS_USER}:${TIMEPLUS_PASSWORD}@${TIMEPLUS_HOST}:3218/proton/v1/ingest/streams/sensor_data" \
      variable host
    • low Secrets in code secret-aws-key references/SINKS.md:152
      AWS access key ID (placeholder value)
      aws_access_key_id     = 'AKIA…PLE',
      placeholder

    Files scanned: 12. Evidence is masked. Grey chips explain why severity was lowered.

    Against the Agent Skills spec

    ✓ No remarks against the Agent Skills spec

    Process rating: all ten parameters 73/100

    • 0Inputs and preconditions. Does not say what the process needs to start
    • 60Tools and files. Uses tools (bash, web, python) that frontmatter does not declare
    • 60Result and completion. Output format stated, no completion criterion
    • 70When it triggers. States when to use, but not when not to
    • 100Steps. 13 steps
    • 100Failures and branches. 1 branches, has a failure section
    • 100Consistency. Name and required fields are in place
    • 100Execution cost. Instruction body is 2415 tokens
    • 100Running it twice. Mutating operations check current state
    • 100Progress reporting. Reports progress

    Everything here is measured from the skill text rather than judged by a model, so the numbers are checkable. A parameter weighs more when it is a more common reason for the process to stall.

    Quality signals

    • +5Description has no quoted example phrases that should trigger the skill
    • +4Description does not say when NOT to use the skill (false activations)
    • +1No license
    • +2Single-language instructions
    • +3Description length 537: enough signal without eating the budget
    • +4Structure: 19 headings
    • +3Step-by-step instructions: 13 items
    • +3Output format is stated explicitly
    • +4Has examples (15 code blocks)
    • +4Reference files are cited in the instructions (10 of 10)

    Quality base 70; lint remarks subtract, signals add up to 100. Result: 91.

    External checks

    ClawHub: suspicious
    This skill is a real Timeplus SQL helper, but it can make persistent database changes, install server-side Python packages, run embedded code, and send data to outside services without strong user-confirmation guidance.
    LLM: suspicious (high) · VirusTotal: · 1 Jun 2026