registry / Credential exfiltration / ts-prorm-orm / 4.2.0

ts-prorm-orm@4.2.0

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

AI Security Review

scanned 20h ago · by lpm-firewall-ai

The flagged file helper only transfers caller-selected files, but the CLI API client forwards stored credentials to a configurable destination without a visible allowlist. This supports a conditional credential exposure warning, not a finding of covert theft.

Static reason

High-risk behavior combination matched malicious policy.

Trigger

A user configures an API URL and invokes a command that makes an authenticated API request.

Impact

A mistyped or untrusted configured destination could receive the dashboard token; the inspected source does not establish covert collection or malicious use.

Mechanism

The API helper attaches the stored token as a bearer credential to requests sent to the configured base URL.

AI rationale

Evidence

dist/cli/cloud.jsdist/cli/commands/auth.js

Network endpoints1

docs-next-alpha.vercel.app

Decision evidence

public snapshot

AI called this Suspicious at 87.0% confidence as Dangerous Capability with medium false-positive risk.

Evidence for warning

The CLI uses a configurable API base URL, including a default endpoint and a PRORM_API_URL override.
Login stores the access token, and the API helper can attach a stored token as a bearer credential to requests.
The auth login command accepts an API URL override that is saved before login continues.

Evidence against

The API helper is used for dashboard commands, and the package describes the service as its dashboard API.
The flagged file transfer helper streams caller-selected files to supplied URLs; it does not itself collect environment credentials.

Behavioral surface

Source

ChildProcessCryptoDynamicRequireEnvironmentVarsEvalFilesystemNetworkShell

Supply chain

HighEntropyStringsUrlStrings

ManifestNo manifest risk signals triggered.

scanned 386 file(s), 6.79 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 = 37

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.2.0.

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

Review the evidence and your use of ts-prorm-orm@4.2.0 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:27:25.659Z (UTC).

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

AI Security Review

Decision evidence

Source & flagged code

Source & flagged code

Findings

Affected versions and remediation

Runtime surface

Behavioral surface

Source & flagged code