← 返回 Skills 市场
damiencronw

pgvector

作者 damienCronw · GitHub ↗ · v1.0.0
cross-platform ✓ 安全检测通过
422
总下载
0
收藏
2
当前安装
1
版本数
在 OpenClaw 中安装
/install pgvector
功能描述
PostgreSQL vector database skill with pgvector extension. Enables vector similarity search, embeddings storage, RAG (Retrieval-Augmented Generation) pipeline...
安全使用建议
This skill appears to be a straightforward pgvector/Postgres cheat-sheet and is consistent with its description. Before installing or invoking it: (1) ensure you only connect the agent to a test or controlled Postgres instance first — the SQL examples include CREATE/INSERT/UPDATE/DELETE which can modify data; (2) do not use the example 'empty' password in production and prefer a least-privilege DB user; (3) ensure the pgvector extension is installed on the target DB and that the agent has only the permissions it needs (read-only if you only want retrieval); (4) note the skill is instruction-only from an unknown/anonymous source (no homepage) — if you need guarantees about correctness or safety, review the SQL commands yourself or run them in a sandbox before letting an agent execute them automatically.
功能分析
Type: OpenClaw Skill Name: pgvector Version: 1.0.0 The skill provides standard documentation, SQL templates, and a Python snippet for using the pgvector extension in PostgreSQL. It includes connection details for a local development environment (user 'damien', port 5433) and common operations like similarity search and RAG pipelines, with no evidence of malicious intent, data exfiltration, or prompt injection.
能力评估
Purpose & Capability
The name/description (PostgreSQL + pgvector helper for embeddings, similarity search, and RAG) matches the SKILL.md content: SQL for creating vector tables, indexes, queries, and a Python insertion example. There are no extraneous dependencies or unrelated capabilities requested.
Instruction Scope
Instructions stay on-topic (connecting to Postgres, creating tables/indexes, inserting/searching embeddings). They do not instruct reading arbitrary system files or exfiltrating data to external endpoints. However, the SKILL.md contains DDL/DML (CREATE/INSERT/UPDATE/DELETE) which — if the agent executes them against a live DB — will change data. The doc also uses explicit connection defaults (localhost:5433, user 'damien', empty password) which are operational details that could be misused if applied without care.
Install Mechanism
Instruction-only skill with no install spec and no code files; nothing is downloaded or written to disk by the skill itself.
Credentials
The skill does not declare or require environment variables or credentials (good minimal surface). It does show example PG environment variables (PGHOST, PGPORT, PGUSER, PGPASSWORD) and a default empty password in examples — these are examples only, but users should not assume the skill needs or will get secrets automatically. Recommend using a least-privilege DB user and non-empty password in real deployments.
Persistence & Privilege
always:false (normal) and the skill does not request persistent system-level privileges or attempt to modify other skill/system configs. Autonomous invocation is allowed by platform default — this is expected and not by itself a problem.
如何使用
  1. 确保已安装 OpenClaw(本地或 Docker 部署)
  2. 在对话框中输入安装命令:/install pgvector
  3. 安装完成后,直接呼叫该 Skill 的名称或使用 /pgvector 触发
  4. 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
Initial release of the pgvector skill, enabling PostgreSQL-based vector search: - Integrates PostgreSQL with the pgvector extension for vector similarity search and embedding storage. - Supports creation and indexing of vector tables (HNSW, IVFFlat) optimized for fast and flexible searches. - Provides SQL examples for inserting embeddings, running vector and hybrid (vector + keyword) searches, and supporting RAG (Retrieval-Augmented Generation) workflows. - Includes guides for table management, monitoring, updating, deleting, and batch-inserting embeddings via Python. - Summarizes key use cases: semantic search, RAG pipelines, recommendations, anomaly detection, and image/video search.
元数据
Slug pgvector
版本 1.0.0
许可证
累计安装 2
当前安装数 2
历史版本数 1
常见问题

pgvector 是什么?

PostgreSQL vector database skill with pgvector extension. Enables vector similarity search, embeddings storage, RAG (Retrieval-Augmented Generation) pipeline... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 422 次。

如何安装 pgvector?

在 OpenClaw 或 Claude Code 对话框中运行命令「/install pgvector」即可一键安装,无需额外配置。

pgvector 是免费的吗?

是的,pgvector 完全免费(开源免费),可自由下载、安装和使用。

pgvector 支持哪些平台?

pgvector 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。

谁开发了 pgvector?

由 damienCronw(@damiencronw)开发并维护,当前版本 v1.0.0。

💬 留言讨论