Database Sqlite
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
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 RepositoryRelated Skills
mcp-server-postgres
Read-only PostgreSQL database access.
Data mcp-server-sqlite
SQLite database interaction and querying.
Data mcp-server-google-maps
Google Maps integration for location data.
Data Bitbucket Data Center
---
Data Csv Data Summarizer
Automatically analyze CSV files and generate comprehensive insights with visualizations
Data OpenViking
Self-evolving Context Database for AI Agents. Unify Agent Memory, Knowledge RAG and Skills.
Data