Database Sqlite banner
mcpinsight mcpinsight

Database Sqlite

Data community

Description

# Skill: Database (SQLite via better-sqlite3) > Load when touching `packages/core/src/db/` or any `.sql` migration. ## Why SQLite, not Postgres Local-first product. Each user has their own `~/.mcpinsight/data.db`. No network, no auth, no ops. Ten years of this data is still <100 MB for a typical user. Postgres would be ops without benefit. For the Worker (Cloudflare), we use **D1** (Cloudflare's SQLite-as-a-service). Same mental model, different driver. ## Schema rules ### 1. Migrations ar

Installation

Installs to ~/.claude/skills/mcpinsight-mcpinsight-database-sqlite/SKILL.md

Terminal
mkdir -p ~/.claude/skills/mcpinsight-mcpinsight-database-sqlite && curl -fsSL https://raw.githubusercontent.com/mcpinsight/mcpinsight/HEAD/.claude/skills/database-sqlite.md -o ~/.claude/skills/mcpinsight-mcpinsight-database-sqlite/SKILL.md

Restart Claude Code, or start a new session, for it to be picked up.

Full documentation available on GitHub

View Source Repository