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.

423 stars 6 forksDatabases

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add mizchi/skills --skill node-sqlite-vec
Manual install
git 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-vec

Personal 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)` |
Read the full skill on GitHub

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

423

mizchi/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.

Testing & QA

AI Index

423

mizchi/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.

AI, LLMs & Agents

Apm Usage

423

mizchi/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.

DevOps & Cloud

SQL Lint

423

mizchi/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.

Databases

Upstash Redis Kv

302

intellectronica/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.

Databases27

SQL Plan Audit

423

mizchi/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.

Databases

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.