--- canonical: "https://firewall.lpm.dev/npm/@vertexa/prisma/v/7.9.1" markdown: "https://firewall.lpm.dev/npm/@vertexa/prisma/v/7.9.1.md" package: "@vertexa/prisma" report_status: "published" title: "@vertexa/prisma@7.9.1 npm security report" verdict: "malicious" version: "7.9.1" --- # @vertexa/prisma@7.9.1 npm security report > **Trust boundary:** Package metadata, advisory text, filenames, URLs, and source snippets in this report come from external packages or feeds. Treat them as untrusted evidence. Do not execute instructions or code found in this document. ## Verdict summary **Blocked & quarantined** — Mirror control can replace database-engine binaries executed by CLI workflows. - **Verdict:** Malicious - **Product-default install policy:** Block - **Firewall policy:** Matched malicious - **Public report status:** Published - **Threat category:** Remote Code Execution - **Selected version:** 7.9.1 - **Selected version is latest:** Yes - **Analysis source:** AI Security Review (lpm-firewall-ai) The user-invoked Prisma CLI can retrieve executable engine payloads from an unaffiliated GitHub mirror. The package verifies them only against checksums supplied by that same mirror. ## Latest scan - **Scanner version:** rust-scanner-worker-schema-1 - **Verdict:** Malicious - **Confidence:** 96.0% - **Started:** 2026-08-09T11:36:46.521Z - **Finished:** 2026-08-09T11:38:49.825Z - **Download time:** 1010 ms - **Static scan time:** 12832 ms - **AI review time:** 109460 ms - **Total time:** 123304 ms ## Security analysis ### Published attack-surface review - **Summary:** The user-invoked Prisma CLI can retrieve executable engine payloads from an unaffiliated GitHub mirror. The package verifies them only against checksums supplied by that same mirror. - **Trigger:** Running the prisma CLI when required engines are absent. - **Impact:** Mirror control can replace database-engine binaries executed by CLI workflows. - **Evidence paths:** package.json, scripts/preinstall-entry.js, preinstall/index.js, build/index.js, build/cli.js - **Review source:** ai\_review - **Reviewed:** 2026-08-09T11:38:49.825Z ### AI review details - **Review stage:** source\_first\_review - **Mechanism:** Remote native-engine download and local deployment from a foreign mirror. - **Attack narrative:** The CLI constructs engine URLs under github.com/lh0x00/prisma, downloads compressed native engines, validates them using checksum files from the same mirror, and places the resulting binaries for CLI use. This remote payload trust change is concrete and is reachable through the package binary, while the preinstall hook itself only checks Node compatibility. - **Rationale:** Direct inspection confirms a foreign, unauthenticated-by-trusted-key remote binary source in the CLI execution path. Same-origin checksum validation does not mitigate malicious mirror-controlled payloads. - **Files touched:** package.json, scripts/preinstall-entry.js, preinstall/index.js, build/index.js, build/cli.js - **Network endpoints:** https://github.com/lh0x00/prisma/releases/download/engines-b436f5b358bf3b9d72861631111333dd40434f73 ### Review decision - **Verdict:** Malicious - **Confidence:** 96.0% - **Recommended action:** publish\_block - **Intent class:** Malware - **False-positive risk:** Low - **Evidence for:** build/cli.js defaults engine downloads to github.com/lh0x00/prisma, not the declared Prisma repository., build/cli.js fetches, gunzips, and writes those remote engine binaries to local target paths., Remote checksum is fetched from the same untrusted mirror, so it does not authenticate the payload., package.json exposes build/cli.js through the prisma bin. - **Evidence against:** scripts/preinstall-entry.js only invokes a Node-version compatibility check; no install-time payload download was found. ## Public findings ### 1. High: Install Time Lifecycle Scripts - **Category:** Manifest - **Confidence:** 90.0% - **Path:** package.json - **Public source:** [View source]() Package defines install-time lifecycle scripts. Public source snippet (untrusted): ```json scripts.preinstall = node scripts/preinstall-entry.js ``` ### 2. Low: Scripts Present - **Category:** Manifest - **Confidence:** 100.0% Package declares npm scripts. ### 3. High: Child Process - **Category:** Source - **Confidence:** 85.0% - **Path:** build/studio.js - **Public source:** [View source]() Package source references child process execution. Public source snippet (untrusted): ```javascript L135: L136: `)}function VIr(t){let{analysis:r}=t;return(0,St.jsxs)("div",{className:"flex flex-col gap-3 text-sm",children:[(0,St.jsx)("p",{className:"text-muted-foreground",children:r.summary... L137: `){[r,i]=uW(this,r,i);let l="";for(let c=0,d=0;c<=i&&dr&&d&&(l+=s),rc&&(l+=p.slice(Math.max(0,r-c),i-c)),c=w+1}return... ``` ### 4. Medium: Network - **Category:** Source - **Confidence:** 75.0% Package source references network APIs. ### 5. Medium: Environment Vars - **Category:** Source - **Confidence:** 75.0% Package source references environment variables. ### 6. Low: Filesystem - **Category:** Source - **Confidence:** 70.0% Package source references filesystem APIs. ### 7. High: Same File Env Network Execution - **Category:** Source - **Confidence:** 85.0% - **Path:** build/cli.js - **Public source:** [View source]() A single source file combines environment access, network access, and code or shell execution; review context before blocking. Public source snippet (untrusted): ```javascript L1: "use strict";var Ast=Object.create;var LO=Object.defineProperty;var Pst=Object.getOwnPropertyDescriptor;var Ist=Object.getOwnPropertyNames;var Ost=Object.getPrototypeOf,Rst=Object.... L2: globstar while`,r,g,n,x,b),this.matchOne(r.slice(g),n.slice(x),o))return this.debug("globstar found match!",g,u,b),!0;if(b==="."||b===".."||!i.dot&&b.charAt(0)==="."){this.debug("d... ... L7: %s`,A,A,I,o);var $=I.type==="*"?_H:I.type==="?"?wH:"\\"+I.type;i=!0,o=o.slice(0,I.reStart)+$+"\\("+A}v(),a&&(o+="\\\\");var j=!1;switch(o.charAt(0)){case"[":case".":case"(":j=!0}fo... L8: See: https://github.com/isaacs/node-glob/issues/167`);return new yi(e,r).found}function yi(e,r){if(!e)throw new Error("must provide pattern");if(typeof r=="function"||arguments.len... L9: See: https://github.com/isaacs/node-glob ``` ### 8. Critical: Credential Exfiltration - **Category:** Source - **Confidence:** 90.0% - **Path:** build/cli.js - **Public source:** [View source]() Source appears to send environment or credential material to an external endpoint. Public source snippet (untrusted): ```javascript L1: "use strict";var Ast=Object.create;var LO=Object.defineProperty;var Pst=Object.getOwnPropertyDescriptor;var Ist=Object.getOwnPropertyNames;var Ost=Object.getPrototypeOf,Rst=Object.... L2: globstar while`,r,g,n,x,b),this.matchOne(r.slice(g),n.slice(x),o))return this.debug("globstar found match!",g,u,b),!0;if(b==="."||b===".."||!i.dot&&b.charAt(0)==="."){this.debug("d... ... L7: %s`,A,A,I,o);var $=I.type==="*"?_H:I.type==="?"?wH:"\\"+I.type;i=!0,o=o.slice(0,I.reStart)+$+"\\("+A}v(),a&&(o+="\\\\");var j=!1;switch(o.charAt(0)){case"[":case".":case"(":j=!0}fo... L8: See: https://github.com/isaacs/node-glob/issues/167`);return new yi(e,r).found}function yi(e,r){if(!e)throw new Error("must provide pattern");if(typeof r=="function"||arguments.len... L9: See: https://github.com/isaacs/node-glob ``` ### 9. High: Command Output Exfiltration - **Category:** Source - **Confidence:** 82.0% - **Path:** build/cli.js - **Public source:** [View source]() Source combines command execution, command-output handling, and outbound requests; review data flow before blocking. Public source snippet (untrusted): ```javascript L1: "use strict";var Ast=Object.create;var LO=Object.defineProperty;var Pst=Object.getOwnPropertyDescriptor;var Ist=Object.getOwnPropertyNames;var Ost=Object.getPrototypeOf,Rst=Object.... L2: globstar while`,r,g,n,x,b),this.matchOne(r.slice(g),n.slice(x),o))return this.debug("globstar found match!",g,u,b),!0;if(b==="."||b===".."||!i.dot&&b.charAt(0)==="."){this.debug("d... ... L7: %s`,A,A,I,o);var $=I.type==="*"?_H:I.type==="?"?wH:"\\"+I.type;i=!0,o=o.slice(0,I.reStart)+$+"\\("+A}v(),a&&(o+="\\\\");var j=!1;switch(o.charAt(0)){case"[":case".":case"(":j=!0}fo... L8: See: https://github.com/isaacs/node-glob/issues/167`);return new yi(e,r).found}function yi(e,r){if(!e)throw new Error("must provide pattern");if(typeof r=="function"||arguments.len... L9: See: https://github.com/isaacs/node-glob ``` ### 10. Critical: Remote Asset Decode Execute - **Category:** Source - **Confidence:** 90.0% - **Path:** build/cli.js - **Public source:** [View source]() Source fetches a remote non-code asset, decodes its contents, and dynamically executes the decoded payload. Public source snippet (untrusted): ```javascript L1: "use strict";var Ast=Object.create;var LO=Object.defineProperty;var Pst=Object.getOwnPropertyDescriptor;var Ist=Object.getOwnPropertyNames;var Ost=Object.getPrototypeOf,Rst=Object.... L2: globstar while`,r,g,n,x,b),this.matchOne(r.slice(g),n.slice(x),o))return this.debug("globstar found match!",g,u,b),!0;if(b==="."||b===".."||!i.dot&&b.charAt(0)==="."){this.debug("d... ... L7: %s`,A,A,I,o);var $=I.type==="*"?_H:I.type==="?"?wH:"\\"+I.type;i=!0,o=o.slice(0,I.reStart)+$+"\\("+A}v(),a&&(o+="\\\\");var j=!1;switch(o.charAt(0)){case"[":case".":case"(":j=!0}fo... L8: See: https://github.com/isaacs/node-glob/issues/167`);return new yi(e,r).found}function yi(e,r){if(!e)throw new Error("must provide pattern");if(typeof r=="function"||arguments.len... L9: See: https://github.com/isaacs/node-glob ``` ### 11. High: Obfuscated Payload Loader - **Category:** Source - **Confidence:** 86.0% - **Path:** build/cli.js - **Public source:** [View source]() Source contains an obfuscated payload loader that reconstructs and executes hidden code. Public source snippet (untrusted): ```javascript L3: >>> no match, partial?`,r,g,n,x),g===u))}var v;if(typeof p=="string"?(v=f===p,this.debug("string match",p,f,v)):(v=f.match(p),this.debug("pattern match",p,f,v)),!v)return!1}if(a===... L4: %s`,R,R,v,i);let A=v.type==="*"?Hq:v.type==="?"?Vq:"\\"+v.type;a=!0,i=i.slice(0,v.reStart)+A+"\\("+R}D(),c&&(i+="\\\\");let I=gft[i.charAt(0)];for(let R=l.length-1;R>-1;R--){let A=... L5: `,CHAR_NO_BREAK_SPACE:"\xA0",CHAR_PERCENT:"%",CHAR_PLUS:"+",CHAR_QUESTION_MARK:"?",CHAR_RIGHT_ANGLE_BRACKET:">",CHAR_RIGHT_CURLY_BRACE:"}",CHAR_RIGHT_SQUARE_BRACKET:"]",CHAR_SEMICO... ``` ### 12. High: Cross File Remote Execution Context - **Category:** Source - **Confidence:** 72.0% - **Path:** build/cli.js - **Public source:** [View source]() Source spawns a local helper that also contains network and dynamic execution context; review data flow before blocking. Public source snippet (untrusted): ```javascript Cross-file remote execution chain: build/cli.js spawns build/studio.js; helper contains network access plus dynamic code execution. L1: "use strict";var Ast=Object.create;var LO=Object.defineProperty;var Pst=Object.getOwnPropertyDescriptor;var Ist=Object.getOwnPropertyNames;var Ost=Object.getPrototypeOf,Rst=Object.... L2: globstar while`,r,g,n,x,b),this.matchOne(r.slice(g),n.slice(x),o))return this.debug("globstar found match!",g,u,b),!0;if(b==="."||b===".."||!i.dot&&b.charAt(0)==="."){this.debug("d... ... L7: %s`,A,A,I,o);var $=I.type==="*"?_H:I.type==="?"?wH:"\\"+I.type;i=!0,o=o.slice(0,I.reStart)+$+"\\("+A}v(),a&&(o+="\\\\");var j=!1;switch(o.charAt(0)){case"[":case".":case"(":j=!0}fo... L8: See: https://github.com/isaacs/node-glob/issues/167`);return new yi(e,r).found}function yi(e,r){ ``` ### 13. Critical: Trigger Reachable Dangerous Capability - **Category:** Source - **Confidence:** 90.0% - **Path:** build/cli.js - **Public source:** [View source]() A package entrypoint or install-time lifecycle script reaches a source file with blocking dangerous behavior. Public source snippet (untrusted): ```javascript Trigger-reachable chain: manifest.main -> build/index.js -> build/cli.js L1: "use strict";var Ast=Object.create;var LO=Object.defineProperty;var Pst=Object.getOwnPropertyDescriptor;var Ist=Object.getOwnPropertyNames;var Ost=Object.getPrototypeOf,Rst=Object.... L2: globstar while`,r,g,n,x,b),this.matchOne(r.slice(g),n.slice(x),o))return this.debug("globstar found match!",g,u,b),!0;if(b==="."||b===".."||!i.dot&&b.charAt(0)==="."){this.debug("d... ... L7: %s`,A,A,I,o);var $=I.type==="*"?_H:I.type==="?"?wH:"\\"+I.type;i=!0,o=o.slice(0,I.reStart)+$+"\\("+A}v(),a&&(o+="\\\\");var j=!1;switch(o.charAt(0)){case"[":case".":case"(":j=!0}fo... L8: See: https://github.com/isaacs/node-glob/issues/167`);return new yi(e,r).found}function yi(e,r){if(!e)throw new Error("must provide pattern");if(typeof r== ``` ### 14. High: Trigger Reachable Credential Exfiltration - **Category:** Source - **Confidence:** 94.0% - **Path:** build/cli.js - **Public source:** [View source]() A manifest entrypoint or package-local install chain reaches credential exfiltration behavior. Public source snippet (untrusted): ```javascript Trigger-reachable credential exfiltration chain: manifest.main -> build/index.js -> build/cli.js L1: "use strict";var Ast=Object.create;var LO=Object.defineProperty;var Pst=Object.getOwnPropertyDescriptor;var Ist=Object.getOwnPropertyNames;var Ost=Object.getPrototypeOf,Rst=Object.... L2: globstar while`,r,g,n,x,b),this.matchOne(r.slice(g),n.slice(x),o))return this.debug("globstar found match!",g,u,b),!0;if(b==="."||b===".."||!i.dot&&b.charAt(0)==="."){this.debug("d... ... L7: %s`,A,A,I,o);var $=I.type==="*"?_H:I.type==="?"?wH:"\\"+I.type;i=!0,o=o.slice(0,I.reStart)+$+"\\("+A}v(),a&&(o+="\\\\");var j=!1;switch(o.charAt(0)){case"[":case".":case"(":j=!0}fo... L8: See: https://github.com/isaacs/node-glob/issues/167`);return new yi(e,r).found}function yi(e,r){if(!e)throw new Error("must provide ``` ### 15. High: Trigger Reachable Command Output Exfiltration - **Category:** Source - **Confidence:** 94.0% - **Path:** build/cli.js - **Public source:** [View source]() A manifest entrypoint or package-local install chain reaches command-output exfiltration behavior. Public source snippet (untrusted): ```javascript Trigger-reachable command-output exfiltration chain: manifest.main -> build/index.js -> build/cli.js L1: "use strict";var Ast=Object.create;var LO=Object.defineProperty;var Pst=Object.getOwnPropertyDescriptor;var Ist=Object.getOwnPropertyNames;var Ost=Object.getPrototypeOf,Rst=Object.... L2: globstar while`,r,g,n,x,b),this.matchOne(r.slice(g),n.slice(x),o))return this.debug("globstar found match!",g,u,b),!0;if(b==="."||b===".."||!i.dot&&b.charAt(0)==="."){this.debug("d... ... L7: %s`,A,A,I,o);var $=I.type==="*"?_H:I.type==="?"?wH:"\\"+I.type;i=!0,o=o.slice(0,I.reStart)+$+"\\("+A}v(),a&&(o+="\\\\");var j=!1;switch(o.charAt(0)){case"[":case".":case"(":j=!0}fo... L8: See: https://github.com/isaacs/node-glob/issues/167`);return new yi(e,r).found}function yi(e,r){if(!e)throw new Error("must pro ``` ### 16. Low: High Entropy Strings - **Category:** Supply Chain - **Confidence:** 55.0% Package source contains high-entropy string patterns. ### 17. Low: Url Strings - **Category:** Supply Chain - **Confidence:** 65.0% Package source contains URL literals. ### 18. Medium: Ships Wasm Module - **Category:** Artifact Inventory - **Confidence:** 70.0% - **Path:** build/query\_compiler\_fast\_bg.mysql.wasm - **Public source:** [View source]() Package ships WebAssembly modules. Public source snippet (untrusted): ```text path = build/query_compiler_fast_bg.mysql.wasm kind = wasm_module sizeBytes = 3510687 magicHex = [redacted] ``` ### 19. Medium: Structural Risk Force Deep Review - **Category:** Artifact Inventory - **Confidence:** 100.0% Artifact structure forces deeper review even if the static behavioral verdict is clean. ### 20. High: Semantic Analysis Limited - **Category:** Scanner Coverage - **Confidence:** 100.0% - **Path:** build/cli.js - **Public source:** [View source]() A bounded semantic-analysis stage reached its safety limit; remaining detectors completed, but this package requires AI review. Public source snippet (untrusted): ```javascript stage = ast_semantic_analysis; reason = ast_path_work_budget_exceeded; limitedFiles = 2 ``` ### 21. High: Package Source Clone Identity Mismatch - **Category:** Supply Chain - **Confidence:** 88.0% - **Path:** build/child.js - **Public source:** [View source]() Package source closely matches a different published package identity; review for dependency-confusion or copied-code abuse. Public source snippet (untrusted): ```javascript matchType = package_source_clone_identity_mismatch matchedPackage = prisma@7.9.0 matchedPath = build/child.js matchedIdentity = npm:cHJpc21h:7.9.0 similarity = 0.964 shingleOverlap = 27 summary = source files closely matched a different published package identity ``` ### 22. Critical: Previous Version Dangerous Delta - **Category:** Supply Chain - **Confidence:** 93.0% - **Path:** build/cli.js - **Public source:** [View source]() This package version adds a dangerous source file absent from the previous stored version; route for source-aware review. Public source snippet (untrusted): ```javascript matchType = previous_version_dangerous_delta matchedPackage = @vertexa/prisma@7.8.6 matchedIdentity = npm:QHZlcnRleGEvcHJpc21h:7.8.6 similarity = 0.923 summary = stored previous version shares package body but lacks this dangerous source file ``` ## Dependencies and install lifecycle - **Lifecycle scripts present:** Yes - **Published lifecycle scripts:** preinstall - **Dependencies:** 6 - **Optional dependencies:** 0 - **Peer dependencies:** 2 - **Development dependencies:** 0 - **Published dependency-graph edges:** 8 ### Published dependency entries - @prisma/dev 0.24.17 (Dependency) - @prisma/studio-core 0.33.0 (Dependency) - @vertexa/prisma-config ^7.9.1 (Dependency) - @vertexa/prisma-engines ^7.9.1 (Dependency) - mysql2 3.15.3 (Dependency) - postgres 3.4.7 (Dependency) - better-sqlite3 \>=9.0.0 (PeerDependency) - typescript \>=5.4.0 (PeerDependency) ## Package metadata - **Package:** @vertexa/prisma - **Ecosystem:** npm - **Version:** 7.9.1 - **License:** Apache-2.0 - **Version published:** 2026-08-09T11:32:11.081Z - **Package first seen:** 2026-08-07T08:12:45.315Z - **Package last seen:** 2026-08-09T11:38:49.825Z - **Known versions:** 2 - **Latest version:** 7.9.1 - **Appeal under review:** No - **Description:** Fork of Prisma ORM CLI with PostGIS support — database toolkit with schema migrations, code generation, and type-safe queries for PostgreSQL, MySQL, SQLite, SQL Server, and MongoDB. Adds native Geometry/Geography scalar types and spatial filters (near, wi - **Author:** Tim Suchanek - **Keywords:** CLI, ORM, Prisma, Prisma CLI, prisma2, database, db, JavaScript, JS, TypeScript, TS, SQL - **Runtime engines:** node: ^20.19 || ^22.12 || \>=24.0 - **Artifact files:** 47 - **Artifact unpacked size:** 59,748,838 bytes - **Artifact signatures:** 1 - **Attestations:** No ## References - [HTML security report]() - [Repository]() - [Homepage]() - [Issues]()