[BUG] CockroachDB plugin PostToolUse hook fires on every file write but script is never extracted

Preflight Checklist

• [x] I have searched existing issues and this hasn't been reported yet
• [x] This is a single bug report (please file separate reports for different bugs)
• [x] I am using the latest version of Claude Code

What's Wrong?

The CockroachDB plugin is currently broken. One or more skills fail to load or execute
correctly, resulting in incomplete or missing responses when invoking CockroachDB-related
workflows via Claude.

What Should Happen?

• Verify that the cockroachdb plugin is correctly registered and discoverable
• Check whether skill trigger conditions match current routing logic
• Test a minimal skill invocation end-to-end in a staging environment
• Confirm SKILL.md frontmatter metadata is valid and parseable

Error Messages/Logs

PostToolUse:Write hook blocking error from command:
"python3 "${CLAUDE_PLUGIN_ROOT}/scripts/check-sql-files.py"":
[python3 "${CLAUDE_PLUGIN_ROOT}/scripts/check-sql-files.py"]:
C:\Users\...\python3.exe: can't open file
'C:\Users\Anwender\AppData\Roaming\Claude\local-agent-mode-sessions\
292a5cb8-3e1b-4fb7-aa45-b2358846e708\865fac31-7455-4f09-9526-f591f3a5f0ec\
rpm\plugin_01J1ZUJcofzWJxiajSBsZ8US\scripts\check-sql-files.py':
[Errno 2] No such file or directory

Steps to Reproduce

1. Open a conversation in Claude.ai with the CockroachDB plugin enabled
2. Ask Claude to use a CockroachDB skill, e.g.:

• "Triage live SQL activity on my cluster"
• "Review cluster health"
• "Set up a local CockroachDB cluster"

1. Claude either:

• Fails silently and falls back to generic knowledge
• Returns an error or incomplete tool invocation
• Ignores the skill entirely

Expected Behavior
Claude should correctly invoke the relevant CockroachDB skill (e.g.,
triaging-live-sql-activity, reviewing-cluster-health, etc.) and return
a structured, skill-guided response including the appropriate SQL queries
and diagnostic steps.

Affected Skills (potentially all)

• cockroachdb:triaging-live-sql-activity
• cockroachdb:reviewing-cluster-health
• cockroachdb:setting-up-local-cluster
• cockroachdb:cockroachdb-sql
• cockroachdb:managing-cluster-capacity
• (possibly all skills in the cockroachdb:* namespace)

Actual Behavior

• Skills are not triggered or fail mid-execution
• No structured output is returned
• Claude falls back to hallucinated or generic CockroachDB information

instead of using the skill content

Claude Model

Sonnet (default)

Is this a regression?

I don't know

Last Working Version

_No response_

Claude Code Version

2.1.177 (Claude Code)

Platform

Anthropic API

Operating System

Windows

Terminal/Shell

Windows Terminal

Additional Information

Additional Context

No terminal involved. The error occurs in the Write tool — Claude Code's
internal file-write tool, not a shell command.

Flow:

1. Write tool is called → file is created
2. Claude Code fires a PostToolUse hook for all Write|Edit|MultiEdit events
3. Hook executes python3 ".../check-sql-files.py"
4. Script does not exist → error

No terminal involved. Occurs in every Claude Code environment
(Desktop App, CLI, IDE Extension) where the plugin is loaded.

• The skill SKILL.md files appear to be present and readable at the expected

paths under /mnt/skills/plugins/cockroachdb:*/

• The issue appears to be in skill invocation/triggering, not in skill content
• Other plugins (e.g., canva, higgsfield) appear to work normally