Skill audit report

chdb-sql Audit report.

Use when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse Cloud, Iceberg, Delta Lake) without setting up a server. Provides chDB — embedded ClickHouse SQL in Python with 1000+ functions, Session for stateful multi-step pipelines, parametrized queries, and cross-source joins via `s3()`, `mysql()`, `postgresql()`, `iceberg()`, `deltaLake()`, `remoteSecure()` table functions. TRIGGER when: user wants SQL on parquet/csv/files or across remote analytical sources; uses ClickHouse SQL features (window functions, windowFunnel, geoToH3, JSON path ops, Session, parametrized queries); imports `chdb` or calls `chdb.query()`. SKIP this skill for pandas-style DataFrame method-chaining (use chdb-datastore instead) or ClickHouse server administration.

EXPERIMENTAL · REVIEWNeeds reviewGenerated Nov 6, 2026Heuristic metadata audit
75
Audit
73
Trust
68
Quality
78
Security
76
Maintain
92
Install

OpenAgentSkill Trust Score

73
Strong shortlist

OpenAgentSkill Trust Score

The Trust Score helps an agent decide whether a skill is safe enough to shortlist before installation.

GitHub adoption

INFO

76

530 GitHub stars

Stars/forks activity

INFO

65

530 stars, 37 forks; issue activity unavailable in current metadata

Recent maintenance

INFO

76

3mo since push

License clarity

PASS

86

Apache-2.0

README/SKILL.md completeness

PASS

86

Metadata includes enough usage and workflow context

Dependency/runtime risk

WARN

46

command execution surface, external package install surface

Install availability

PASS

92

npx skills add ClickHouse/agent-skills --skill chdb-sql

Install command safety

PASS

92

standard package or runtime install path

Permission surface

FAIL

36

shell or command execution, filesystem or document access

Repository evidence

PASS

86

https://github.com/ClickHouse/agent-skills/tree/main/skills/chdb-sql

Review status

PASS

88

AI review data available

Agent Proven outcomes

INFO

54

No agent outcome data yet

Checks

Install and adoption review

7 Passed · 10 Needs review

Install path

92

PASS

npx skills add ClickHouse/agent-skills --skill chdb-sql

Repository

88

PASS

https://github.com/ClickHouse/agent-skills/tree/main/skills/chdb-sql

License

86

PASS

Apache-2.0

Maintenance

76

CHECK

3mo since push

AI review

88

PASS

Approved with no listed issues

README/SKILL.md completeness

86

PASS

Usable description available

Dependency risk

46

FIX

command execution surface, external package install surface

Install command safety

92

PASS

standard package or runtime install path

Permission surface

36

FIX

shell or command execution, filesystem or document access

Stars/forks activity

65

CHECK

530 stars, 37 forks; issue activity unavailable in current metadata

Adoption

88

PASS

530 GitHub stars

Warnings

  • Dependency or permission surface needs review
  • Permission surface may require sandboxing
  • Quality score needs review
  • Permission surface needs review: shell or command execution, filesystem or document access
  • Dependency/runtime risk: command execution surface, external package install surface
  • Permission surface: shell or command execution, filesystem or document access

Method

This report combines public metadata, AI review output, repository freshness, install readiness, OpenAgentSkill events, quality scoring, trust checks, and the agent safety gate. It is not a full source-code security review.