CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

netalertx-database-patterns

NetAlertX database architecture patterns. Use this when designing features that write to the Devices table, implementing audit/history logging, or choosing between trigger-based vs Python-hook approaches.

70

Quality

88%

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

83%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 high-quality patterns skill: dense with non-obvious project-specific knowledge, executable SQL patterns, and a clear architectural decision framework. Its main gaps are the absence of validation/verification steps for the database workflows it guides and slightly rhetorical prose in the identity-migration section.

Suggestions

Add an explicit validation checkpoint to the trigger pattern — e.g., after creating a trigger, run a sample UPDATE and verify the expected DevicesHistory row (or query sqlite_master / EXPLAIN the guard) before considering the feature done — since the rubric requires a feedback loop for database operations.

State the implementation sequence explicitly (audit write paths → decide trigger vs Python hook → implement event-sourced logging → validate) so the implied workflow becomes a checklist rather than being inferred from section order.

Trim the justificatory prose in the devMac-vs-devGUID section (MAC-randomization enumeration and 'structural ceiling' framing) to the one-line rule: resolve identity from a fetched row; Plugins_Objects/CurrentScan/Events are permanently MAC-keyed.

DimensionReasoningScore

Conciseness

Largely lean, project-specific material (write-path inventory, FIELD_SOURCE_MAP, exact attribution expressions) that assumes Claude's competence, but the devMac-vs-devGUID rationale ("privacy MAC randomization on iOS/Android/Windows, virtualized/containerized interfaces sharing one physical MAC…") and rhetorical framing ("it's a structural ceiling on what network-originated data can ever identify a device by") could be trimmed.

4 / 5

Actionability

Fully executable guidance throughout: a complete SQLite trigger template with the Settings-guard and per-field conditional insert, exact "COALESCE(NULLIF(NEW.devNameSource, ''), 'system')" expressions, concrete file/function targets, and a copy-paste-ready DevicesHistory DDL with indexes.

5 / 5

Workflow Clarity

A clear implied sequence exists ("audit ALL write paths" → trigger-vs-Python-hook decision → event-sourced schema), but this is a database-operations skill with no validation/verification checkpoint — no step to test a new trigger or verify audit output before relying on it — which caps workflow clarity at 3 per the rubric's feedback-loops rule.

3 / 5

Progressive Disclosure

Well-organized single-file skill with clear section headers and no dead-end references, but at ~150 lines the write-path inventory and DevicesHistory reference schema are inlined rather than split into reference files, so it doesn't meet the anchor-5 bar of appropriately split content.

4 / 5

Total

16

/

20

Passed

Description

87%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: third-person, concise, with an explicit and specific "Use this when" clause listing three concrete scenarios. The only improvement space is broader keyword coverage and surfacing the identity/attribution topics as trigger actions.

DimensionReasoningScore

Specificity

Lists several concrete actions — "designing features that write to the Devices table", "implementing audit/history logging", "choosing between trigger-based vs Python-hook approaches" — but coverage has minor gaps: the devGUID identity guidance and *Source attribution sections are not surfaced as triggerable actions.

4 / 5

Completeness

Clearly answers both: the "what" ("NetAlertX database architecture patterns") and an explicit "Use this when…" clause with three concrete trigger scenarios; the level-4 anchor's weakness ("when could be more explicit or specific") does not apply here.

5 / 5

Trigger Term Quality

Good natural keyword coverage for the domain ("NetAlertX", "Devices table", "audit", "history logging", "trigger"), matching what a contributor would actually say; a few natural variants like "change history", "SQLite", or "schema" are missing.

4 / 5

Distinctiveness Conflict Risk

"NetAlertX" plus "Devices table" carves a clear niche with distinct triggers and minimal conflict risk with any other skill.

5 / 5

Total

18

/

20

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

netalertx/NetAlertX

Path

.github/skills/database-patterns/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.