CtrlK
BlogDocsLog inGet started
Tessl Logo

postgres-expert

PostgreSQL expert for query optimization, indexing, extensions, and database administration

65

Quality

77%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./crates/openfang-skills/bundled/postgres-expert/SKILL.md
SKILL.md
Quality
Evals
Security

Quality

Content

87%

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

The body is concise, highly actionable, and well-organized for a knowledge-style skill with no bundle files. Its main weakness is workflow clarity: guidance is principle-based rather than a clearly sequenced process with explicit validation checkpoints.

Suggestions

For destructive or batch operations (e.g. bulk loads, VACUUM, schema migrations), present an explicit ordered workflow with validate-then-proceed checkpoints rather than listing them as standalone principles.

DimensionReasoningScore

Conciseness

The body is lean and assumes Claude's competence — it jumps straight into concrete guidance like 'EXPLAIN (ANALYZE, BUFFERS, FORMAT TEXT)' and JSONB operators without explaining basic PostgreSQL concepts.

3 / 3

Actionability

Provides fully executable SQL and commands throughout, e.g. 'CREATE INDEX ON orders (created_at) WHERE status = \'pending\'' and 'INSERT ... ON CONFLICT (key) DO UPDATE SET ...', copy-paste ready.

3 / 3

Workflow Clarity

Sequencing exists implicitly ('Always analyze query plans ... before and after optimization') but validation checkpoints are scattered across principles rather than presented as a coherent multi-step workflow with explicit feedback loops.

2 / 3

Progressive Disclosure

Under 50 lines with no need for external references, and content is organized into clear, well-signaled sections (Key Principles, Techniques, Common Patterns, Pitfalls) — satisfying the simple-skill allowance for a top score.

3 / 3

Total

11

/

12

Passed

Description

67%

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

The description is specific and clearly scoped to a PostgreSQL niche, but it lacks an explicit 'Use when...' trigger clause and misses several natural phrasings users would actually say. Adding trigger guidance would lift the completeness and trigger-term dimensions.

Suggestions

Add an explicit 'Use when...' clause, e.g. 'Use when optimizing slow PostgreSQL queries, designing indexes, or administering a Postgres database.'

Include common user phrasings such as 'slow queries', 'database performance', and 'Postgres tuning' alongside the current capability list.

DimensionReasoningScore

Specificity

Lists multiple concrete action areas — 'query optimization, indexing, extensions, and database administration' — naming the domain and several specific capabilities rather than vague language.

3 / 3

Completeness

Answers 'what' clearly (PostgreSQL expert for optimization/indexing/admin) but has no 'Use when...' clause or explicit trigger guidance, which caps completeness at 2 per the rubric.

2 / 3

Trigger Term Quality

Contains relevant terms like 'query optimization' and 'indexing' that users would say, but misses common variations such as 'slow queries', 'database performance', or 'PostgreSQL tuning'.

2 / 3

Distinctiveness Conflict Risk

Scoped specifically to PostgreSQL with distinct operational triggers, making it unlikely to fire for unrelated skills.

3 / 3

Total

10

/

12

Passed

Validation

100%

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

Validation16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository
RightNow-AI/openfang
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.