overthinkos/vectorchord
ov-foundation/skills/vectorchord/SKILL.md
VectorChord PostgreSQL extension for optimized vector similarity search. Use when working with VectorChord, vector indices, or smart search performance.
tools
Updated May 10, 2026
$ install --global
skillsauthnpx skillsauth add overthinkos/overthink-plugins vectorchordInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 10, 2026, 5:34 AM154.0s1 file scanned
SKILL.md
- name:
- vectorchord
- description:
- |
vectorchord -- VectorChord vector similarity extension for PostgreSQL
Layer Properties
| Property | Value |
|----------|-------|
| Dependencies | postgresql |
| Ports | none |
| Volumes | none |
| Service | none |
| Install files | tasks: |
Environment Variables
| Variable | Value |
|----------|-------|
| VECTORCHORD_VERSION | 1.1.1 |
| POSTGRES_SHARED_PRELOAD_LIBRARIES | vchord.so |
Packages
unzip(RPM) -- for extracting VectorChord release archives
Build Process (tasks:)
Downloads VectorChord from GitHub releases (tensorchord/VectorChord) and installs the extension:
- Detects PostgreSQL major version via
postgres --version - Detects extension directories via
plpgsql.soanchor and standard Fedora paths - Downloads
postgresql-<PG_MAJOR>-vchord_<VERSION>_<ARCH>-linux-gnu.zip - Extracts
vchord.sotopkglibdirand.control/.sqlfiles tosharedir/extension/
Supports both x86_64 and aarch64 architectures. PostgreSQL version is detected dynamically.
How It Works
VectorChord provides the vchordrq index type for PostgreSQL, replacing pgvector's ivfflat with an optimized approximate nearest-neighbor search algorithm. Key differences:
- No result cap -- pgvector's ivfflat has an inherent limit (~40 results); vchordrq does not
shared_preload_libraries-- VectorChord's.somust be loaded at PostgreSQL startup via thePOSTGRES_SHARED_PRELOAD_LIBRARIESenv var (consumed by the postgresql layer's entrypoint)- Extension creation --
CREATE EXTENSION vchord CASCADE;(handled by the immich layer's migration script)
Version Requirements (Immich v2.7.2)
- pgvector >= 0.7, < 0.9 (provided by postgresql layer)
- VectorChord >= 0.3, < 2.0 (provided by this layer)
- PostgreSQL >= 14, < 19 (Fedora 43 ships PG 18)
Usage
# image.yml -- used alongside postgresql for Immich smart search
my-image:
layers:
- postgresql
- vectorchord
- immich
Used In Images
/ov-immich:immich/ov-immich:immich-ml
Related Layers
/ov-foundation:postgresql-- required dependency (provides PostgreSQL server and pgvector)/ov-immich:immich-- primary consumer (migration script creates the extension)
When to Use This Skill
Use when the user asks about:
- VectorChord extension installation or configuration
- Vector similarity search performance
- PostgreSQL shared_preload_libraries configuration
- Immich smart search or face recognition index types
vchordrqindex type
Related
/ov-build:layer— layer authoring reference (layer.ymlschema, task verbs, service declarations)/ov-build:eval— declarative testing (eval:block,ov eval image,ov eval live)
Related Skills
overthinkos/charly
tools
VerifiedTrustedCommunity
OpenCharly CLI (charly) binary installed into container/VM images for in-container use. Use when working with charly binary deployment inside containers, native D-Bus support, or the full charly toolchain (charly binary + virtualization + gocryptfs + socat).
SKILL.mdUpdated Jun 10, 2026
overthinkos/charly-cachyos
development
VerifiedTrustedCommunity
Operator CachyOS workstation profile — a kind:local template + target:local deploy that installs the full dev stack (30 candies) onto a CachyOS host via ShellExecutor. Lives in the overthinkos/cachyos submodule. MUST be invoked before editing or applying the charly-cachyos workstation profile.
SKILL.mdUpdated Jun 10, 2026
overthinkos/charly-fedora
tools
VerifiedTrustedCommunity
Fedora box with the full charly toolchain using shared candies. Rootless-first — runs as uid=1000 with passwordless sudo (no root, no cap_add: ALL). Same candy list as charly-arch. Includes NVIDIA GPU runtime. MUST be invoked before building, deploying, configuring, or troubleshooting the charly-fedora box.
SKILL.mdUpdated Jun 10, 2026
overthinkos/charly-arch
tools
VerifiedTrustedCommunity
Arch Linux box with the full charly toolchain. Rootless-first — runs as uid=1000 with passwordless sudo (no root, no cap_add: ALL). Composes /charly-coder:charly-mcp so the box is reachable as an MCP gateway on port 18765. NVIDIA GPU runtime composed in. MUST be invoked before building, deploying, configuring, or troubleshooting the charly-arch box.
SKILL.mdUpdated Jun 10, 2026