Skip to content

EliasOulkadi/shokunin / .pack/skills/db-admin

db-admin

Unverified

PostgreSQL database administration — backup/restore (pg_dump, PITR, WAL archiving), health monitoring (connections, bloat, cache hit ratio, dead tuples), connection pooling (PgBouncer), replication (streaming, logical), vacuum/autovacuum tuning, and scheduled backups with retention. Use when user asks to backup a database, restore from backup, monitor database health, set up replication, or perform DBA tasks. Do NOT use for schema design (use db-sculptor), query optimization (use db-sculptor), or migration planning (use db-sculptor).

Security report

Unverified

Static analysis of one exact version. It reduces risk and shows evidence; it does not certify that a skill is safe.

Commit
4c68e5bcb49453053cebf3390939a0a2e8e9a5e8
Content hash
51cfea99293dd5c8125a1021587adc14c3cca795416229109dec3b2917602bec
Scanned
2026-11-17
Scanner version
skillxone-scan-1.0.0
Policy version
0.1-draft
Decision
2 open medium findings to review.
Verification expires
Not applicable

Findings (2 medium, 1 info)

  • The skill sets something to run automatically later (scheduled task, login item or shell start-up file).

    Daily at 02:00: schtasks /Create /SC DAILY /TN "PG-Backup-Daily" /TR "powershell.exe -File \"D:\scripts\backup-schedule-template.ps1\"" /ST 02:00 /RU SYSTEM

    Suggested fix: Do not install persistent jobs or edit shell start-up files. Tell the user what to add if they want it.

    Report as false positive

  • mediumCMD-PERSISTENCESKILL.md:79

    The skill sets something to run automatically later (scheduled task, login item or shell start-up file).

    schtasks /Create /SC DAILY /TN "DBBackup-myapp" /TR "powershell.exe -File C:\scripts\backup-schedule.ps1" /ST 02:00

    Suggested fix: Do not install persistent jobs or edit shell start-up files. Tell the user what to add if they want it.

    Report as false positive

  • infoINT-BROAD-ALLOWED-TOOLSSKILL.md:30

    SKILL.md pre-approves unrestricted shell access through `allowed-tools`, so the agent may run commands without asking.

    allowed-tools: Read Bash Write

    Suggested fix: Restrict the tool, for example `Bash(git status:*)`, or leave approval to the user.

    Report as false positive

Checks run

  • prompt-injection
  • dangerous-commands
  • credentials
  • network
  • file-access
  • integrity

Checks skipped

  • dependencies: No dependency manifest in the skill directory.
  • gitleaks: gitleaks is not installed on this host.
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall