360 Secure SkillHub
360 安全技能中心

ClickHouse

借助 OOMOL oo CLI 的 clickhouse 连接器操作 ClickHouse：可执行 SQL 查询、列出数据库与表、查看数据库和表结构。凭据由 OOMOL 服务端注入，用户无需处理 token；写操作与破坏性操作需先确认。首次使用需安装 CLI、登录并连接 ClickHouse。

oomol
oomol
热度 51.19
最近更新 2026-09-20 11:31:24
分类：数据依赖：代码执行 / 第三方 API应用场景：数据处理

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add oo-clickhouse
Metadata
name
oo-clickhouse
description
ClickHouse (clickhouse.com). Use this skill for ANY ClickHouse request — reading, creating, updating, and deleting data. Whenever a task involves ClickHouse, use this skill instead of calling the API directly.
allowed-tools
["Bash(oo *)"]
metadata
{"title":"ClickHouse","author":"OOMOL","version":"1.0.4","services":["clickhouse"],"icon":"https://static.oomol.com/logo/third-party/clickhouse.svg"}

ClickHouse

Operate ClickHouse through your OOMOL-connected account. This skill calls the clickhouse connector with the oo CLI; OOMOL injects credentials server-side, so you never handle raw tokens.

Running an action

Assume the user has already installed the oo CLI, signed in, and connected ClickHouse. Do not run oo auth login or open the connection URL proactively — just run the action. Fall back to First-time setup only when a command actually fails with an auth or connection error.

1. Inspect the contract to get the authoritative input/output schema before building a payload:

oo connector schema "clickhouse" --action "<action_name>"

2. Run the action with a JSON payload that matches the input schema:

oo connector run "clickhouse" --action "<action_name>" --data '<json>' --json
  • --data takes a JSON object string or @path/to/file.json; omit it to send {}.
  • The response is { "data": ..., "meta": { "executionId": "..." } }; the execution id lives under meta.executionId.

Each action is listed below with a one-line description; actions that change state carry a [write] or [destructive] tag. Before constructing --data, fetch the action's live schema with oo connector schema to get its authoritative input fields.

Available actions

  • execute_query — Execute a SQL query against a ClickHouse instance and return JSON rows. [destructive]
  • get_database_schema — Get an overview of one ClickHouse database with tables and optional column name lists.
  • get_table_schema — Get column metadata for one ClickHouse table.
  • list_databases — List databases available in the connected ClickHouse instance.
  • list_tables — List tables or views in ClickHouse databases.

Safety

  • Untagged actions are reads (get / list / search) — safe to run directly.
  • Actions tagged [write] change ClickHouse state — confirm the exact payload and effect with the user before running.
  • Actions tagged [destructive] remove or overwrite data — always confirm the target and get explicit approval first.

First-time setup

These are one-time steps — do not repeat them on every call. Run a step only when a command fails for the matching reason.

  • oo: command not found — install the oo CLI (other platforms: https://cli.oomol.com/install-guide.md):

    curl -fsSL https://cli.oomol.com/install.sh | bash    # macOS / Linux

    irm https://cli.oomol.com/install.ps1 | iex           # Windows PowerShell

  • Not signed in / authentication error — sign in to your OOMOL account once:

    oo auth login

  • scope_missing / credential_expired / app_not_ready / app_not_found — ClickHouse is not connected, or the connection expired or lacks a scope. Connect once (auth type: custom credential) at:

    https://console.oomol.com/app-connections?provider=clickhouse

  • HTTP 402 / OOMOL_INSUFFICIENT_CREDIT — billing stop. Recharge at https://console.oomol.com/billing/token-recharge before retrying.

Resources