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".

Quality

89%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

Securityby

Low

Low-risk findings worth noting

Quality

Content

82%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 highly actionable, well-structured database-operation skill with concrete commands, real bundled tooling, and solid safety guidance. The two soft spots are the inline schema catalog that would benefit from a separate reference file and a post-write verification loop that is implicit rather than explicit.

Suggestions

Move the large Core Tables catalog (~30 tables with full column lists) into a references/TABLES.md file and keep only the most-used tables inline, with a clear pointer to the reference for the rest.

Add an explicit post-write verification step to the workflow (e.g., re-query the affected rows or have the managed API read the repaired value) to form a crisp validate->fix->retry loop for destructive writes.

Tighten the Workflow step 4 to call out a SELECT-before-write dry check for UPDATE/DELETE so the destructive-path validation checkpoint is unambiguous.

Dimension	Reasoning	Score
Conciseness	Information-dense with no padding of concepts Claude already knows; the only slack is the ~200-line Core Tables catalog with full column inventories that could be externalized to a reference file.	4 / 5
Actionability	Concrete, copy-paste-ready commands throughout (tables/schema/query/write subcommands) backed by the real bundled mp-db.py, plus a Common Queries section of executable SQL covering the common cases.	5 / 5
Workflow Clarity	A clear numbered workflow (prefer existing tools, tables-then-schema, narrow SELECT with LIMIT, write and report affected count) with built-in safety rules and inspect-before-write guidance; the post-write verify->fix->retry loop is present but somewhat implicit rather than a crisp checkpoint.	4 / 5
Progressive Disclosure	Well-organized into clear sections with the heavy executable logic properly externalized in scripts/mp-db.py; the main gap is the large inline Core Tables schema catalog that could live in a one-level-deep reference file.	4 / 5
	Total	17 / 20 Passed

Description

96%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, concrete description that names specific database actions, bundles natural trigger phrases users would actually say, and clearly answers both what and when. The only soft spot is a slight overlap risk with the sibling moviepilot-api skill that the description hints at but does not fully resolve.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete actions — 'inspect, query, maintain, or carefully modify' — plus enumerated scenarios (statistics, counts, aggregations, fixing records, cleanup), giving comprehensive coverage rather than vague abstraction.	5 / 5
Completeness	Explicitly answers both 'what' (inspect/query/maintain/modify the MoviePilot database via the bundled mp-db.py helper) and 'when' ('Use this skill when...') with concrete trigger phrases and example questions.	5 / 5
Trigger Term Quality	Includes natural user phrases quoted verbatim — 'how many downloads', 'show site stats', 'delete old records', 'why is this subscription stuck' — exactly what a user would say, with synonyms (statistics/counts/aggregations/stats).	5 / 5
Distinctiveness Conflict Risk	Scoped tightly to the MoviePilot database via a dedicated mp-db.py helper, a clear niche; minor overlap risk with the moviepilot-api structured-operations skill since the description alone does not fully carve that boundary.	4 / 5
	Total	19 / 20 Passed

Validation

93%

Warnings & errors only

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

Criteria	Description	Result
frontmatter_unknown_keys	Unknown frontmatter key(s) found; consider removing or moving to metadata	Warning

	Total	15 / 16 Passed

Repository: jxxghp/MoviePilot
Path: skills/database-operation/SKILL.md
Commit: 4f716c4

Reviewed: 3 days ago

Table of Contents

Discovery Implementation Validation

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.