← 返回 Skills 市场
PostgreSQL Skill - 高级数据库管理
作者
ryanlee-gemini
· GitHub ↗
· v1.0.0
· MIT-0
330
总下载
0
收藏
1
当前安装
1
版本数
在 OpenClaw 中安装
/install postgres-skill
功能描述
PostgreSQL 数据库管理技能。通过自然语言查询、管理 PostgreSQL 数据库,支持复杂查询、性能分析、JSON 操作、全文搜索等高级功能。当用户提到 PostgreSQL、Postgres、复杂查询、性能优化时使用此技能。
安全使用建议
This skill appears to do what it says: it provides Postgres queries, backup/restore commands, and recommends installing standard Postgres client tools. Before installing or using it, consider: 1) Verify the skill source (package.json points to a GitHub repo and homepage URL — check those links and the repo contents). 2) Prefer not to export PGPASSWORD in long-lived shells; use .pgpass, a connection URI stored securely, or a secrets manager and use least-privilege DB users (read-only for analysis). 3) Installing the client uses sudo/apt or brew — only run these on machines you control. 4) Test generated queries on a non-production database first (especially destructive commands). 5) Note the metadata mismatch: required env vars are described in SKILL.md but not declared in registry metadata — expect the agent to need DB credentials to operate. If you are comfortable with those precautions, the skill is coherent with its stated purpose.
功能分析
Type: OpenClaw Skill
Name: postgres-skill
Version: 1.0.0
The postgres-skill bundle is a legitimate tool for PostgreSQL database management, providing comprehensive documentation for SQL queries, JSONB operations, and performance tuning. It utilizes standard system utilities (psql, pg_dump, pg_restore) and follows official PostgreSQL configuration patterns via environment variables. No evidence of malicious intent, data exfiltration, or harmful prompt injection was found in SKILL.md or package.json.
能力评估
Purpose & Capability
The name/description match the content: SKILL.md provides SQL examples, backup/restore advice, performance queries, JSON/FTS guidance. package.json declares required PostgreSQL client binaries (psql, pg_dump, pg_restore) and an install block to install them — which is coherent for a Postgres management skill. Note: the registry metadata provided with the skill reported 'no required binaries' and 'no homepage', but package.json includes both requires/install and a homepage/repository; this is an inconsistency in metadata but not a functional mismatch with the skill's purpose.
Instruction Scope
SKILL.md is focused on database tasks: installing a client, configuring connection vars, SQL examples, EXPLAIN usage, backups. It does instruct setting environment variables (PGHOST/PGPORT/PGUSER/PGPASSWORD/PGDATABASE) and to run system install commands (apt / brew). It does not instruct the agent to read unrelated files or exfiltrate data to external endpoints. (Minor accuracy note: some SQL examples use QUALIFY which is not standard PostgreSQL syntax — a correctness issue, not a security one.)
Install Mechanism
There is no executable code bundled, but package.json includes an openclaw.install section that runs standard system package installs (apt, brew) for the PostgreSQL client. These are standard package manager commands from known package sources — no arbitrary download URLs or archive extraction are used. Installing with apt may require sudo; user permission/privilege is expected for system package installs.
Credentials
The skill legitimately requires database connection information (PGHOST/PGPORT/PGUSER/PGPASSWORD/PGDATABASE) to operate. However, the registry metadata does not declare required env vars or a primary credential while the SKILL.md explicitly instructs exporting PGPASSWORD and other PG_* vars. This mismatch is a metadata omission — functionally the env vars are proportional but the skill asks users to place sensitive credentials in environment variables (PGPASSWORD), which has security implications (exposure in process listings/shell history).
Persistence & Privilege
The skill is instruction-only and does not request persistent presence, special system config paths, or always:true. It does include optional system install commands for a client tool, which is normal and limited in scope.
如何使用
- 确保已安装 OpenClaw(本地或 Docker 部署)
- 在对话框中输入安装命令:
/install postgres-skill - 安装完成后,直接呼叫该 Skill 的名称或使用
/postgres-skill触发 - 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
🎉 首发版本!
主要功能:
• 🔍 智能查询 - 自然语言描述,自动生成 SQL
• 📊 高级分析 - 窗口函数、CTE、复杂聚合
• 📝 JSON 操作 - JSONB 查询、更新、索引
• 🔎 全文搜索 - PostgreSQL 强大的全文搜索能力
• ⚡ 性能分析 - EXPLAIN ANALYZE、索引优化
• 💾 备份恢复 - pg_dump/pg_restore 完整方案
适合人群:开发者、数据分析师、DBA
元数据
常见问题
PostgreSQL Skill - 高级数据库管理 是什么?
PostgreSQL 数据库管理技能。通过自然语言查询、管理 PostgreSQL 数据库,支持复杂查询、性能分析、JSON 操作、全文搜索等高级功能。当用户提到 PostgreSQL、Postgres、复杂查询、性能优化时使用此技能。 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 330 次。
如何安装 PostgreSQL Skill - 高级数据库管理?
在 OpenClaw 或 Claude Code 对话框中运行命令「/install postgres-skill」即可一键安装,无需额外配置。
PostgreSQL Skill - 高级数据库管理 是免费的吗?
是的,PostgreSQL Skill - 高级数据库管理 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。
PostgreSQL Skill - 高级数据库管理 支持哪些平台?
PostgreSQL Skill - 高级数据库管理 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。
谁开发了 PostgreSQL Skill - 高级数据库管理?
由 ryanlee-gemini(@ryanlee-gemini)开发并维护,当前版本 v1.0.0。
推荐 Skills