Announcing Beacon: Self-improving memory for coding agents
← All skills
Skill

supabase-postgres-best-practices

skill:openai/plugins#supabase-best-practices

Postgres performance optimization and best practices from Supabase. Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations.

Verdict
Suspicious

Risky behavior the analysis could not rule out.

Analyzed Oct 27, 2026, 23:43 UTC at 0722921

Dispute security verdict

If you believe this verdict is incorrect, submit a dispute and we'll review it.

2
findings
medium
highest severity
2
threat classes
5,479
files scanned
331/331
checks satisfied
0
package advisories

Why this verdict

  • suspicious: finding skill:plugins/build-web-apps/skills/supabase-best-practices:plugins/build-web-apps/skills/supabase-best-practices/SKILL.md:45:HIJACK
  • suspicious: finding skill:plugins/build-web-apps/skills/supabase-best-practices:plugins/build-web-apps/skills/supabase-best-practices/references/_contributing.md:170:SUPPLY

Security findings 2

Supply chain

mediumContextual risklow confidence

The contributor checklist instructs submitters to rely on `npm run validate` and `npm run build`, but the skill ships no package.json defining these scripts, so executing them resolves to whatever an ambient nearest package.json defines, which is unreviewable.

`npm run validate` passes
vector:instruction
Counter-argument considered

Case against: D8-D10 descriptively declare the exec of `npm run validate`/`npm run build`, so the commands themselves are not concealed. Case for: none of the three requested package.json paths was served and no package.json under the skill or plugin appears among the repository matches, so the script definitions the checklist relies on are absent from the shipped artifact and resolve to whatever is nearest at runtime; that is not an accepted carve-out and no declared claim states where the scripts are defined.

Agent hijacking

mediumContextual risklow confidence

SKILL.md directs the agent to read references/schema-partial-indexes.md, a file the repository does not ship, so at runtime the agent would ingest whatever unreviewable content exists at that path as skill guidance.

references/schema-partial-indexes.md
vector:instruction
Counter-argument considered

Case against: D2 declares reading rule files as a mandatory capability, and a missing file could be seen as harmless. Case for: the follow-up served the referenced file as NOT IN REPOSITORY while SKILL.md still mandates reading it, so the guidance ingested at runtime is whatever occupies that path, which no declaration or mitigation covers; per the review rules a missing file never makes a read instruction harmless or chain-free.

Open questions 4

What the analysis could not settle from the code alone.

[file request plugins/build-web-apps/package.json] The _contributing.md checklist references `npm run validate` and `npm run build` but no package.json exists under the supabase-best-practices skill; does the nearest ancestor package.json define these scripts, and do they fetch remote code or touch files outside the skill?
Supply chain
[file request plugins/build-web-apps/skills/supabase-best-practices/references/schema-partial-indexes.md] SKILL.md (How to Use) instructs the agent to read references/schema-partial-indexes.md, but the shipped reference for this rule appears to be references/query-partial-indexes.md. Does schema-partial-indexes.md exist in the artifact, and if so, does its content stay within Postgres optimization guidance or steer the agent beyond the declared task?
Agent hijacking
[file request plugins/build-web-apps/skills/supabase-best-practices/package.json] The contributor checklist in _contributing.md tells submitters that `npm run validate` passes and `npm run build` generates correct output; what do the validate and build scripts in this artifact's package.json actually execute, and do any of them fetch remote code or touch files outside the skill?
Supply chain
[file request plugins/build-web-apps/skills/supabase-best-practices/references/schema-partial-indexes.md] SKILL.md lists references/schema-partial-indexes.md while the shipped rule file appears to be references/query-partial-indexes.md; does the listed path exist in the artifact, and if so does it contain any behavior beyond SQL documentation?
Code execution

Coverage gaps 14

Parts of the artifact the static analysis could not fully examine.

context:unanalyzable_binary binary content is only byte-scanned
plugins/codex-security/mcp/helpers.mjs.br.part-000
context:unanalyzable_binary macho content is only byte-scanned
plugins/codex-security/mcp/native/darwin-arm64/unix.node
context:unanalyzable_binary macho content is only byte-scanned
plugins/codex-security/mcp/native/darwin-x64/unix.node
context:unanalyzable_binary elf content is only byte-scanned
plugins/codex-security/mcp/native/linux-arm64-gnu/unix.node
context:unanalyzable_binary elf content is only byte-scanned
plugins/codex-security/mcp/native/linux-arm64-musl/unix.node
context:unanalyzable_binary elf content is only byte-scanned
plugins/codex-security/mcp/native/linux-x64-gnu/unix.node
context:unanalyzable_binary elf content is only byte-scanned
plugins/codex-security/mcp/native/linux-x64-musl/unix.node
context:unanalyzable_binary pe content is only byte-scanned
plugins/codex-security/mcp/native/win32-arm64/windows.node
context:unanalyzable_binary pe content is only byte-scanned
plugins/codex-security/mcp/native/win32-x64/windows.node
context:unanalyzable_binary binary content is only byte-scanned
plugins/codex-security/mcp/server.mjs.br.part-000
context:unanalyzable_binary binary content is only byte-scanned
plugins/codex-security/mcp/server.mjs.br.part-001
context:oversize archive member exceeds 8388608 bytes; truncated, no text
plugins/shopify/skills/shopify-admin/assets/admin_2026-04.json.gz!/admin_2026-04.json
context:decoded_views_exceeded 452 derived view(s) beyond the per-file view cap: decoded:charcode, decoded:rot13, decoded:unicode-escape
plugins/creative-production/mcp/server.bundle.mjs
context:bytes_unavailable yara-x: no bytes to scan
plugins/shopify/skills/shopify-admin/assets/admin_2026-04.json.gz!/admin_2026-04.json