← Back to Skills Marketplace
2725
Downloads
4
Stars
20
Active Installs
1
Versions
Install in OpenClaw
/install pg
Description
Write efficient PostgreSQL queries and design schemas with proper indexing and patterns.
Usage Guidance
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.
Capability Analysis
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.
Capability Assessment
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.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install pg - After installation, invoke the skill by name or use
/pg - Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
Initial release
Metadata
Frequently Asked Questions
What is PostgreSQL?
Write efficient PostgreSQL queries and design schemas with proper indexing and patterns. It is an AI Agent Skill for Claude Code / OpenClaw, with 2725 downloads so far.
How do I install PostgreSQL?
Run "/install pg" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is PostgreSQL free?
Yes, PostgreSQL is completely free (open-source). You can download, install and use it at no cost.
Which platforms does PostgreSQL support?
PostgreSQL is cross-platform and runs anywhere OpenClaw / Claude Code is available (linux, darwin, win32).
Who created PostgreSQL?
It is built and maintained by Iván (@ivangdavila); the current version is v1.0.0.
More Skills