Design SQLite schemas, migrations, and performance tuning for embedded apps.
npx skills add https://github.com/erikstmartin/dotfiles --skill sqlite-erikstmartin
Please help me install this Agent Skill. Skill: sqlite Source: https://github.com/erikstmartin/dotfiles/tree/main/skills/catalog/sql/sqlite Command: npx skills add https://github.com/erikstmartin/dotfiles --skill sqlite-erikstmartin
This skill provides structured guidance for designing and deploying SQLite databases, covering schema design, safe migrations, performance tuning, and appropriate WAL/locking configurations.
Create a starter SQLite schema and apply the recommended pragmas and migration steps to begin.
High-intent search queries and answers about installing and using this skill.
To configure SQLite WAL mode for concurrent access, apply write-ahead logging pragmas and locking configurations. This enables reliable, concurrent read and write access in embedded applications by managing how the database file handles simultaneous transactions safely.
The best way to structure SQLite schema design is to apply explicit integrity constraints and practical indexing strategies. Proper constraints ensure data validity in local file-based deployments, while efficient indexing optimizes query performance for embedded apps.
To run safe SQLite migrations in an embedded application, use concurrency-aware migration patterns. This involves applying schema changes with proper locking configurations to prevent database corruption or locks during local file-based deployments.
Yes, SQLite performance tuning works for small-to-mid scale local data stores. By adjusting pragmas, applying efficient indexing strategies, and configuring WAL mode, you can optimize database reliability and query speed for embedded applications.
You need to adjust SQLite locking configurations when your embedded application requires safe migrations or concurrent access. Proper locking prevents write conflicts and ensures reliable performance across small-to-mid scale local file-based deployments.
twillcocksInitialize a Showpane workspace by installing dependencies and applying the SQLite Prisma schema.
randalmurphalConfigure WAL mode and checkpoint timing for SQLite multiprocessing in Python.
congiulucConfigure SQLite pragmas, WAL mode, indexing, and migrations for .NET applications.
darkamenosaGenerates Rails application skeletons with built-in support for templating.
