Scan Report
15 /100
workout-tracker
Personal fitness tracker - records workout data, parses movements/sets/reps/weight, writes to local MySQL database
A legitimate fitness tracking skill with proper SQL injection protection, local-only database access, and parameterized queries. The placeholder passwords in documentation are clearly marked as examples for user replacement.
Safe to install
No immediate action required. The skill follows security best practices. Consider updating documentation to use more visibly placeholder-style passwords (e.g., 'REPLACE_WITH_YOUR_PASSWORD') to reduce confusion.
Findings 2 items
| Severity | Finding | Location |
|---|---|---|
| Low | Placeholder passwords in documentation Doc Mismatch | SKILL.md:30 |
| Info | Reads .env configuration file Sensitive Access | scripts/init_database.py:89 |
| Resource | Declared | Inferred | Status | Evidence |
|---|---|---|---|---|
| Filesystem | NONE | READ | ✓ Aligned | Reads .env files for config loading, documented in SKILL.md |
| Network | READ | READ | ✓ Aligned | package.json repository URL only, no runtime network access |
| Shell | NONE | NONE | — | No shell execution in Python scripts |
| Environment | READ | READ | ✓ Aligned | Reads MYSQL_* env vars for database connection |
| Skill Invoke | NONE | NONE | — | No skill invocation detected |
| Clipboard | NONE | NONE | — | No clipboard access |
| Browser | NONE | NONE | — | No browser automation |
| Database | WRITE | WRITE | ✓ Aligned | Local MySQL via unix_socket only, fully documented |
3 High 4 findings
High API Key 疑似硬编码凭证
PASSWORD="your_secure_password" SKILL.md:30 High API Key 疑似硬编码凭证
PASSWORD="your_secure_password_here" SKILL.md:91 High API Key 疑似硬编码凭证
PASSWORD="temporary_password" TOOLS.md:66 Medium External URL 外部 URL
https://clawhub.ai/query1988/workout-tracker package.json:18 File Tree
6 files · 40.7 KB · 1267 lines Markdown 3f · 848L
Python 2f · 361L
JSON 1f · 58L
├─
▾
scripts
│ ├─
init_database.py
Python
│ └─
verify_setup.py
Python
├─
package.json
JSON
├─
README.md
Markdown
├─
SKILL.md
Markdown
└─
TOOLS.md
Markdown
Dependencies 1 items
| Package | Version | Source | Known Vulns | Notes |
|---|---|---|---|---|
mysql-connector-python | * | pip | No | Version not pinned but package is from Oracle, widely used |
Security Positives
✓ All SQL queries use parameterized statements preventing SQL injection
✓ Local-only database connection via unix socket, no remote access
✓ Database user follows least privilege principle (INSERT/SELECT/UPDATE/DELETE only)
✓ Strong input validation documentation with clear do/don't examples
✓ No hardcoded credentials in Python scripts
✓ No network exfiltration or C2 communication detected
✓ No obfuscation or encoded payloads found
✓ No sensitive file path access (ssh, aws credentials, etc.)
✓ Comprehensive security audit checklist in documentation
✓ Error messages do not leak database structure