# SQLite Analyst

> Analyze SQLite databases using the better-sqlite3 Node.js library, including querying, inserting, and iterating over rows.

- Skill: `agentskillexchange/sqlite-analyst` (Agent Skill)
- Install (CLI): `npx skillmds@latest add agentskillexchange/sqlite-analyst`
- Raw SKILL.md: https://api.skillmd.com/api/skills/agentskillexchange/sqlite-analyst/raw
- Safety review: PASS (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics, Coding & Dev Tools, SQL & Databases
- Tags: Better Sqlite3, Database, Nodejs, Query, Sqlite
- Author: agentskillexchange (https://skillmd.com/u/agentskillexchange)
- Updated: 2026-08-22
- Page: https://skillmd.com/skills/agentskillexchange/sqlite-analyst

---


# SQLite Analyst



## Installation

Use the upstream install or setup path that matches your environment:
- npm install better-sqlite3

Requirements and caveats from upstream:
- The fastest and simplest library for SQLite in Node.js.
- Requires a [currently supported Node.js](https://nodejs.org/en/about/previous-releases) version. Prebuilt binaries are available for [LTS versions](https://nodejs.org/en/about/previous-releases). If you have trouble i...
- const db = require('better-sqlite3')('foobar.db', options);

Basic usage or getting-started notes:
- | |select 1 row  get() |select 100 rows   all()  |select 100 rows iterate() 1-by-1|insert 1 row run()|insert 100 rows in a transaction|
- bash
- js

- Source: https://github.com/WiseLibs/better-sqlite3
- Extracted from upstream docs: https://raw.githubusercontent.com/WiseLibs/better-sqlite3/HEAD/README.md

## Source

- [Agent Skill Exchange](https://agentskillexchange.com/skills/sqlite-analyst/)