CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

prisma-expert

You are an expert in Prisma ORM with deep knowledge of schema design, migrations, query optimization, relations modeling, and database operations across PostgreSQL, MySQL, and SQLite.

Quality

62%

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

Fix and improve this skill with Tessl

tessl review fix ./plugins/AI-Agents-Safe-Coding-Skills-claude/skills/prisma-expert/SKILL.md

The canonical home for this skill is prisma-expert in administrakt0r/AI-Agents-Safe-Coding-Skills

SKILL.md
Quality
Evals
Security

Quality

Content

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

The content is well-structured and highly actionable, with concrete commands, code patterns, and a sensible diagnosis-to-fix workflow. Its weaknesses are token efficiency — large portions restate Prisma knowledge Claude already has plus one filler section — and the absence of any progressive disclosure: all playbook detail is inlined in a single long file with no references.

Suggestions

Move each playbook (schema, migrations, query optimization, connections, transactions) into a separate references/ file and keep only a one-line index per topic in SKILL.md, loading detail only when the issue category matches.

Cut content that restates standard Prisma knowledge (the include/select/$queryRaw ladder, $transaction API usage, the globalForPrisma singleton) in favor of project-specific judgments, and delete the circular 'When to Use' section.

Replace placeholder diagnosis steps ('use database-specific command', comment-only logging block) with the actual commands per provider, and add explicit post-fix verification steps after destructive operations (e.g., re-run 'npx prisma migrate status' after 'migrate resolve').

DimensionReasoningScore

Conciseness

The ~350-line body is noticeably verbose: it restates the persona from the frontmatter, inlines standard Prisma knowledge Claude already has (include/select patterns, $transaction usage, the globalForPrisma singleton), and ends with the pure filler sentence 'This skill is applicable to execute the workflow or actions described in the overview.' It exceeds the 'mostly efficient with some tightening' anchor at 3 because several whole sections add no knowledge Claude lacks.

2 / 5

Actionability

Mostly executable guidance: concrete commands ('npx prisma validate', 'npx prisma migrate diff --from-schema-datamodel ...', 'npx prisma migrate deploy') and complete TypeScript/Prisma code blocks for transactions, query logging, and connection config. Minor gaps keep it below 5: the migration-history check is a placeholder ('use database-specific command') and the query-logging 'diagnosis' block is only comments.

4 / 5

Workflow Clarity

A clear sequence is present: environment detection (version, provider, migrations, client generation) → identify issue category → check anti-patterns → progressive fixes (minimal/better/complete) → 'Validate with Prisma CLI and testing'. Validation checkpoints exist (prisma validate, migrate status, migrate diff), so the destructive-operation cap does not apply; the gap is the absence of explicit re-verify loops after destructive fixes (migrate reset, migrate resolve), which keeps it below 5.

4 / 5

Progressive Disclosure

The body has good section structure (consistent playbook format with Common Issues / Diagnosis / Prioritized Fixes / Resources), but it is a ~350-line monolith with no bundle files at all — each playbook (schema, migrations, queries, connections, transactions) is content that clearly belongs in separate reference files loaded on demand. This matches 'some structure but content that should be separate is inline'.

3 / 5

Total

13

/

20

Passed

Description

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

The description identifies a distinctive niche (Prisma ORM) with good domain keywords, but it is written as a second-person persona statement rather than a capability description with explicit trigger guidance. It lacks both concrete actions and any 'when to use' clause.

Suggestions

Rewrite in third person as concrete actions, e.g., 'Diagnoses and fixes Prisma ORM issues: schema design and validation, migration failures, N+1 queries, connection pooling, and transactions across PostgreSQL, MySQL, and SQLite.'

Add an explicit trigger clause, e.g., 'Use when working with Prisma schema files, prisma migrate commands, PrismaClient queries, or Prisma build/runtime errors.'

Remove the second-person framing ('You are an expert in...') from the description; persona voice belongs in the body, not the trigger description.

DimensionReasoningScore

Specificity

The description names the Prisma domain and several knowledge areas ('schema design, migrations, query optimization, relations modeling') but contains no concrete actions — it is a persona claim ('deep knowledge of'), not a capability statement. Per the judging guidelines, the second-person voice ('You are an expert in Prisma ORM') reduces the specificity score by 1 from its base of 2, yielding 1.

1 / 5

Completeness

The 'what' is reasonably clear (Prisma expertise covering schema, migrations, queries, connections), but there is no 'Use when...' clause or equivalent trigger guidance, which caps completeness at 3 per the judging guidelines. It is not a 4 because the 'when' is entirely absent rather than merely imprecise.

3 / 5

Trigger Term Quality

Good natural keyword coverage — 'Prisma ORM', 'schema design', 'migrations', 'query optimization', 'relations modeling' are phrases users would plausibly say. A few natural terms are missing (e.g., 'Prisma Client', '.prisma', 'N+1', 'connection pool'), which fits the 'good coverage, a few natural terms missing' anchor rather than the comprehensive anchor at 5.

4 / 5

Distinctiveness Conflict Risk

'Prisma ORM' anchors a clear niche with distinct triggers, but the trailing 'database operations across PostgreSQL, MySQL, and SQLite' is a broad capability claim that creates minor overlap risk with generic database/PostgreSQL expert skills. This places it at 'mostly distinct; minor overlap risk' rather than the minimal-conflict anchor at 5.

4 / 5

Total

12

/

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

administrakt0r/AI-Agents-Safe-Coding-Skills

Path

plugins/AI-Agents-Safe-Coding-Skills-claude/skills/prisma-expert/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.