ts-prorm-orm@4.0.2

⚠ Under review

A TypeScript ORM for MySQL, PostgreSQL, SQLite, MSSQL, and more

AI Security Review

scanned 19h ago · by lpm-firewall-ai

The inspected findings are consistent with file transfer to presigned URLs and user-invoked dashboard authentication. The required clean citation coverage exceeds the 256-reference limit, so a full clean determination cannot be supported from this review.

Static reason

High-risk behavior combination matched malicious policy.

Trigger

A user invokes a cloud CLI command that makes an authenticated API request.

Impact

No credential theft or other concrete attack was established; the broader clean review remains incomplete because the required citation coverage exceeds the available limit.

Mechanism

The CLI builds requests using its configured API base and attaches the stored bearer token when authentication is enabled.

AI rationale

Evidence

dist/cli/io.jsdist/cli/cloud.jsdist/cli/commands/auth.jspackage.json

Network endpoints1

docs-next-alpha.vercel.app

Decision evidence

public snapshot

AI called this Manual Review at 72.0% confidence as Unknown with medium false-positive risk.

AI review observations

The flagged upload helper sends a file to a supplied URL and does not add an authorization header.
The cloud CLI attaches its saved token to API requests; the API base can come from configuration or an environment override, with a package default.
Login explicitly accepts a dashboard access token or uses a browser authorization flow, consistent with an intended cloud CLI function.
The required clean citation set is too large to verify and cite within the 256-citation limit, so benign behavior across all required paths remains unconfirmed.

Evidence against

Behavioral surface

Source

ChildProcessCryptoDynamicRequireEnvironmentVarsEvalFilesystemNetwork

Supply chain

HighEntropyStringsUrlStrings

ManifestNo manifest risk signals triggered.

scanned 380 file(s), 6.69 MB of source, external domains: api.cloudflare.com, api.example.com, api.sumologic.com, app.prorm.dev, bucket.s3.amazonaws.com, clickhouse.com, dev.mysql.com, docs-next-alpha.vercel.app, docs.aws.amazon.com, docs.oracle.com, docs.snowflake.com, docs.timescale.com, github.com, hypopg.readthedocs.io, learn.microsoft.com, mariadb.com, papertrailapp.com, pgrouting.org, postgis.net, prod-orm.io, registry.npmjs.org, www.ibm.com, www.postgresql.org, www.sqlite.org, www.w3.org

Source & flagged code

6 flagged

dist/cli/commands/db.jsView file

Lines 53-93javascript

53 // Validate discrete connection parts client-side when no --url is given

54 // (sqlite/file dialects don't need a host, only a database/path).

55 if (!url) {

56 const needsHost = dialect !== 'sqlite';

57 const missing = [];

58 if (needsHost && !host)

59 missing.push('--host');

60 if (needsHost && port === undefined)

61 missing.push('--port');

62 if (!database)

63 missing.push('--database');

64 if (missing.length) {

65 framework_1.out.error(`Missing ${missing.join(', ')} (or pass --url for a full connection string).`);

66 return 1;

67 }

68 }

69 // Prompt for the password without leaking it into shell history when

70 // --password is given without a value.

71 let password = str(ctx.flags.password);

72 if (ctx.flags.password !== undefined && !password) {

73 password = await (0, prompt_1.promptHidden)('Database password: ') || undefined;

Medium

Secret Pattern

Package contains a possible secret pattern.

dist/cli/commands/db.jsView on unpkg · L73

74 }

75 const body = {

76 name: ctx.flags.name,

77 dialect,

78 host,

79 port,

80 database,

81 username: str(ctx.flags.username),

82 password,

83 url,

84 team: str(ctx.flags.team),

85 ssl: ctx.flags.ssl !== false,

86 };

87 const data = await (0, cloud_1.api)('/api/dashboard/databases', { method: 'POST', body });

88 framework_1.out.success(`Connected database ${data.name} (${data.id})`);

89 return 0;

90 },

91});

92const list = (0, framework_1.defineCommand)({

93 name: 'db list',

dist/schema-types.jsView file

Lines 11-51javascript

11 * actually need — adding a value to a live enum.

12 *

13 * Values reaching SQL here are literals, not identifiers: an enum's members, a

14 * comment's text, a domain's default. Each goes through {@link quoteLiteral}

15 * rather than being interpolated.

dist/cli/io.jsView file

Lines 50-90javascript

50const framework_1 = require("./framework");

51const prompt_1 = require("./prompt");

52// ─── Overwrite protection ──────────────────────────────────────────────────────

53/**

54 * Guard a local write: if `dest` already exists, confirm before clobbering it.

dist/cli/commands/packages.js#virtual:normalized:round1View file

•stage = ast_semantic_analysis; reason = ast_parse_error; limitedFiles = 36

High

Semantic Analysis Limited

A bounded semantic-analysis stage reached its safety limit; remaining detectors completed, but this package requires AI review.

dist/cli/commands/packages.js#virtual:normalized:round1View on unpkg

Source & flagged code

6 flagged · loading source

dist/cli/commands/db.jsView file

73patternName = generic_password severity = medium line = 73

Medium

Secret Pattern

Package contains a possible secret pattern.

dist/cli/commands/db.jsView on unpkg · L73

dist/schema-types.jsView file

31exports.buildNextSequenceValueSQL = buildNextSequenceValueSQL; L32: const schema_objects_1 = require("./schema-objects"); L33: /**

Medium

Dynamic Require

Package source references dynamic require/import behavior.

dist/schema-types.jsView on unpkg · L31

dist/cli/io.jsView file

70const stream = fs.createReadStream(filePath); L71: const res = await fetch(url, { L72: method: 'PUT', L73: // Node's fetch (undici) requires duplex for a stream body. L74: body: stream_1.Readable.toWeb(stream), L75: duplex: 'half', ... L87: if (!res.body) { L88: fs.writeFileSync(dest, Buffer.from(await res.arrayBuffer())); L89: return; ... L160: const g = (0, framework_1.getGlobalOptions)(); L161: const active = Boolean(process.stderr.isTTY) && !g.quiet && !g.json; L162: if (!active) {

Findings

2 Critical2 High5 Medium6 Low

CriticalCredential Exfiltrationdist/cli/io.js

CriticalTrigger Reachable Dangerous Capabilitydist/cli/io.js

HighTrigger Reachable Credential Exfiltrationdist/cli/io.js

HighSemantic Analysis Limiteddist/cli/commands/packages.js#virtual:normalized:round1

MediumSecret Patterndist/cli/commands/db.js

MediumDynamic Requiredist/schema-types.js

MediumNetwork

MediumEnvironment Vars

MediumStructural Risk Force Deep Review

LowNon Install Lifecycle Scripts

LowScripts Present

LowEval

LowFilesystem

LowHigh Entropy Strings

Affected versions and remediation

This report applies to ts-prorm-orm@4.0.2.

See all versions of ts-prorm-orm for other recorded verdicts.

Review the evidence and your use of ts-prorm-orm@4.0.2 before allowing it. Restrict the permissions described in this report.
Choose an independently verified alternative or release. This report does not establish that other versions are safe.

Evidence last updated: 2026-10-22 06:48:11.490Z (UTC).

Think this verdict is wrong? Dispute it on GitHub or read how reports are produced.