prisma-sqlite-expert

What problem does it solve?

Provides authoritative, production-oriented guidance to avoid common pitfalls when using Prisma with SQLite, including unsafe default PRAGMA settings, migration drift with FTS virtual tables, write contention, and inefficient query patterns that lead to full-table scans or SQLITE_BUSY errors.

Core Features & Use Cases

• Expert recommendations for connection PRAGMA configuration to improve concurrency and reliability.
• Schema design patterns, indexing rules, and migration workflows (including manual migrations for FTS5 and the copy-table pattern).
• Query optimization, transaction strategies, FTS5 setup and triggers, backup and WAL checkpoint guidance, and BigInt/JSON serialization best practices.
• Use case: convert a development Prisma schema into a production-safe SQLite deployment with FTS-backed search, reliable migrations, and monitoring procedures.

Quick Start

Use the prisma-sqlite-expert skill to audit a Prisma schema, recommend production PRAGMA settings, and outline a safe migration plan to add FTS5 and required triggers.