Community tools: Windows-native vchord build + Hindsight installer MCP

[grimmjoww]

Hey Hindsight maintainers + community 👋

Spent a Friday night on two related community contributions — sharing here as informational, not asking for any action.

1. Native Windows MSVC build of VectorChord (vchord)

Repo: https://github.com/grimmjoww/vchord-windows-port (MIT, docs + scripts only — no vchord source code redistributed)

• First documented native Windows MSVC build of tensorchord/VectorChord. No Docker, no WSL2.
• Toolchain: VS2022 + LLVM 22.1.4 + Rust 1.95.0 + cargo-pgrx 0.17.0 + PostgreSQL 17.9
• Output: working vchord.dll (9.4 MB, PE32+ x64), zero source-code changes required
• Critical gotcha documented: Rust 1.95+ required because crates/simd/src/floating_f16.rs uses AVX-512 FP16 intrinsics that were unstable until 1.95
• Why it matters for Hindsight users: unlocks dim > 2000 on Windows, which is needed for Qwen3-Embedding-4B (2560 dim) / 8B (4096 dim). Hindsight already supports vchordrq indexes via migrations.py — this just fills in the Windows build path.

2. hindsight-installer-mcp (Model Context Protocol server)

Repo: https://github.com/grimmjoww/hindsight-installer-mcp (MIT, Python, MCP-compatible)

Wraps Hindsight admin operations as MCP tools so any agent (Claude Code, Cursor, Cline, Continue, OpenAI Codex, Gemini CLI) can:

• Detect pg0 vs system Postgres mode and the elevation requirement
• Install Postgres extensions with auto-routed elevation (gsudo / Windows sudo / native sudo)
• Read/write Hindsight .env config
• Invoke hindsight-admin reindex-embeddings (PR feat(admin): reindex-embeddings command (closes #743) #1258) with auto-backup + verify-recall
• Orchestrate full embedding pipeline upgrades

In pg0 mode the entire workflow is admin-free. In system Postgres mode there is one elevation prompt at install time.

This is intentionally a separate MCP from hindsight-memory — different security domain (admin ops vs user data ops), different audiences. Users who want both run them side-by-side in their MCP config.

Status

Both repos are MIT, lazily maintained as side-project glue layers. PRs welcome but no SLA. If maintainers ever want to incorporate any of this content into official Hindsight docs/tooling, please feel free — written under MIT specifically so there is no friction.

Related: PR #1258 (reindex-embeddings command) and PR #1263 (lint fix for ty-embed Windows-only subprocess attrs) are the upstream contributions this work depends on.

[nicoloboschi]

hey @grimmjoww great work!

would you like to get this into Integrations page here? https://hindsight.vectorize.io/integrations