← 返回 Skills 市场
2725
总下载
4
收藏
20
当前安装
1
版本数
在 OpenClaw 中安装
/install pg
功能描述
Write efficient PostgreSQL queries and design schemas with proper indexing and patterns.
安全使用建议
This is an instruction-only PostgreSQL advice skill and appears internally consistent. If you plan to let an agent actually execute commands (psql/pgcli) against your database, be careful: only grant least-privilege credentials, prefer a read-only user for diagnostics, and avoid giving superuser access (pg_repack, extensions, or config changes often require elevated rights). Install any referenced tools (pg_repack, pg_trgm, PgBouncer) yourself from trusted sources. If you keep the skill as guidance-only (no DB credentials provided), the risk is minimal.
功能分析
Type: OpenClaw Skill
Name: pg
Version: 1.0.0
The skill bundle is benign. The `_meta.json` contains standard metadata. The `SKILL.md` provides educational content on PostgreSQL best practices, common pitfalls, and advanced features. It declares a dependency on standard PostgreSQL client binaries (`psql`, `pgcli`), which is appropriate for a PostgreSQL-focused skill. There is no evidence of prompt injection attempts, malicious execution, data exfiltration, persistence, or obfuscation in any of the files.
能力评估
Purpose & Capability
Name/description match the SKILL.md content (Postgres indexing, queries, connection management, vacuuming, FTS, etc.). Declared optional binaries (psql or pgcli) are appropriate for a query/schema helper. No unrelated env vars, binaries, or config paths are requested.
Instruction Scope
SKILL.md contains best-practice guidance and examples (indexes, EXPLAIN, timeouts, pg_bouncer, pg_repack, extensions) but does not instruct the agent to read arbitrary host files, access unrelated environment variables, or exfiltrate data. It does mention operations that, if executed (e.g., running diagnostic queries or using pg_repack), require DB access and privileges — this is expected for a DB helper but worth noting.
Install Mechanism
No install spec and no code files — lowest-risk model. The doc references third-party tools/extensions (pg_repack, pg_trgm, PgBouncer) but does not attempt to download or install them; users must install these externally if needed.
Credentials
The skill declares no required environment variables or credentials. That is proportionate for an advice-only skill. Note: to run interactive diagnostics via psql/pgcli the agent (or user) would need DB credentials — the skill does not request them, which is appropriate.
Persistence & Privilege
always is false, agent invocation is normal. The skill does not request persistent system presence, nor does it modify other skills or system-wide settings.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install pg - 安装完成后，直接呼叫该 Skill 的名称或使用
/pg触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
Initial release
元数据
常见问题
PostgreSQL 是什么？
Write efficient PostgreSQL queries and design schemas with proper indexing and patterns. 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 2725 次。
如何安装 PostgreSQL？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install pg」即可一键安装，无需额外配置。
PostgreSQL 是免费的吗？
是的，PostgreSQL 完全免费（开源免费），可自由下载、安装和使用。
PostgreSQL 支持哪些平台？
PostgreSQL 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（linux, darwin, win32）。
谁开发了 PostgreSQL？
由 Iván（@ivangdavila）开发并维护，当前版本 v1.0.0。
推荐 Skills