Claim this agent
agentCLAWHUBUnverified

ClickHouse

Inspect ClickHouse databases, review schemas, and run SQL analytics queries via the ClickHouse HTTP API. Use this skill when users want to query analytics da... Skill: ClickHouse Owner: hith3sh Summary: Inspect ClickHouse databases, review schemas, and run SQL analytics queries via the ClickHouse HTTP API. Use this skill when users want to query analytics da... Tags: latest:1.0.5 Version history: v1.0.5 | 2026-06-09T07:05:15.678Z | user Add UTM attribution tags (utm_source=clawhub) to ClawLink branding links so visits from this skill page are tracked as a distinct traffic so

OpenClaw

Rank

62

Safety

84

Downloads

2.6k

Updated

Oct 9, 2026

Version

1.0.5

Source

CLAWHUB

About

What it does, and when to use it.

Capability contract not published. No trust telemetry is available yet. 2.6K downloads reported by the source. Last updated 10/9/2026.

Avoid when

  • Contract metadata is missing or unavailable for deterministic execution.

Risk flags: missing_or_unavailable_contract, trust_data_unavailable, schema_references_missing

Public facts

Every fact links back to the source it came from.

Vendor
Clawhubvendor · observed Oct 9, 2026
Protocol compatibility
OpenClawcompatibility · observed Oct 9, 2026
Adoption signal
2.6K downloadsadoption · observed Oct 9, 2026
Latest release
1.0.5release · observed Jun 9, 2026
Handshake status
UNKNOWNsecurity

Install and run

Setup complexity: low.

clawhub skill install s173vws87a7ss71xf9rq53k5gd8568kv:clickhouse-analytics
  1. Setup complexity is classified as HIGH. You must provision dedicated cloud infrastructure or an isolated VM. Do not run this directly on your local workstation.
  2. Final validation: Expose the agent to a mock request payload inside a sandbox and trace the network egress before allowing access to real customer data.

Contract: missing

curl -s "https://www.xpersona.co/api/v1/agents/clawhub-hith3sh-clickhouse-analytics/snapshot"

Documentation

CLAWHUB

75,718 characters of source documentation, loaded on request.

Extracted files

3 files captured from the source.

SKILL.md

---
name: clickhouse-analytics
description: Inspect ClickHouse databases, review schemas, and run SQL analytics queries via the ClickHouse HTTP API. Use this skill when users want to query analytics data, explore database schemas, or run read-only SQL queries for business intelligence.
---

# ClickHouse

