motherduck-build-cfa-app
Pass
Audited by Gen Agent Trust Hub on Sep 15, 2026
Risk Level: SAFEEXTERNAL_DOWNLOADSINDIRECT_PROMPT_INJECTIONCOMMAND_EXECUTION
Full Analysis
- [EXTERNAL_DOWNLOADS]: The documentation and guides reference the installation of standard, well-known libraries such as
fastapi,psycopg2-binary,express,pg, andjsonwebtokenusing official package managers (pip,npm). These are standard dependencies for the application architecture described. - [INDIRECT_PROMPT_INJECTION]: The provided backend code examples process SQL queries as input. Although the examples include prefix validation and demonstrate the use of parameterized queries to mitigate risk, the handling of raw SQL represents an architectural surface that users must implement carefully.
- Ingestion points:
QueryRequestschema inreferences/CFA_ARCHITECTURE.mdandreq.bodyin the Node.js API example. - Boundary markers: The
validate_queryfunction implements an allowlist for SQL statement prefixes (SELECT,WITH,FROM,SUMMARIZE,DESCRIBE). - Capability inventory: The examples execute SQL commands against remote MotherDuck databases using standard database drivers.
- Sanitization: Parameterized execution is used for values, while query structure is validated against an allowed prefix list.
- [COMMAND_EXECUTION]: The
references/EXECUTION_REFERENCE.mdfile contains shell command instructions (e.g., usinguv run) for users to execute the provided local artifact examples during development and testing.
Audit Metadata