clickhouse-best-practices
Pass
Audited by Gen Agent Trust Hub on Sep 14, 2026
Risk Level: SAFEEXTERNAL_DOWNLOADSCOMMAND_EXECUTIONINDIRECT_PROMPT_INJECTION
Full Analysis
- [SAFE]: The skill focuses on providing legitimate technical guidance and enforces security best practices for database interactions. It specifically includes a safety rule (
agent-query-safety.md) to prevent resource exhaustion and unbounded queries. - [EXTERNAL_DOWNLOADS]: The skill references official ClickHouse resources and tools. It suggests the installation of
mcp-clickhouse(a Python package) and connects tomcp.clickhouse.cloudand other vendor-owned subdomains. These resources are scoped to the vendor's own infrastructure. - [COMMAND_EXECUTION]: The instructions provide templates for executing
clickhouse-clientandcurlto interact with ClickHouse clusters. These are the intended primary functions of the skill and include recommended safety settings likemax_execution_timeandmax_rows_to_read. - [INDIRECT_PROMPT_INJECTION]: The skill has an ingestion surface for potentially untrusted data through database metadata and query results.
- Ingestion points: Data enters the agent context via
system.columns,system.tables, and the results of arbitrarySELECTqueries. - Boundary markers: The skill uses standard markdown formatting but does not implement specific adversarial boundary markers for database content.
- Capability inventory: The agent can perform network operations and execute database commands, including write operations if explicitly enabled by the user via environment variables.
- Sanitization: No explicit sanitization or filtering of database output is mandated, though the query safety rules mitigate some volumetric risks.
Audit Metadata