CtrlK
BlogDocsLog inGet started
Tessl Logo

database-operation

Use this skill when you need to inspect, query, maintain, or carefully modify the MoviePilot database. This skill uses the bundled scripts/mp-db.py helper, which reads MoviePilot local settings itself and never requires database passwords or full PostgreSQL DSNs in the agent prompt. Applicable scenarios include data statistics, counts, aggregations, inspecting or fixing records, cleanup requests, and questions like "how many downloads", "show site stats", "delete old records", or "why is this subscription stuck".

75

Quality

93%

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

87%Weight 40%Scale 1-3

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

A well-structured, actionable skill body that avoids concept-padding and supplies executable commands plus a useful inline schema reference. The main gap is the lack of an explicit write-then-verify feedback loop for destructive database operations, which caps workflow clarity.

Suggestions

Add an explicit validation checkpoint to the Workflow for write operations, e.g. after 'write', verify the affected row count matches expectation and re-query to confirm the change before reporting success, with a rollback/fix-and-retry path if it does not match.

Consolidate the overlapping 'Built-in Safety' and 'Safety Rules' sections to remove the duplicated 'query --write' compatibility note and tighten the read-only vs write distinction into one place.

For destructive statements (DELETE/DROP/TRUNCATE), make the backup step part of the numbered workflow rather than only a safety rule, so the validate->backup->write->verify loop is unambiguous.

DimensionReasoningScore

Conciseness

The body is lean and assumes Claude's competence — no padding about what SQL or a database is — and the bulk of tokens are high-value schema reference (Core Tables columns, Common Queries, SQL Dialect Notes) that Claude cannot know. There is minor overlap between 'Built-in Safety' and 'Safety Rules' but no concept-explanation bloat.

3 / 3

Actionability

Commands section provides fully executable invocations (e.g. 'python scripts/mp-db.py tables', 'schema downloadhistory', 'query ...', 'write ...') and Common Queries supplies copy-paste-ready SQL, matching the 'fully executable; copy-paste ready' anchor.

3 / 3

Workflow Clarity

The Workflow lists a clear sequence (tables -> schema -> query -> write) with safety guidance, but lacks an explicit validate-then-fix-then-retry feedback loop; per the rubric's scoring notes, database operations are capped at 2 when feedback loops are missing.

2 / 3

Progressive Disclosure

Content is organized into well-labeled sections and references the single bundled script 'scripts/mp-db.py' one level deep (verified to exist) with no nested references, providing easy navigation.

3 / 3

Total

11

/

12

Passed

Description

100%Weight 40%Scale 1-3

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, specific description that states concrete database actions, gives natural user-trigger phrasings, and clearly answers both what the skill does and when to use it. It is well-differentiated from adjacent MoviePilot skills.

DimensionReasoningScore

Specificity

The description lists multiple concrete actions — 'inspect, query, maintain, or carefully modify the MoviePilot database' plus 'data statistics, counts, aggregations, inspecting or fixing records, cleanup requests' — matching the 'lists multiple specific concrete actions' anchor.

3 / 3

Completeness

It answers both what and when explicitly via 'Use this skill when you need to inspect, query, maintain, or carefully modify the MoviePilot database' followed by 'Applicable scenarios include ...' with example trigger questions.

3 / 3

Trigger Term Quality

It includes natural phrasings a user would actually say, such as 'how many downloads', 'show site stats', 'delete old records', and 'why is this subscription stuck', giving good coverage of common variations.

3 / 3

Distinctiveness Conflict Risk

The description carves out a clear niche — direct MoviePilot database access via a bundled helper — with distinct triggers, making it unlikely to fire for the wrong skill.

3 / 3

Total

12

/

12

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.

Validation15 / 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
jxxghp/MoviePilot
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.