postgres

Warn

Audited by Socket on Sep 11, 2026

2 alerts found:

Securityx2
SecurityMEDIUM
evals/files/tenant_policies.sql

The fragment does not show malware, but it contains a significant multi-tenant authorization flaw. The permissive editor policy broadens access across tenants and can authorize cross-tenant document moves. The reporting owner and etl BYPASSRLS configuration intentionally bypass row-level restrictions. The dashboard slowdown is consistent with missing documents(tenant_id) indexing and per-row RLS evaluation. Use restrictive, explicitly separated USING and WITH CHECK rules, constrain writes to the request tenant, review editor semantics, enforce trusted session context, consider FORCE ROW LEVEL SECURITY where appropriate, and add suitable indexes.

Confidence: 98%Severity: 88%
SecurityMEDIUM
evals/files/0031_billing_columns.sql

This is not apparent malware or supply-chain code. It is a high-risk production migration likely to time out, block application writes, generate heavy WAL, or fail because of lock contention or invalid foreign-key data. The unvalidated DROP COLUMN is destructive. A safer approach would stage changes, backfill in batches, use an appropriate lock_timeout, create the index concurrently, validate the foreign key separately, and remove the legacy column only after confirmed consumers and backups are addressed.

Confidence: 98%Severity: 88%
Audit Metadata
Analyzed At
Sep 11, 2026, 03:16 PM
Package URL
pkg:socket/skills-sh/lynricsy%2Fhyperskills%2Fpostgres%2F@6f2145b2dad76b20b27223db978fede7f10eea837760517eb53d7384b5730b02
Security Audit — socket — postgres