CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

postgres-commit-history-article

Analyze PostgreSQL git commit history between two commit ids and, when valuable DBA/application-developer changes exist, write a Chinese Markdown article for WeChat/公众号 readers with examples checked against SQL tests, docs, or relevant source. Use when the user is inside a PostgreSQL source checkout and provides two commit ids, asks to interpret Postgres commits, summarize a release/development window, identify DBA/application-developer value from commit logs, group related commits, exclude reverted commits, and either output a sourced article under the current project's markdown directory or return a no-article analysis when no valuable commits are present.

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 strong, highly actionable skill body: an explicitly sequenced workflow with real validation checkpoints and error-recovery fallbacks, concrete git/python commands, and verified example-evidence requirements. Its main weakness is redundancy — the same rules (no code diffs, verify examples, revert exclusion) are stated in the Goal, the Workflow, and again in Quality Rules, and the large inlined article templates could be split into a reference file.

Suggestions

Collapse the Goal section into 2-3 sentences or fold it into Workflow — it currently restates the workflow steps and quality rules that appear again later (conciseness).

Deduplicate rules stated in both the Workflow and Quality Rules sections (e.g., 'do not analyze code diffs' / 'do not include code diffs' and example-verification) — keep one authoritative location and reference it (conciseness).

Move the Required Article Structure, Article Outline, and No-Article Output templates into a references/article-templates.md file and link to it from SKILL.md, leaving the main body a lean overview (progressive_disclosure).

DimensionReasoningScore

Conciseness

The body assumes Claude's competence (no explanations of git or PostgreSQL basics) but repeats the same rules in multiple places: 'Do not analyze code diffs' appears in Goal, step 5, and Quality Rules ('Do not include code diffs'); example verification appears in both step 6 and 'Do not write SQL or command examples from memory alone'; the Goal section largely restates the workflow that follows. This fits 'mostly efficient but includes some unnecessary explanation or could be tightened' rather than 4, where redundancy would be minor.

3 / 5

Actionability

Fully executable throughout: a concrete collector invocation ('python3 .../scripts/collect_pg_commits.py commitid1 commitid2 --output markdown/postgres-commit-range.json'), exact git commands ('git rev-parse --verify <commitid1>^{commit}', 'git log --reverse --format=%h%x09%an... --date=short <older>^..<newer>'), specific evidence paths (src/test/regress/sql/, doc/src/sgml/), and complete output templates. Matches the copy-paste-ready anchor with common cases covered.

5 / 5

Workflow Clarity

A clear 7-step sequence with explicit validation checkpoints and feedback loops: verify the checkout looks like PostgreSQL (step 1), 'If the order is unclear, test both ancestry directions... otherwise ask for clarification' (Inputs), an early no-article exit (step 3), and evidence verification before any example is written with a fallback ('If tests/docs/source do not provide enough confidence, do not fabricate a runnable SQL example'). Checklists (落地清单) are built into the required output. Matches the 5 anchor.

5 / 5

Progressive Disclosure

Good structure: sections are clearly headed, and the single bundle file (scripts/collect_pg_commits.py, verified present) is referenced with an explicit path and a description of what its JSON contains. Not 5 because ~60 lines of inlined output templates (Required Article Structure, Article Outline, No-Article Output) could live in a references/ file, keeping SKILL.md a leaner overview.

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, complete, and distinctive description with explicit what/when structure and third-person voice throughout. The only weakness is that the trigger clause bundles many phrases into one long run-on sentence, which also makes the description verbose overall — it could be tightened without losing coverage.

DimensionReasoningScore

Specificity

Lists multiple concrete actions — 'Analyze PostgreSQL git commit history between two commit ids', 'write a Chinese Markdown article', 'examples checked against SQL tests, docs, or relevant source', 'group related commits, exclude reverted commits', 'return a no-article analysis' — covering analysis, authoring, verification, and fallback comprehensively. It is not score 4 because coverage has no minor gaps; every capability of the skill is named.

5 / 5

Completeness

Both parts are explicit: the 'what' ('Analyze PostgreSQL git commit history... write a Chinese Markdown article... with examples checked against SQL tests, docs, or relevant source') and a concrete 'when' ('Use when the user is inside a PostgreSQL source checkout and provides two commit ids, asks to interpret Postgres commits...'). Matches the 5 anchor exactly.

5 / 5

Trigger Term Quality

Natural user phrasings are well covered: 'interpret Postgres commits', 'summarize a release/development window', 'provides two commit ids', 'commit logs', 'reverted commits'. Not 5 because a few common variations users would say — 'git log', 'changelog', 'release notes', 'PG' — are absent.

4 / 5

Distinctiveness Conflict Risk

A clear niche — PostgreSQL commit-range analysis producing a Chinese WeChat article for DBAs/developers — with distinct triggers ('two commit ids', 'Postgres commits') that would rarely fire for another skill. Not 4 because there is no meaningful overlap with closely related 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/postgres-commit-history-article/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.