CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

pgfaq

Answer PostgreSQL core database questions by researching the local postgres source tree, PostgreSQL documentation under doc/src/sgml, relevant source code, and DeepWiki repository knowledge for postgres/postgres; use when the user asks any PostgreSQL database behavior, internals, SQL, configuration, administration, performance, storage, planner, executor, replication, or documentation question and wants a sourced Markdown answer saved to the current project's markdown directory. Refuse questions about non-PostgreSQL-core projects, including PostgreSQL ecosystem plugins, extensions maintained outside postgres/postgres, external tools, drivers, cloud services, forks, or third-party products.

71

Quality

89%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Low

Low-risk findings worth noting

SKILL.md
Quality
Evals
Security

Quality

Content

81%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.

A well-structured, actionable workflow skill with an exemplary validate-and-revise loop. Its main weaknesses are duplicated scope/discipline guidance and a few spots where concrete examples (rg patterns, DeepWiki question phrasing) would make the guidance copy-paste ready.

Suggestions

Remove the duplicated refusal enumeration in the Scope section (and the overlapping Research Discipline bullets) — the frontmatter description already carries the out-of-scope list, so a single sentence stating the refusal rule would trim ~6 lines.

Add one concrete example each of a targeted search and a focused DeepWiki question (e.g., rg -n 'wal_level' doc/src/sgml/runtime-config-wal.sgml and asking DeepWiki 'How does wal_level affect physical replication?') so the research steps are copy-paste ready.

Specify the filename convention for the saved answer (e.g., kebab-case of the question, max ~60 chars) to remove ambiguity in step 7.

DimensionReasoningScore

Conciseness

The workflow is lean with no explanations of concepts Claude already knows, but the Scope refusal list duplicates the frontmatter description and the Research Discipline section reiterates workflow steps 3-6 (local docs as authority, DeepWiki as cross-check), leaving minor trims.

4 / 5

Actionability

Gives concrete commands (rg, git remote -v, git rev-parse --show-toplevel), the exact MCP tool mcp__deepwiki__ask_question with repoName: postgres/postgres, and a complete answer-format template; minor gaps remain, such as no example rg invocation, no example focused DeepWiki question, and the vague 'filesystem-safe filename derived from the question'.

4 / 5

Workflow Clarity

Seven clearly sequenced steps with an explicit stop-and-ask checkpoint in step 1 and a genuine validation feedback loop in step 6 (DeepWiki check, local re-check, revise, repeat until no material issues); the operation is non-destructive so no cap applies.

5 / 5

Progressive Disclosure

A single well-sectioned file (Scope, Required Workflow, Answer Format, Research Discipline) with no nested references and no bundle files, but at ~90 lines it exceeds the simple-skill threshold and inlines the full answer template plus duplicated scope text, leaving minor organization gaps.

4 / 5

Total

17

/

20

Passed

Description

92%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 highly specific, well-triggered description with clear what/when structure and explicit scope refusals. Its only weakness is moderate verbosity in one long sentence and a few missing natural trigger synonyms (indexing, tuning, query optimization).

DimensionReasoningScore

Specificity

Lists multiple concrete actions — researching the local postgres source tree, documentation under doc/src/sgml, DeepWiki repository knowledge for postgres/postgres, saving a sourced Markdown answer to the project's markdown directory, and refusing out-of-scope questions — with comprehensive coverage and no gaps; it stays in third person.

5 / 5

Completeness

Explicitly answers both what ('Answer PostgreSQL core database questions by researching the local postgres source tree... DeepWiki repository knowledge') and when ('use when the user asks any PostgreSQL database behavior, internals, SQL... question') with concrete trigger phrases.

5 / 5

Trigger Term Quality

Good keyword coverage across 'database behavior, internals, SQL, configuration, administration, performance, storage, planner, executor, replication, or documentation', but a few natural user terms are missing (e.g., indexing, query optimization, tuning, vacuum/WAL) and no synonyms-with-extensions coverage, so it falls just short of the comprehensive anchor.

4 / 5

Distinctiveness Conflict Risk

Occupies a clear niche (PostgreSQL core in postgres/postgres) and explicitly refuses 'plugins, extensions maintained outside postgres/postgres, external tools, drivers, cloud services, forks, or third-party products', minimizing conflict with adjacent database or ecosystem skills.

5 / 5

Total

19

/

20

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.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

digoal/blog

Path

skills/pgfaq/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.