sqlite-expert
CommunityMaster SQLite performance and features.
Author0xMerl99
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the challenges of optimizing SQLite databases for performance, efficiently handling advanced features, and avoiding common pitfalls in application development.
Core Features & Use Cases
- Performance Tuning: Guides on enabling WAL mode, setting busy timeouts, and optimizing schemas with indexes.
- Advanced Features: Demonstrates usage of FTS5 for full-text search, JSON1 extension for semi-structured data, recursive CTEs, and window functions.
- Use Case: Improve the responsiveness of a mobile application by optimizing its SQLite backend for concurrent read/write operations and faster query execution.
Quick Start
Use the sqlite-expert skill to configure optimal PRAGMA settings for a new SQLite database connection.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: sqlite-expert Download link: https://github.com/0xMerl99/FangAI/archive/main.zip#sqlite-expert Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.