claudeindex
Plugin

sqlite

SQLite best practices — STRICT tables, the must-set pragmas (WAL, busy_timeout, foreign_keys, synchronous=NORMAL), BEGIN IMMEDIATE vs DEFERRED, indexes and EXPLAIN QUERY PLAN, JSON1/JSONB with generated-column indexing, the Go client (database/sql with mattn/go-sqlite3 or modernc.org/sqlite), and server-side production use (Litestream/LiteFS/Turso/D1).

Installation

1

Add the marketplace

/plugin marketplace add ChristopherDavenport/christopherdavenport-marketplace
2

Install plugins

/plugin

Run these commands in Claude Code to add this plugin to your environment. The marketplace must be added before you can install its plugins.