CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

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.

1.25x
Quality

67%

Does it follow best practices?

Impact

89%

1.25x

Average score across 3 eval scenarios

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./plugins/antigravity-bundle-data-analytics/skills/postgres-best-practices/SKILL.md

The canonical home for this skill is postgres-best-practices in administrakt0r/AI-Agents-Safe-Coding-Skills

SKILL.md
Quality
Evals
Security

Quality

Content

42%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 has a sensible index-style design (priority table, per-category prefixes, signaled references), but it is undermined by referencing bundle files (rules/*.md, AGENTS.md) that are absent, providing no actionable content of its own, and ending with a duplicated, vacuous "When to Use" section. As shipped, the skill directs Claude to files that do not exist.

Suggestions

Ship the referenced bundle files (rules/query-missing-indexes.md, rules/schema-partial-indexes.md, rules/_sections.md, and AGENTS.md) or remove the references — as delivered, every pointer in the body is dangling and the skill has no usable content.

Delete the duplicate trailing "When to Use" section and its filler sentence ("This skill is applicable to execute the workflow or actions described in the overview.") — it duplicates the earlier section and conveys nothing.

Add one concrete worked example to the body (e.g., a single rule with incorrect SQL, correct SQL, and its EXPLAIN signal) so the skill is actionable even before the reader opens a rule file.

DimensionReasoningScore

Conciseness

The body is short and mostly efficient (priority table, terse bullets), but it contains a duplicated "When to Use" heading and a vacuous filler sentence ("This skill is applicable to execute the workflow or actions described in the overview.") that add tokens without information. This matches 'mostly efficient but could be tightened'; it is not a 2 because the padding is limited to one redundant section rather than several.

3 / 5

Actionability

The body only describes rather than instructs: "Contains rules across 8 categories", "Each rule file contains: Brief explanation... Correct SQL example...". There is no executable guidance (no SQL, no commands, no concrete rule) in the body itself, and the referenced rule files (rules/query-missing-indexes.md, rules/schema-partial-indexes.md, AGENTS.md) do not exist in the bundle, so even the navigation guidance cannot be followed. This fits 'minimal concrete guidance; high-level hints but missing the specific steps to execute'; not a 1 because the category/priority table with prefixes is concrete navigational guidance.

2 / 5

Workflow Clarity

An implied lookup workflow exists (consult the priority table, then read the relevant rule file, with AGENTS.md as the compiled fallback), but the sequence is implicit, the referenced files are missing, and the duplicate "When to Use" section with a meaningless sentence muddies the structure. This matches 'sequence present but checkpoints missing or implicit'; not a 2 because the priority table does give a clear prioritization scheme.

3 / 5

Progressive Disclosure

The body is structured as an index with one-level-deep references that are clearly signaled (paths listed in a code block, a dedicated "Full Compiled Document" section), but none of the referenced files exist in the bundle — there is no rules/ directory and no AGENTS.md — so the disclosure structure is broken in practice. Per the guideline to score against the actual bundle structure, this lands at 'some structure but could be better organized'; not a 4 because dangling references are more than a minor organization gap.

3 / 5

Total

11

/

20

Passed

Description

78%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, well-structured description with an explicit 'Use this skill when...' trigger clause and domain-specific keywords. The main weakness is a somewhat generic capability statement ('best practices') and missing common synonyms like SQL and PostgreSQL.

DimensionReasoningScore

Specificity

The description names the domain ("Postgres performance optimization") and gestures at concrete activities ("writing, reviewing, or optimizing Postgres queries, schema designs"), but the core capability statement rests on the generic phrase "best practices" rather than enumerating what the skill actually does, matching the 'domain plus 1-2 concrete actions, not comprehensive' anchor. It is above anchor 2 because it goes beyond a single generic action attached to the domain, but below anchor 4 because the 'what' clause itself lacks specific capability coverage.

3 / 5

Completeness

It explicitly answers both questions: what ("Postgres performance optimization and best practices from Supabase") and when ("Use this skill when writing, reviewing, or optimizing Postgres queries, schema designs, or database configurations") with concrete trigger phrases, mirroring the anchor-5 pattern. Not below 4 because the 'when' clause is fully explicit, not weakly implied.

5 / 5

Trigger Term Quality

Natural trigger terms are present and well chosen: "Postgres queries", "schema designs", "database configurations", "writing, reviewing, or optimizing" — phrasings a user would plausibly say. It falls short of anchor 5 because common synonyms like "SQL", "PostgreSQL", "indexes", or "slow queries" are absent.

4 / 5

Distinctiveness Conflict Risk

The Postgres/Supabase niche with triggers like "Postgres queries" and "schema designs" is mostly distinct with minimal conflict risk. It is not a 5 because generic SQL-optimization or database-administration skills would still overlap on these triggers, and no PostgreSQL-specific qualifiers (e.g., "PostgreSQL", "Postgres extensions") widen the distinction.

4 / 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

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

15

/

16

Passed

Repository

administrakt0r/AI-Agents-Safe-Coding-Skills

Path

plugins/antigravity-bundle-data-analytics/skills/postgres-best-practices/SKILL.md

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.