CtrlK
BlogDocsLog inGet started
Tessl Logo

supabase-postgres-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.

69

1.08x
Quality

67%

Does it follow best practices?

Impact

90%

1.08x

Average score across 2 eval scenarios

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./plugins/build-web-apps/skills/supabase-best-practices/SKILL.md

The canonical home for this skill is supabase-postgres-best-practices in supabase/agent-skills

SKILL.md
Quality
Evals
Security

Quality

Content

61%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The body is an efficient, well-structured index for a large rule bundle: a clear priority table with filename prefixes, explicit applicability conditions, and verified one-level-deep references. Its weaknesses are navigational rather than structural — no explicit rule-selection workflow, only three example paths out of 35 rule files, and no validation checkpoint guidance for applying the SQL rules.

Suggestions

Add a short rule-selection step, e.g. "identify the task's category from the prefix table, then open references/<prefix>-<topic>.md" with one worked example (slow query → query-missing-indexes.md).

List the full set of rule files (or per-category file listings) instead of only three example paths, so Claude can navigate without guessing filenames.

Include a brief verification checkpoint for applied changes, e.g. confirming improvements with EXPLAIN ANALYZE or pg_stat_statements (monitor- prefixed rules), which the current workflow omits.

DimensionReasoningScore

Conciseness

The body is lean: a priority table, six short trigger bullets, and a brief description of the rule-file format, with no padding or explanations of concepts Claude already knows. It misses anchor 5 only because the opening paragraph and "When to Apply" bullets restate the frontmatter abstract/description, a small redundancy that could be trimmed.

4 / 5

Actionability

Guidance is structural rather than executable: "Read individual rule files for detailed explanations and SQL examples" plus a prefix naming convention and three example paths. The convention lets Claude infer file names, but the body never says how to map a task to a specific rule file, and only 3 of the 35 reference files are shown — matching anchor 3's 'some concrete guidance but incomplete' rather than anchor 4's mostly-executable direction.

3 / 5

Workflow Clarity

There is no sequenced procedure: the implied flow is "check When to Apply → find the relevant rule file → apply it", but which rule file to open for a given problem (e.g. a slow query vs. pool exhaustion) is left implicit, and no validation or verification steps are described. Per the simple-skill exception this could score higher, but the single action — selecting the right reference — is ambiguous, capping it at anchor 3.

3 / 5

Progressive Disclosure

SKILL.md is a genuine overview: a category/priority/prefix table, a description of each rule file's contents, and one-level-deep references (references/query-missing-indexes.md, references/schema-partial-indexes.md, references/_sections.md — all verified to exist) alongside 35 flat rule files. It falls short of anchor 5 because only three arbitrary example paths are listed rather than a complete or per-category index, and meta files (_contributing.md, _template.md) are present in the bundle but unexplained.

4 / 5

Total

14

/

20

Passed

Description

73%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A solid description with an explicit and multi-trigger "Use this skill when..." clause covering queries, schemas, and configurations in a well-delineated Supabase/Postgres niche. Its main weakness is a generic "performance optimization and best practices" what-clause that never names a concrete action, and missing common synonyms like "SQL" or "indexes".

Suggestions

Replace the generic "performance optimization and best practices" with two or three concrete actions, e.g. "optimize slow queries, design indexes, and configure connection pooling for Postgres/Supabase".

Add natural synonyms users would say, such as "SQL", "slow queries", "indexes", or "Row-Level Security (RLS)", to the trigger clause to widen recall.

DimensionReasoningScore

Specificity

The description names the domain ("Postgres performance optimization and best practices from Supabase") and the artifacts it covers ("Postgres queries, schema designs, or database configurations"), but the actions themselves are generic — "optimization and best practices" names no concrete operations like index creation, pooling configuration, or RLS tuning. It sits between anchor 2 (generic actions) and anchor 3 (1-2 concrete actions), matching anchor 3's breadth of scope without anchor 4's specific action list.

3 / 5

Completeness

The "when" is explicit and concrete ("Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations") with multiple trigger activities, and the "what" is stated ("Postgres performance optimization and best practices from Supabase"). It falls short of anchor 5 only because the "what" is a single generic capability rather than multiple concrete actions, matching anchor 4's 'when could be more specific / what is adequate' profile.

4 / 5

Trigger Term Quality

Natural trigger terms are present: "Postgres", "queries", "schema designs", "database configurations", "performance", and "Supabase" — phrases a user would plausibly say. Common synonyms like "SQL", "slow queries", "indexes", or "database performance" are missing, which keeps it below anchor 5's comprehensive synonym and extension coverage.

4 / 5

Distinctiveness Conflict Risk

The Supabase/Postgres performance niche is clearly staked with distinct triggers (Postgres queries, schema design, database configuration), and the Supabase attribution further narrows it. Overlap with generic SQL or database-admin skills is minimal, matching anchor 5.

5 / 5

Total

16

/

20

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

referenced_paths_exist

Referenced path issues: 1 missing

Warning

Total

15

/

16

Passed

Repository
openai/plugins
Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.