![ClickHouse](https://raw.githubusercontent.com/ClawLink-HQ/clawlink/main/public/images/brand-logos/clickhouse.svg)

Work with ClickHouse from chat — inspect databases, review schemas, and run read-only SQL analytics queries via the ClickHouse HTTP API with API key authentication.

This skill uses [ClawLink](https://claw-link.dev/?utm_source=clawhub&utm_medium=referral&utm_content=clickhouse-analytics) for hosted connection flows and credentials so you do not need to configure ClickHouse API access yourself.

### Setup in 3 Steps

| Step 1: Install | Step 2: Pair Account | Step 3: Connect ClickHouse |
|:---:|:---:|:---:|
| ![Install](https://raw.githubusercontent.com/ClawLink-HQ/clawlink/main/public/images/pairing/initialstep_1.gif) | ![Pair](https://raw.githubusercontent.com/ClawLink-HQ/clawlink/main/public/images/approve_process.gif) | *App-specific connection GIF coming soon* |
| Run the install command in OpenClaw | Sign in and approve the device | Open the dashboard and connect ClickHouse |

## How It Works

```
┌─────────────────┐     ┌──────────────┐     ┌──────────────────┐
│   OpenClaw      │────▶│   ClawLink   │────▶│ ClickHouse HTTP API│
│   (User Chat)   │     │   (API Key)  │     │ (SQL Queries)    │
└─────────────────┘     └──────────────┘     └──────────────────┘
         │                       │                       │
         │  1. Install Plugin    │                       │
         │  2. Pair Device       │                       │
         │  3. Connect ClickHouse│                       │
         │                       │  4. Secure Key │
         │                       │  5. Proxy Requests    │
         │                       │                       │
         ▼                       ▼                       ▼
   ┌──────────┐           ┌──────────┐           ┌──────────┐
   │  SKILL   │           │ Dashboard│           │ ClickHouse│
   │  File    │           │ Auth     │           │ Queries  │
   └──────────┘           └──────────┘           └──────────┘
```

## Install

Install the verified ClawLink plugin from ClawHub. After the user confirms, complete the full setup so ClawLink tools are visible in the next OpenClaw chat.

```bash
openclaw plugins install clawhub:clawlink-plugin
openclaw config set tools.alsoAllow '["clawlink-plugin"]' --strict-json
openclaw gateway restart
```

Then tell the user: "OpenClaw has been restarted. Send `/new` as a standalone message to start a fresh chat, then ask for ClickHouse again."

## Quick Start

```bash
# List databases
clawlink_call_tool --tool "clickhouse_list_databases" --params '{}'

# List tables in a database
clawlink_call_tool --tool "clickhouse_list_tables" --params '{"data

_meta.json

{
  "ownerId": "kn713pxvayh8fjhb503zjb8yxh815j54",
  "slug": "clickhouse-analytics",
  "version": "1.0.5",
  "publishedAt": 1780988715678
}

skill-card.md

## Description:

Inspect ClickHouse databases, review schemas, and run SQL analytics queries via the ClickHouse HTTP API.

This skill is ready for commercial/non-commercial use.

## Publisher:

[hith3sh](https://clawhub.ai/user/hith3sh)

### License/Terms of Use:

MIT-0

## Use Case:

Developers, data analysts, and analytics engineers use this skill to discover ClickHouse schemas, inspect tables, and run read-only SQL analytics queries from an agent workflow.

### Deployment Geography for Use:

Global

## Known Risks and Mitigations:

Risk: The skill uses ClawLink to store ClickHouse connection details and mediate queries and results.

Mitigation: Review ClawLink credential handling and revocation processes before installation.

Risk: Database queries can expose sensitive data or consume excessive ClickHouse resources if account permissions are broad.

Mitigation: Use a dedicated ClickHouse account with server-enforced read-only permissions, minimal database and table access, and query or resource limits.

Risk: Large result sets or expensive queries can affect performance.

Mitigation: Explore schemas first, keep queries targeted with WHERE clauses and LIMIT, and require user confirmation for large result sets or expensive queries.

## Reference(s):

- [ClawHub Skill Page](https://clawhub.ai/hith3sh/skills/clickhouse-analytics)
- [ClickHouse Documentation](https://clickhouse.com/docs)
- [ClickHouse SQL Reference](https://clickhouse.com/docs/en/sql-reference/)
- [ClawLink](https://claw-link.dev/?utm_source=clawhub&utm_medium=referral&utm_content=clickhouse-analytics)
- [ClawLink Docs](https://docs.claw-link.dev/openclaw)

## Skill Output:

**Output Type(s):** [markdown, shell commands, configuration, guidance, API calls]

**Output Format:** [Markdown with inline bash and JSON command examples]

**Output Parameters:** [1D]

**Other Properties Related to Output:** [Outputs guide schema discovery, connection checks, and read-only query execution through ClawLink tools.]

## Skill Version(s):

1.0.5 (source: ClawHub release evidence)

## Ethical Considerations:

Users should evaluate whether this skill is appropriate for their environment, review any generated or modified files before relying on them, and apply their organization's safety, security, and compliance requirements before deployment.
Github ReposUpdated 6mo agoRank 70

activepieces

AI Agents & MCPs & AI Workflow Automation • (~400 MCP servers for AI agents) • AI Automation / AI Agent with MCPs • AI Workflows & AI Agents • MCPs for AI Agents

OPENCLAW
Github ReposUpdated 6mo agoRank 70

cherry-studio

AI productivity studio with smart chat, autonomous agents, and 300+ assistants.

MCPOPENCLAW
Github ReposUpdated 6mo agoRank 70

AionUi

Free, local, open-source 24/7 Cowork app and OpenClaw for Gemini CLI, Claude Code, Codex, OpenCode, Qwen Code, Goose CLI, Auggie, and more | 🌟 Star if you like it!

MCPOPENCLAW
Github ReposUpdated 7mo agoRank 70

CopilotKit

The Frontend for Agents & Generative UI. React + Angular

OPENCLAW

Machine-readable data

The same record, as JSON, for agents and crawlers.

{
  "facts": [
    {
      "factKey": "vendor",
      "category": "vendor",
      "label": "Vendor",
      "value": "Clawhub",
      "href": "https://clawhub.ai/hith3sh/skills/clickhouse-analytics",
      "sourceUrl": "https://clawhub.ai/hith3sh/skills/clickhouse-analytics",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-09T13:35:02.926Z",
      "isPublic": true
    },
    {
      "factKey": "protocols",
      "category": "compatibility",
      "label": "Protocol compatibility",
      "value": "OpenClaw",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-hith3sh-clickhouse-analytics/contract",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-hith3sh-clickhouse-analytics/contract",
      "sourceType": "contract",
      "confidence": "medium",
      "observedAt": "2026-10-09T13:35:02.926Z",
      "isPublic": true
    },
    {
      "factKey": "traction",
      "category": "adoption",
      "label": "Adoption signal",
      "value": "2.6K downloads",
      "href": "https://clawhub.ai/hith3sh/clickhouse-analytics",
      "sourceUrl": "https://clawhub.ai/hith3sh/clickhouse-analytics",
      "sourceType": "profile",
      "confidence": "medium",
      "observedAt": "2026-10-09T13:35:02.926Z",
      "isPublic": true
    },
    {
      "factKey": "latest_release",
      "category": "release",
      "label": "Latest release",
      "value": "1.0.5",
      "href": "https://clawhub.ai/hith3sh/clickhouse-analytics",
      "sourceUrl": "https://clawhub.ai/hith3sh/clickhouse-analytics",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-06-09T07:05:15.678Z",
      "isPublic": true
    },
    {
      "factKey": "handshake_status",
      "category": "security",
      "label": "Handshake status",
      "value": "UNKNOWN",
      "href": "https://www.xpersona.co/api/v1/agents/clawhub-hith3sh-clickhouse-analytics/trust",
      "sourceUrl": "https://www.xpersona.co/api/v1/agents/clawhub-hith3sh-clickhouse-analytics/trust",
      "sourceType": "trust",
      "confidence": "medium",
      "observedAt": null,
      "isPublic": true
    }
  ],
  "events": [
    {
      "eventType": "release",
      "title": "Release 1.0.5",
      "description": "Add UTM attribution tags (utm_source=clawhub) to ClawLink branding links so visits from this skill page are tracked as a distinct traffic source.",
      "href": "https://clawhub.ai/hith3sh/clickhouse-analytics",
      "sourceUrl": "https://clawhub.ai/hith3sh/clickhouse-analytics",
      "sourceType": "release",
      "confidence": "medium",
      "observedAt": "2026-06-09T07:05:15.678Z",
      "isPublic": true
    }
  ]
}

Record generated Oct 9, 2026.

Sponsored

Ads related to ClickHouse and adjacent AI workflows.