CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

postgresql-best-practices-cloudbase

CloudBase PostgreSQL access-pattern and slow-query quality guidance. Use when designing how tables are read and written, eliminating per-row database calls, adding indexes for filters or joins, reviewing high-traffic data access, or explaining a slow SQL query. Not for first-time PG SDK setup, login UI, or NoSQL collections.

Quality

94%

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

The canonical home for this skill is postgresql-best-practices-cloudbase in TencentCloudBase/CloudBase-AI-Toolkit

SKILL.md
Quality
Evals
Security

Quality

Content

96%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 tight, highly actionable review-workflow skill: concrete SQL/TS examples, per-step completion checkpoints, a closing self-check, and a clean branch-routing table to real, right-sized reference files. The only structural weakness is cross-skill chained references introducing a second hop beyond the skill's own bundle.

DimensionReasoningScore

Conciseness

The ~90-line body is lean with no padding: no known-concept teaching appears (e.g., 'Use the role as the policy gate and identity as the row predicate' is dense platform-specific guidance, not PG basics), and code snippets are minimal but complete. Every section — workflow, routing, self-check — earns its tokens.

5 / 5

Actionability

Guidance is executable throughout: a copy-paste-ready RLS policy ('CREATE POLICY orders_select_own ON public.orders FOR SELECT TO authenticated USING...'), a concrete TS batching snippet using .in('id', userIds), and a specific inspection call 'queryEnv(action="info", envId=...)'. The routing table maps each branch to an exact file.

5 / 5

Workflow Clarity

Four numbered steps each end with an explicit '**Complete when:**' validation checkpoint, and a 'Minimum self-check' checklist closes the process, matching the anchor for clear sequence plus explicit validation and checklists. Validation is present for the migration/DDL path, so the destructive/batch cap does not apply.

5 / 5

Progressive Disclosure

The routing table ('Repeated calls, serial queries, polling... → references/access-patterns.md') is well-signaled and all four referenced files exist at appropriate sizes (58–104 lines), with 'Load only the references required by the current branch.' However, references/schema-and-rls.md and references/capacity-and-connections.md chain on to sibling-skill references (e.g., '../postgresql-development-cloudbase/references/auth-and-rls.md'), a second hop that keeps this short of fully one-level-deep.

4 / 5

Total

19

/

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 strong description with concrete, comprehensive action coverage, an explicit multi-trigger 'Use when' clause, and clear negative boundaries against sibling skills. Its only gap is a few natural synonyms (e.g., 'N+1', 'query optimization') that users might phrase differently.

DimensionReasoningScore

Specificity

The description lists five concrete actions — 'designing how tables are read and written, eliminating per-row database calls, adding indexes for filters or joins, reviewing high-traffic data access, or explaining a slow SQL query' — within a named domain (CloudBase PostgreSQL). Coverage is comprehensive rather than having the minor gaps of the 4 anchor.

5 / 5

Completeness

Both what ('CloudBase PostgreSQL access-pattern and slow-query quality guidance') and when are explicitly answered: an explicit 'Use when...' clause enumerates five concrete triggers, and a negative boundary ('Not for first-time PG SDK setup, login UI, or NoSQL collections') further delimits usage, matching the anchor for concrete trigger phrases on both questions.

5 / 5

Trigger Term Quality

Natural trigger phrases are present and specific — 'slow SQL query', 'adding indexes for filters or joins', 'per-row database calls', 'high-traffic data access' — but common user phrasings like 'query optimization', 'N+1 queries', or 'database performance' are missing, matching the good-but-incomplete keyword coverage anchor.

4 / 5

Distinctiveness Conflict Risk

'CloudBase PostgreSQL' carves a clear niche, and the explicit exclusions ('Not for first-time PG SDK setup, login UI, or NoSQL collections') steer away from the sibling development, auth, and document-database skills, giving minimal conflict risk.

5 / 5

Total

19

/

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

frontmatter_unknown_keys

Unknown frontmatter key(s) found; consider removing or moving to metadata

Warning

Total

15

/

16

Passed

Repository

TencentCloudBase/CloudBase-AI-Toolkit

Path

config/.claude/skills/postgresql-best-practices-cloudbase/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.