Sqlite Analyst

---
name: "SQLite Analyst"
slug: "sqlite-analyst"
description: ""
github_stars: 7111
verification: "security_reviewed"
source: "https://github.com/WiseLibs/better-sqlite3"
category: "Developer Tools"
framework: "MCP"
tool_ecosystem:
  github_repo: "wiselibs/better-sqlite3"
  github_stars: 7111
  npm_package: "better-sqlite3"
  npm_weekly_downloads: 5530063
---

# 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/)