how-to-do-full-text-search-with-sqlite
CommunitySupercharge SQLite with fts5 search.
Authorrodydavis
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the challenge of efficiently searching large text-based datasets within SQLite databases, providing a more powerful and performant alternative to simple LIKE queries.
Core Features & Use Cases
- Full-Text Search Indexing: Leverages SQLite's
fts5extension to create optimized search indexes. - Efficient Querying: Enables fast and relevant searches using the
MATCHkeyword. - Data Synchronization: Provides methods (triggers, rebuild commands) to keep the search index in sync with source tables.
- Use Case: Quickly find all blog posts containing specific keywords or phrases within a SQLite database, even across multiple fields like title, description, and content.
Quick Start
Use the how-to-do-full-text-search-with-sqlite skill to create a virtual table for full-text search on your 'posts' table.
Dependency Matrix
Required Modules
None requiredComponents
references
💻 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: how-to-do-full-text-search-with-sqlite Download link: https://github.com/rodydavis/skills/archive/main.zip#how-to-do-full-text-search-with-sqlite 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.