skills.rest
aegntic
aegnticCOMMUNITY
Explore all skills by this author →
Website𝕏@aegnticGitHub

sqlite-expert

Optimize SQLite performance using WAL mode, FTS5, and JSON1 extensions.

4|1|Updated Mar 3, 2026
Search Tags:#database#sqlite#sql#performance tuning#fts5#json1
One-click install
npx skills add https://github.com/aegntic/clawreform --skill sqlite-expert-aegntic
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlite-expert
Source: https://github.com/aegntic/clawreform/tree/main/crates/clawreform-skills/bundled/sqlite-expert
Command: npx skills add https://github.com/aegntic/clawreform --skill sqlite-expert-aegntic

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps users overcome common challenges and optimize the performance of SQLite databases, enabling efficient use of its advanced features beyond basic storage.

Core Features & Use Cases

  • Performance Tuning: Guides on enabling WAL mode, setting busy timeouts, and designing effective indexes.
  • Advanced Features: Demonstrates usage of FTS5 for full-text search, JSON1 extension for semi-structured data, and window functions for complex queries.
  • Use Case: Optimize a mobile application's SQLite database for faster read/write operations and implement efficient full-text search capabilities.

Quick Start

Configure SQLite with optimal PRAGMA settings for performance and concurrency.

Frequently Asked Questions about sqlite-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize SQLite performance for concurrent read and write operations?▼

To optimize SQLite performance for concurrent access, enable WAL mode and configure busy timeouts. These PRAGMA settings allow simultaneous readers and a single writer, significantly improving database throughput.

What is the best way to implement full-text search in an SQLite database?▼

The best way to implement SQLite full-text search is using the FTS5 extension. FTS5 provides advanced indexing and querying capabilities for fast text searches, making it ideal for mobile applications and embedded databases.

How do I configure SQLite PRAGMA settings for optimal database performance?▼

Configuring SQLite PRAGMAs involves setting parameters like WAL mode and busy timeout. Applying these optimal PRAGMA settings ensures efficient database performance and proper concurrency handling.

Why does my SQLite database lock during concurrent writes and how can I tune it?▼

SQLite database locking during concurrent writes occurs due to default journal modes. Tuning SQLite by enabling WAL mode and setting busy timeouts resolves this by allowing concurrent reads alongside write transactions.

Can I use the JSON1 extension with SQLite for semi-structured data?▼

Yes, SQLite handles semi-structured data using the JSON1 extension. This feature allows you to store, query, and manipulate JSON documents directly within the SQLite database using specialized functions.

Related Skills

Explore More Software Engineering Skills→
erikstmartinerikstmartin
16

sqlite

Design SQLite schemas, migrations, and performance tuning for embedded apps.

Community
Advanced
randalmurphalrandalmurphal

sqlite-best-practices

Configure WAL mode and checkpoint timing for SQLite multiprocessing in Python.

Community
Advanced
bughqbughq
2

stacks-orm

Define database models and execute queries with Stacks ORM.

Official
Advanced
saintgo7saintgo7

postgres-migration-from-sqlite

Migrate FastAPI/SQLAlchemy/Alembic services from SQLite to PostgreSQL.

Community
Advanced