菜单
ClickHouse columnar database — execute analytical SQL queries and batch inserts on ClickHouse. Supports query execution, batch transactions, and non-query operations via `robomotion clickhouse`. Do NOT use for PostgreSQL, MySQL, MongoDB, or other databases.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Production pipeline for interactive and generative visual art using p5.js. Creates browser-based sketches, generative art, data visualizations, interactive experiences, 3D scenes, audio-reactive visuals, and motion graphics — exported as HTML, PNG, GIF, MP4, or SVG. Covers: 2D/3D rendering, noise and particle systems, flow fields, shaders (GLSL), pixel manipulation, kinetic typography, WebGL scenes, audio analysis, mouse/keyboard interaction, and headless high-res export. Use when users request: p5.js sketches, creative coding, generative art, interactive visualizations, canvas animations, browser-based visual art, data viz, shader effects, or any p5.js project.
Airtable database client — manage records, tables, and bases in Airtable. Supports CRUD operations, formula-based search, bulk operations, and comments via `robomotion airtable`. Do NOT use for Google Sheets, Excel, Baserow, NocoDB, or other spreadsheet/database tools.
Apify web scraping platform — run Apify actors for large-scale crawling and data extraction. Supports actor execution, run monitoring, and dataset retrieval via `robomotion apify`. Do NOT use for simple HTML parsing or non-Apify scraping tools.
Apollo.io sales intelligence — search 265M+ contacts, enrich leads, manage contacts/accounts/deals. Supports people search, organization enrichment, and CRM operations via `robomotion apollo`. Do NOT use for HubSpot, Salesforce, or other CRM systems.
Baserow open-source database — manage rows, tables, and fields in self-hosted or cloud Baserow instances. Supports CRUD, filtering, sorting, search, and field listing via `robomotion baserow`. Do NOT use for Airtable, NocoDB, Google Sheets, or other no-code databases.
Binance cryptocurrency exchange — trade crypto, check prices, view balances, and access market data. Supports limit/market/stop orders, price history, deposits, and withdrawals via `robomotion binance`. Do NOT use for Gate.io, Coinbase, or other crypto exchanges.
| name | clickhouse |
| description | ClickHouse columnar database — execute analytical SQL queries and batch inserts on ClickHouse. Supports query execution, batch transactions, and non-query operations via `robomotion clickhouse`. Do NOT use for PostgreSQL, MySQL, MongoDB, or other databases. |
| version | 1.0.0 |
| author | robomotion |
| license | Apache-2.0 |
| tags | ["database","clickhouse","analytics","columnar","sql"] |
The robomotion clickhouse CLI connects to ClickHouse for analytical SQL workloads. It supports executing SELECT queries, running INSERT/UPDATE/DELETE statements, and batch transactions for atomically executing multiple SQL commands.
robomotion CLI installedrobomotion install clickhouseEach CLI command runs as a separate process — connection IDs from connect do NOT persist across calls.
You MUST use --session on connect and pass --session-id to all subsequent commands.
robomotion install clickhouserobomotion clickhouse connect --session --output json
# → {"outConnectionId":"<conn-id>","session_id":"<session-id>"}
conn-id and session-id in all subsequent commands:
robomotion clickhouse execute_query --conn-id "<conn-id>" --session-id "<session-id>" --output json
robomotion clickhouse disconnect --conn-id "<conn-id>" --session-id "<session-id>" --output json
Always append --output json to get structured JSON results.
robomotion clickhouse connect --session --output json
Connect to a ClickHouse database server using credentialsrobomotion clickhouse create_batch --conn-id --session-id "<session-id>" --output json
Create a new batch transaction for executing multiple SQL commands atomicallyrobomotion clickhouse disconnect --conn-id --session-id "<session-id>" --output json
Disconnect from a ClickHouse database server and release the connectionrobomotion clickhouse execute_non_query --conn-id --batch-id --session-id "<session-id>" --output json
Execute a SQL command (INSERT٫ UPDATE٫ DELETE٫ etc.) that does not return resultsrobomotion clickhouse execute_query --conn-id --batch-id --session-id "<session-id>" --output json
Execute a SQL SELECT query on ClickHouse and return the resultsrobomotion clickhouse send_batch --batch-id --output json
Commit a batch transaction and execute all queued SQL commands