CtrlK
BlogDocsLog inGet started
Tessl Logo

schema-exploration

Explore an existing PostgreSQL database before answering questions about its data or writing SQL. Use this skill whenever a user asks for a query or a data-backed answer against an unfamiliar schema (counts, missing or failed records, recent changes), asks where a business concept lives, or asks how tables, joins, views, routines, triggers, RLS, or extensions work. Find the relevant objects with read-only pg_catalog queries, then request approval before inspecting data-derived statistics or rows. Not a schema-design or migration guide.

76

Quality

95%

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

SKILL.md
Quality
Evals
Security

Quality

Content

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

Exemplary skill body: a lean overview with a clear sequenced workflow, explicit approval and validation checkpoints, and a well-organized one-level-deep reference bundle containing complete executable catalog queries. Nothing in the body is wasted or misplaced.

DimensionReasoningScore

Conciseness

The ~26-line body is dense and lean with zero padding: every sentence adds non-obvious expert guidance (e.g., 'A function marked STABLE or IMMUTABLE is not a safety guarantee', 'placeholders cannot replace SQL identifiers in data queries') and none of it re-explains what Claude already knows.

5 / 5

Actionability

The body gives concrete directives ('Check server_version_num first', 'use a read-only transaction and a reasonable statement timeout', 'validate a vetted read-only query with plain EXPLAIN') and delegates executable queries to reference files that verifiably contain complete, copy-paste-ready SQL with consistent $1/$2 placeholder conventions — appropriate and actionable for an instruction-only skill.

5 / 5

Workflow Clarity

A clear 5-step workflow with explicit checkpoints and feedback loops: approval required before data-derived values, 'Ask the user when semantics remain ambiguous', 'If a query fails due to permissions or version differences, report the limitation instead of guessing', and a stop condition ('Stop once you can answer').

5 / 5

Progressive Disclosure

The body is a concise overview with well-signaled, verified one-level-deep references — all 12 linked files exist and match their roles (tables, views, routines, triggers, security, extensions, etc.), with cross-references between siblings explicitly gated ('Follow cross-references only when the question requires them').

5 / 5

Total

20

/

20

Passed

Description

91%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 strong description: third-person, concrete, with an explicit 'Use this skill whenever' trigger clause enumerating natural user phrasings and a clear negative boundary. The only weaknesses are a slightly narrow action list and some trigger overlap with generic SQL-authoring skills.

DimensionReasoningScore

Specificity

Names the domain ('Explore an existing PostgreSQL database') and several concrete actions ('Find the relevant objects with read-only pg_catalog queries, then request approval before inspecting data-derived statistics or rows'). A 5 would require a more comprehensive catalog of specific capabilities, while a 3 would undercount the paired query-then-approval actions described.

4 / 5

Completeness

Explicitly answers what ('Find the relevant objects with read-only pg_catalog queries, then request approval...') and when ('Use this skill whenever a user asks for a query or a data-backed answer against an unfamiliar schema...') with concrete trigger phrases, and adds a boundary clause ('Not a schema-design or migration guide').

5 / 5

Trigger Term Quality

Covers natural user phrasings comprehensively: 'asks for a query or a data-backed answer', 'counts, missing or failed records, recent changes', 'where a business concept lives', 'how tables, joins, views, routines, triggers, RLS, or extensions work', plus 'PostgreSQL' and 'unfamiliar schema'. Includes synonyms across the full range of trigger scenarios, so the anchor-4 example of missing natural terms does not apply.

5 / 5

Distinctiveness Conflict Risk

Clear niche with a distinct trigger set and an explicit negative boundary ('Not a schema-design or migration guide'), but 'whenever a user asks for a query' and SQL-writing language overlap with generic SQL-authoring skills, so minor conflict risk remains rather than the minimal risk of a 5.

4 / 5

Total

18

/

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

metadata_version

'metadata.version' is missing

Warning

Total

15

/

16

Passed

Repository
timescale/pg-aiguide
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.