← Back to Skills Marketplace
damiencronw

pgvector

by damienCronw · GitHub ↗ · v1.0.0
cross-platform ✓ Security Clean
422
Downloads
0
Stars
2
Active Installs
1
Versions
Install in OpenClaw
/install pgvector
Description
PostgreSQL vector database skill with pgvector extension. Enables vector similarity search, embeddings storage, RAG (Retrieval-Augmented Generation) pipeline...
Usage Guidance
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.
Capability Analysis
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.
Capability Assessment
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.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install pgvector
  3. After installation, invoke the skill by name or use /pgvector
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Slug pgvector
Version 1.0.0
License
All-time Installs 2
Active Installs 2
Total Versions 1
Frequently Asked Questions

What is pgvector?

PostgreSQL vector database skill with pgvector extension. Enables vector similarity search, embeddings storage, RAG (Retrieval-Augmented Generation) pipeline... It is an AI Agent Skill for Claude Code / OpenClaw, with 422 downloads so far.

How do I install pgvector?

Run "/install pgvector" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is pgvector free?

Yes, pgvector is completely free (open-source). You can download, install and use it at no cost.

Which platforms does pgvector support?

pgvector is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created pgvector?

It is built and maintained by damienCronw (@damiencronw); the current version is v1.0.0.

💬 Comments