ToolTrust
C38/100
Smithery

clickhouse

mcpsmithery

@Smithery

Query ClickHouse Cloud — run SQL, list databases and tables, explore services and backups, inspect usage, run ClickPipes.

By Smithery | 18 findings | Scanned 6/3/2026 | tooltrust-scanner/v0.3.13

2 High3 Medium13 Info

Risk Summary

Needs Approval

Dep Visibility plus Excessive Permissions raises enough risk that this tool should not be auto-trusted.

Potential impact: This finding indicates the tool should be reviewed before it is trusted.

Recommended action: Keep this tool behind manual approval and avoid unattended runs until the risky capabilities are narrowed or removed.

Suggested policy: keep this tool behind manual approval, do not allow unattended runs, and re-scan after narrowing risky permissions.

Security Findings (18)

  • HighAS-002

    ⚠️Excessive Permissions ×2

    tool declares network permission

    run_select_query

    tool declares exec permission

    run_select_query

    Fix: Tool requests broad permissions (exec/fs/network). Validate input parameters using Enums where possible, and restrict file system operations to explicit allowed directories.

  • MediumAS-002

    ⚠️Excessive Permissions ×3

    tool declares db permission

    run_select_querylist_databaseslist_tables

    Fix: Tool requests broad permissions (exec/fs/network). Validate input parameters using Enums where possible, and restrict file system operations to explicit allowed directories.

  • InfoAS-014

    ℹ️Dependency Inventory Unavailable ×13

    Tool did not expose metadata.dependencies or repo_url, so supply-chain coverage is limited.

    get_clickpipeget_organizationsrun_select_querylist_databaseslist_tablesget_services_listget_organization_detailsget_service_detailslist_clickpipeslist_service_backupsget_organization_costget_service_backup_detailsget_service_backup_configuration

    Fix: Review and remediate the identified issue.

Scan this tool yourself

Reproduce this audit locally, integrate into CI, or let your agent audit its own tools.

Install once, then scan any MCP server:

$ curl -sfL https://raw.githubusercontent.com/AgentSafe-AI/tooltrust-scanner/main/install.sh | bash
$ tooltrust-scanner scan --server "npx -y clickhouse"

Adjust the package name if your npm registry name differs from the tool ID. View source

Add badge to your README

Copy this Markdown to show your ToolTrust grade on GitHub.

[![ToolTrust Grade C](https://raw.githubusercontent.com/AgentSafe-AI/tooltrust-directory/main/docs/badges/grade-c.svg)](https://github.com/AgentSafe-AI/tooltrust-directory)