Node Sqlite Vec
Use when setting up Node 24+ built-in `node:sqlite` with the loadable `sqlite-vec` extension for vector / RAG storage in TypeScript without `better-sqlite3`, or when debugging vec0 BigInt rowids, vitest hanging on sqlite-vec, `.ts` import errors under `node:sqlite`, or "sqlite extension not loadable". Covers extension loading, version-specific test-runner resolution issues, tsconfig flags, and CLI shebang. Trigger on `node:sqlite`, `sqlite-vec`, vec0 / vector storage even when the user does not name better-sqlite3.
Install
npx skills add mizchi/skills --skill node-sqlite-vecgit clone --depth 1 https://github.com/mizchi/skills.git /tmp/skills
mkdir -p ~/.claude/skills
cp -r /tmp/skills/node-sqlite-vec ~/.claude/skills/node-sqlite-vecPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# node-sqlite-vec Recipe for combining Node 24's built-in `node:sqlite` with the [`sqlite-vec`](https://github.com/asg017/sqlite-vec) extension. Each section below is a known pitfall paired with the working incantation — read the **Pitfalls** section first if you only have a minute. ## When to use - Adding vector search / RAG storage to a Node 24+ project - You want to avoid the native build dance of `better-sqlite3` - TypeScript source that runs directly with `--experimental-strip-types` Skip this skill if: - Your deployment requires Node below 24 — upgrade to Node 24+ before using this recipe, or evaluate an adapter compatible with that deployment separately. - You need server-grade concurrency / replication — SQLite is the wrong tool ## Pitfalls (read first) | Symptom | Cause | Fix | |---|---|---| | `Failed to load url sqlite (resolved id: sqlite)` in an older runner | A version-specific resolver/runtime mismatch | Check the resolved Vite/Vitest versions and Node test environment. The current smoke passes in both Node and Vitest; retain the project's runner. | | `ERR_SQLITE_ERROR: Only integers are allows for primary key values on <table>_vec` on insert | JS `number` gets bound as REAL; `vec0` virtual tables require strict integer rowids | Wrap rowid bindings with `BigInt(id)` |
Details
- Skill name
node-sqlite-vec- Repository
- mizchi/skills
- Path
node-sqlite-vec/SKILL.md- Repo updated
- 18 November 2026
FAQ
What does the Node Sqlite Vec skill do?
Use when setting up Node 24+ built-in `node:sqlite` with the loadable `sqlite-vec` extension for vector / RAG storage in TypeScript without `better-sqlite3`, or when debugging vec0 BigInt rowids, vitest hanging on sqlite-vec, `.ts` import errors under `node:sqlite`, or "sqlite extension not loadable". Covers extension loading, version-specific test-runner resolution issues, tsconfig flags, and CLI shebang. Trigger on `node:sqlite`, `sqlite-vec`, vec0 / vector storage even when the user does not name better-sqlite3.
How do I install the Node Sqlite Vec skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add mizchi/skills --skill node-sqlite-vec. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Node Sqlite Vec popular?
It lives in mizchi/skills, which has 423 GitHub stars and 6 forks.
Related skills
Actions CI Tuning
423mizchi/skills
Use when auditing or improving GitHub Actions workflows for a project. Covers cache setup (npm/pnpm/yarn), job parallelism, shard-based test splitting, artifact handling pitfalls, and Playwright-specific patterns. Trigger on: slow CI, cache miss, flaky shard jobs, merge-reports failures, or an explicit 'tune CI' request.
AI Index
423mizchi/skills
Method and tooling for measuring how AI-generated a piece of prose reads, in Japanese or English. Two layers — a deterministic lint for removable surface tells (scripts/slopscore.py, no API) and a judgment layer of typed probabilistic questions (Jev noul/score) for the tells that survive editing. Includes measured human/AI baselines, a gap-first calibration procedure, and labeled fixtures. Use when building or calibrating an AI-likeness score, or when a draft needs a defensible number rather than a vibe. For writing guidance use natural-writing-ja / natural-writing-en instead.
Apm Usage
423mizchi/skills
Reference for APM manifests, installation, targeted updates, deployment paths and lockfiles. Invoke when the user explicitly asks about APM or apm.yml, or an unfamiliar APM command/error needs exact CLI details. Do not automatically invoke for every project that happens to have installed skills.
SQL Lint
423mizchi/skills
Static lint for sqlc-style SQL catalogs. Catches duplicate query names, missing semicolons, SELECT *, double-wildcard LIKE, and other cheap-but-easy-to-miss mistakes. Optional sqlfluff integration for full style coverage.
Upstash Redis Kv
302intellectronica/agent-skills
Read and write to Upstash Redis-compatible key-value store via REST API. Use when there is a need to save or retrieve key-value data, use Redis features (caching, counters, lists, sets, hashes, sorted sets, etc.) for the current interaction, or when the user explicitly asks to use Upstash or Redis.
SQL Plan Audit
423mizchi/skills
Run EXPLAIN QUERY PLAN against every query in a sqlc-style catalog and diff the plans against a baseline. Detects new full-table SCANs and TEMP B-TREE sort scans introduced by PRs. SQLite/D1-only today; engine extension noted below.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.