CtrlK
BlogDocsLog inGet started
Tessl Logo

alonso-skills/postgres

Comprehensive PostgreSQL reference for developers and DBAs covering versions 14–18. Use whenever the user asks about PostgreSQL syntax, DDL/DML/DQL, joins, LATERAL, CTEs, window functions, GROUPING SETS, DISTINCT ON, RETURNING, ON CONFLICT, PL/pgSQL, functions, procedures, triggers, views, materialized views, indexes (B-tree/GIN/GiST/BRIN/Hash/Bloom), MVCC, VACUUM, autovacuum, WAL, TOAST, partitioning, replication (streaming/logical), backup, PITR, HA (Patroni/repmgr), pgBouncer, EXPLAIN ANALYZE, RLS, roles, extensions (pgvector, PostGIS, TimescaleDB, Citus, pg_trgm, pg_cron), JSON/JSONB, full-text search, UUID, timestamptz, COPY, system catalogs, collations, large objects, cursors, GUC, or any Postgres administration, performance, security, replication, backup, or recovery topic.

75

Quality

94%

Does it follow best practices?

Impact

No eval scenarios have been run

SecuritybySnyk

Passed

No known issues

Overview
Quality
Evals
Security
Files

Quality

Content

85%

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

This is a well-architected skill that serves as a comprehensive routing layer for a massive PostgreSQL knowledge base. Its greatest strengths are the exhaustive routing table with keyword matching, the disambiguation tips for multi-file questions, and the clear progressive disclosure pattern delegating all detail to reference files. The main weakness is moderate verbosity — the file could be tightened by consolidating some repeated guidance — but given the breadth of 102 reference files being routed, the length is largely justified.

DimensionReasoningScore

Conciseness

The routing table and disambiguation tips are comprehensive and useful, but the file is quite long (~300 lines) with some redundancy between the routing table and disambiguation table. The versioning/provider neutrality section repeats guidance already stated in the intro. However, most content earns its place as a routing mechanism, and there's minimal explanation of concepts Claude already knows.

2 / 3

Actionability

The workflow is concrete and executable: identify topic → load specific reference file via Read tool → follow See Also → answer with specific format. The routing table provides exact file paths, and the response format section gives precise formatting instructions including admonition syntax and EXPLAIN plan reading guidance. The skill delegates executable detail to reference files appropriately.

3 / 3

Workflow Clarity

The 6-step usage workflow is clearly sequenced with explicit decision points (step 6: when to ask user about version). The disambiguation table handles ambiguous routing with primary/secondary file guidance and rationale. The NOTE callout provides fallback cross-cutting entry points for questions that don't match a single file. The workflow has clear validation: 'Never answer from memory alone when a reference file exists.'

3 / 3

Progressive Disclosure

This is an exemplary routing document: SKILL.md serves purely as an overview and dispatcher, with all executable detail living in 102 separate reference files under `references/`. References are one level deep, clearly signaled with both file paths and scope descriptions. The See Also mechanism in reference files provides lateral navigation without deep nesting.

3 / 3

Total

11

/

12

Passed

Description

100%

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

This is an excellent skill description that thoroughly covers what the skill does (comprehensive PostgreSQL reference for versions 14-18) and when to use it (explicit 'Use whenever...' clause with an exhaustive list of trigger terms). The description is highly specific, uses natural keywords that developers and DBAs would actually use, and is clearly distinguishable from other skills. The only minor concern is that the description is quite long, but the density of useful trigger terms justifies the length.

DimensionReasoningScore

Specificity

The description lists an extensive set of concrete capabilities and topics: DDL/DML/DQL, joins, LATERAL, CTEs, window functions, specific index types, MVCC, VACUUM, PL/pgSQL, partitioning, replication types, specific extensions, and many more. This goes well beyond naming a domain and some actions.

3 / 3

Completeness

Clearly answers both 'what' (comprehensive PostgreSQL reference covering versions 14-18) and 'when' with an explicit 'Use whenever the user asks about...' clause followed by an exhaustive list of trigger topics. This is a textbook example of completeness.

3 / 3

Trigger Term Quality

Excellent coverage of natural terms users would say: 'PostgreSQL', 'Postgres', 'EXPLAIN ANALYZE', 'pgBouncer', 'PostGIS', 'pgvector', 'JSONB', 'full-text search', 'VACUUM', 'WAL', 'replication', 'backup', 'window functions', 'CTEs', etc. These are exactly the terms developers and DBAs would use in queries.

3 / 3

Distinctiveness Conflict Risk

Highly distinctive with a clear niche: PostgreSQL-specific topics. The mention of PostgreSQL/Postgres-specific features (PL/pgSQL, MVCC, VACUUM, autovacuum, WAL, TOAST, Patroni, repmgr, pgBouncer, PostGIS, pgvector, etc.) makes it very unlikely to conflict with skills for other databases or general-purpose tools.

3 / 3

Total

12

/

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.

Validation11 / 11 Passed

Validation for skill structure

No warnings or errors.

Reviewed

Table of Contents