clickhouse-multi-env-setup
Pass
Audited by Gen Agent Trust Hub on Sep 9, 2026
Risk Level: SAFECREDENTIALS_UNSAFEINDIRECT_PROMPT_INJECTION
Full Analysis
- [CREDENTIALS_UNSAFE]: The configuration module described in
references/implementation.mdforsrc/config/clickhouse.tscontains a hardcoded default password 'dev_password' for the development environment. While common in development templates, this fallback string constitutes a hardcoded credential in the logic. - [INDIRECT_PROMPT_INJECTION]: The
scripts/apply-schema.tsfile implements a schema migration tool that reads and executes SQL files from the filesystem, representing a potential vulnerability surface for indirect injection if the migration files are sourced from an untrusted location. - Ingestion points: Files in the
src/clickhouse/schemas/directory accessed viafs.readdirSyncandfs.readFileSyncinscripts/apply-schema.ts. - Boundary markers: None; the script iterates through and executes all
.sqlfiles found in the target directory without boundary markers. - Capability inventory: The script uses
client.command({ query: sql })which allows for the execution of arbitrary database commands. - Sanitization: None; the raw content of each SQL file is passed directly to the database client without verification or sanitization.
Audit Metadata