Skill audit report

supabase-postgres-best-practices Audit report.

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pg_cron, pgmq), vector/semantic search (pgvector), and restoring dumps (pg_restore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.

EXPERIMENTAL · REVIEWNeeds reviewGenerated Nov 4, 2026Heuristic metadata audit

Audit

Trust

Quality

Security

Maintain

Install

OpenAgentSkill Trust Score

Manual review

OpenAgentSkill Trust Score

The Trust Score helps an agent decide whether a skill is safe enough to shortlist before installation.

GitHub adoption

PASS

2.6K GitHub stars

Stars/forks activity

INFO

2.6K stars, 200 forks; issue activity unavailable in current metadata

Recent maintenance

PASS

3mo since push

License clarity

PASS

MIT

README/SKILL.md completeness

PASS

Metadata includes enough usage and workflow context

Dependency/runtime risk

INFO

credential or environment access, database surface

Install availability

PASS

npx skills add supabase/agent-skills --skill supabase-postgres-best-practices

Install command safety

PASS

standard package or runtime install path

Permission surface

WARN

secrets or environment access, filesystem or document access

Repository evidence

PASS

https://github.com/supabase/agent-skills/tree/main/skills/supabase-postgres-best-practices

Review status

INFO

AI review data available

Agent Proven outcomes

INFO

No agent outcome data yet

Checks

Install and adoption review

7 Passed · 11 Needs review

Install path

PASS

npx skills add supabase/agent-skills --skill supabase-postgres-best-practices

Repository

PASS

https://github.com/supabase/agent-skills/tree/main/skills/supabase-postgres-best-practices

License

PASS

MIT

Maintenance

PASS

3mo since push

AI review

CHECK

SKILL.md metadata version is 1.1.1 but the changelog shows the latest release is 1.6.0, creating a version mismatch.

README/SKILL.md completeness

PASS

Usable description available

Dependency risk

CHECK

credential or environment access, database surface

Install command safety

PASS

standard package or runtime install path

Permission surface

FIX

secrets or environment access, filesystem or document access

Stars/forks activity

CHECK

2.6K stars, 200 forks; issue activity unavailable in current metadata

Adoption

PASS

2.6K GitHub stars

Warnings

Permission surface may require sandboxing
SKILL.md metadata version is 1.1.1 but the changelog shows the latest release is 1.6.0, creating a version mismatch.
SKILL.md does not include an explicit 'Safety and Limitations' section advising agents to avoid executing DDL or migrations without human review in production environments.
The SKILL.md reference list is very short and does not enumerate the full set of rule files available in the skill, which makes discoverability weaker.
Quality score needs review
Permission surface needs review: secrets or environment access, filesystem or document access
Permission surface: secrets or environment access, filesystem or document access

Method

This report combines public metadata, AI review output, repository freshness, install readiness, OpenAgentSkill events, quality scoring, trust checks, and the agent safety gate. It is not a full source-code security review.

Install path

Review the report before installing into production agents.

$ npx skills add supabase/agent-skills --skill supabase-postgres-best-practices

Agent-readable metadata

Machine decision packet

Embedded JSON exposes suited tasks, suited agents, install command, trust score, safety gate, alternatives, and do-not-use conditions for agent review.

Install policy: review
Best agents: Codex + Claude Code
Alternatives: 3

Open agent JSON

Signals

Audit score: 78/100
Quality: 78/100
Trust: 70/100
Install safety: 92/100
Permission surface: 48/100
Maintenance: 3mo since push
Events: 21 events
GitHub stars: 2.6K
Last push: Aug 12, 2026

Agent safety v2

46/100 · Avoid automatic install

Experimentalreview

Sparse or mixed signals. Useful for discovery, but not for autonomous installation.

Test manually in an isolated workspace and compare against safer alternatives.

High-risk permission hints: Secrets or environment access
46/100 agent safety score

Network access

medium

Skill likely fetches remote pages, APIs, repositories, or external services.

Filesystem access

medium

Skill may read or write project files, documents, generated artifacts, or local workspace state.

Secrets or environment access

high

Skill metadata references credentials, tokens, environment variables, or secret-bearing workflows.

Database access

medium

Skill may inspect schemas, query databases, or work with persistent stores.

High-risk permission hints: Secrets or environment access
Permission surface may require sandboxing

Back to skill Alternatives Audit badge SVG

Compare nearby options

Related skills to audit next

Wazuh

Wazuh - The Open Source Security Platform. Unified XDR and SIEM protection for endpoints and cloud workloads.

16K Stars · Audit report

Maigret

🕵️‍♂️ Collect a dossier on a person by username from 3000+ sites

33K Stars · Audit report

Nuclei

Nuclei is a fast, customizable vulnerability scanner powered by the global security community and built on a simple YAML-based DSL, enabling collaboration to tackle trending vulnerabilities on the internet. It helps you find vulnerabilities in your applications, APIs, networks, DNS, and cloud configurations.

29K Stars · Audit report