Skip to content

inchTodd/db-error-troubleshooting-skills / skills/pg-role-does-not-exist

pg-role-does-not-exist

Verified

排查 PostgreSQL 报错「role "%s" does not exist」。当用户贴出包含这条报错的输出、或问这条报错怎么解决时使用。只读排查优先,不需要也不收集数据库密码。

Security report

Verified

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

Commit
2ff693518fb96472dbf425728458e44380d89f2d
Content hash
8a0b4fcd756dba86fcdeed8f85597f3716795a1c5fdfefaa054e2cc0f31e554a
Scanned
2026-11-17
Scanner version
skillxone-scan-1.0.0
Policy version
0.1-draft
Decision
Every required check completed with no open blocking or medium findings.
Verification expires
2026-12-17

Findings (2 low)

  • lowCMD-SUDOSKILL.md:12

    A command runs with administrator privileges.

    这条报错说明你要登录的数据库用户名在这台服务器上不存在。最常见的三种情况:`psql` 没写 `-U`,默认拿操作系统用户名(如 `ubuntu`)去登录;Docker 容器复用了旧数据卷,`POSTGRES_USER` 没生效;建用户时没加双引号,`MyUser` 实际被建成了 `myuser`。先用 `sudo -u postgres psql -c '\du'` 看现有用户,再用 `CREATE ROLE ... LOGIN` 补建,或把连接串里的用户名改对。

    Suggested fix: Avoid sudo where possible. If it is required, explain why so the user can decide.

    Report as false positive

  • lowCMD-SUDOSKILL.md:81

    A command runs with administrator privileges.

    -- 以超级用户连接(如 sudo -u postgres psql)后执行

    Suggested fix: Avoid sudo where possible. If it is required, explain why so the user can decide.

    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