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

88%

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

76%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 body is highly actionable and well-structured with executable commands and SQL examples, but the substantial inlined column listings modestly hurt conciseness and the lack of an explicit validation feedback loop for destructive writes caps workflow clarity. Overall a strong, practical skill body.

Suggestions

Add an explicit validation/feedback checkpoint to the Workflow for destructive writes—e.g. run a SELECT to preview affected rows, apply the write, then re-query to confirm the affected count—so destructive operations include a validate→fix→retry loop.

Consider moving the full per-table column listings into a separate reference file (e.g. references/tables.md) and keeping only the most-used tables inline, to reduce token load when only a subset is needed.

Signal optional deeper material explicitly (e.g. a one-line pointer to scripts/mp-db.py --help) so the bundled helper's full surface is discoverable without inlining it.

Dimension	Reasoning	Score
Conciseness	The body is mostly lean and assumes competence, but the large 'Core Tables' section inlines many column listings that pad tokens beyond what's strictly needed, keeping it just short of fully efficient.	4 / 5
Actionability	Every command is copy-paste ready (e.g. 'python scripts/mp-db.py tables', 'python scripts/mp-db.py query "SELECT ..."') and the Common Queries section provides executable SQL covering the common cases.	5 / 5
Workflow Clarity	A clear sequenced Workflow exists, but it caps at 3 because destructive/batch DB operations lack an explicit validate-feedback checkpoint—safety is described as rules rather than an enforced validate→fix→retry loop, and the rubric caps destructive/batch skills without validation at 3.	3 / 5
Progressive Disclosure	Well organized into Scope, Commands, Workflow, Safety, Core Tables, Common Queries, Dialect Notes, and Troubleshooting, with the only bundle file (scripts/mp-db.py) referenced one level deep; minor gaps are the inlined table dictionaries that could live in a reference file.	4 / 5
	Total	16 / 20 Passed

Description

100%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 is specific, trigger-rich, complete, and clearly scoped to the MoviePilot database via a bundled helper, with natural user phrasing for when to invoke it. It is a strong, low-conflict description.

Dimension	Reasoning	Score
Specificity	Lists multiple concrete actions—'inspect, query, maintain, or carefully modify' the database—plus specifics like 'data statistics, counts, aggregations, inspecting or fixing records, cleanup requests', giving comprehensive coverage.	5 / 5
Completeness	Explicitly states what the skill does (inspect/query/maintain/modify the MoviePilot DB via the bundled helper) and when to use it (data stats, counts, cleanup, stuck subscriptions), satisfying both what and when with concrete triggers.	5 / 5
Trigger Term Quality	Includes natural user phrases such as 'how many downloads', 'show site stats', 'delete old records', and 'why is this subscription stuck', matching how a user would actually phrase these requests.	5 / 5
Distinctiveness Conflict Risk	Scoped to a specific product database and a bundled script, with explicit scenarios unlikely to overlap with general-purpose skills; clear niche with minimal conflict risk.	5 / 5
	Total	20 / 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: f28e8b1

Reviewed: 4 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.