overthinkos/vectorchord
ov-layers/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 Apr 27, 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: Apr 27, 2026, 9:33 AM92.1s1 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-images:immich/ov-images:immich-ml
Related Layers
/ov-layers:postgresql-- required dependency (provides PostgreSQL server and pgvector)/ov-layers: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:layer— layer authoring reference (layer.ymlschema, task verbs, service declarations)/ov:test— declarative testing (tests:block,ov image test,ov test)
Related Skills
overthinkos/agents
development
VerifiedTrustedCommunity
Claude Code multi-agent support in Overthink — sub-agents, dynamic workflows, and agent teams, and how each drives the existing `ov eval` disposable beds to test and verify. MUST be invoked before authoring or invoking an ov sub-agent / dynamic workflow / agent team, wiring agent-lifecycle hooks, or asking "which primitive should drive the R10 beds?".
SKILL.mdUpdated May 31, 2026
overthinkos/workspace-mount
tools
VerifiedTrustedCommunity
Mounts a virtiofs share tagged `workspace` at /workspace inside a VM guest via a systemd .mount unit. Use when a kind:vm entity shares a host directory into the guest and you need it auto-mounted (and re-mounted at every boot).
SKILL.mdUpdated May 30, 2026
overthinkos/android
development
VerifiedTrustedCommunity
MUST be invoked before any work involving: the `kind: android` schema kind, a `target: android` deploy, the `apk:` layer package format (installing Android apps declaratively), AndroidDeployTarget, an in-pod emulator OR a remote/physical adb-endpoint device, or nested `pod → android` deployment. The first-class Android device + app surface that sits above `ov eval adb`/`appium`.
SKILL.mdUpdated May 26, 2026
overthinkos/git-workflow
tools
VerifiedTrustedCommunity
Use when committing, branching, pushing, merging, tagging, creating PRs, or approving/merging PRs with gh — the feat/-branch, R10-gated, never-force-push landing workflow across the main repo + the plugins submodule + image/<distro> submodules. Covers sync-to-upstream, branch/worktree pruning, the fork+PR path for contributors without write access, and cross-repo @github landing order.
SKILL.mdUpdated May 25, 2026