overthinkos/vectorchord
infrastructure/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 Jun 14, 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: Jun 14, 2026, 5:54 AM127.9s1 file scanned
SKILL.md
- name:
- vectorchord
- description:
- |
vectorchord -- VectorChord vector similarity extension for PostgreSQL
Candy Properties
| Property | Value |
|----------|-------|
| Dependencies | postgresql |
| Ports | none |
| Volumes | none |
| Service | none |
| Install files | task: |
Environment Variables
| Variable | Value |
|----------|-------|
| VECTORCHORD_VERSION | 1.1.1 |
| POSTGRES_SHARED_PRELOAD_LIBRARIES | vchord.so |
Packages
unzip(RPM / PAC) -- for extracting VectorChord release archives
The candy is multi-distro (Fedora + Arch/CachyOS). On Arch, pgvector comes from
the AUR (see /charly-infrastructure:postgresql).
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
pg_config --pkglibdirandpg_config --sharedir— this resolves correctly on both Fedora (/usr/lib64/pgsql,/usr/share/pgsql) and Arch/CachyOS (/usr/lib/postgresql,/usr/share/postgresql) - 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 candy's entrypoint)- Extension creation --
CREATE EXTENSION vchord CASCADE;(handled by the immich candy's migration script)
Version Requirements (Immich v2.7.2)
- pgvector >= 0.7, < 0.9 (provided by postgresql candy)
- VectorChord >= 0.3, < 2.0 (provided by this candy)
- PostgreSQL >= 14, < 19 (Fedora 43 ships PG 18)
Usage
# charly.yml -- used alongside postgresql for Immich smart search
my-image:
candy:
- postgresql
- vectorchord
- immich
Used In Boxes
/charly-immich:immich/charly-immich:immich-ml
Related Candies
/charly-infrastructure:postgresql-- required dependency (provides PostgreSQL server and pgvector)/charly-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
/charly-image:layer— candy authoring reference (charly.ymlschema, task verbs, service declarations)/charly-check:check— declarative testing (check:block,charly check box,charly check live)
Related Skills
overthinkos/plugin
tools
VerifiedTrustedCommunity
Use when authoring or modifying a charly PLUGIN — a candy with a `plugin:` block that contributes Providers (verbs/kinds/deploy-targets/steps/builders/commands), its own CUE schema, builtin (compiled-in) or external (out-of-tree git repo). Covers the unified Provider model, the per-plugin CUE-schema contract (single source → Go params for dev + schema-over-Describe RPC for runtime), the SDK, and the loader.
SKILL.mdUpdated Jun 22, 2026
overthinkos/cue
tools
VerifiedTrustedCommunity
The CUE data-validation / configuration CLI (cue), pinned to v0.16.1. Use when working with the cue candy, installing the cue binary into a box or onto a target:local dev host, or running the offline schema-vendoring pipeline that feeds charly's egress validation.
SKILL.mdUpdated Jun 16, 2026
overthinkos/egress
tools
VerifiedTrustedCommunity
CUE EGRESS validation — validating (and, where it adds value, generating) the config files charly WRITES to a system BEFORE the bytes hit disk. MUST be invoked before working on charly/egress.go, the vendored schemas under candy/plugin-egress/egress-schemas/vendor/, the ValidateEgress / registerVendoredEgressKind path, the offline `task cue:vendor` pipeline, or adding an egress schema for any written artifact (cloud-init, k8s manifests, traefik routes, runtime config, install ledger, systemd/quadlet units, ssh_config, libvirt XML).
SKILL.mdUpdated Jun 16, 2026
overthinkos/check-k8s
tools
VerifiedTrustedCommunity
Kubernetes cluster-probe declarative check verb — the `kube:` check verb (nodes, pods, ingress, storage class, addon health, apply/delete, and arbitrary resource GETs) served out-of-process by the candy/plugin-kube plugin (vendored client-go; no external kubectl required).
SKILL.mdUpdated Jun 14, 2026