skills.rest
go-again
go-againOFFICIAL
Explore all skills by this author →
GitHub

sqlite-search

Add vector, full-text, and hybrid search to LiteORM's SQLite backend.

5|Updated Jun 18, 2026
Search Tags:#SQLite#search#vector search#full-text search#LiteORM
One-click install
npx skills add https://github.com/go-again/liteorm --skill sqlite-search
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sqlite-search
Source: https://github.com/go-again/liteorm/tree/main/skills/sqlite-search
Command: npx skills add https://github.com/go-again/liteorm --skill sqlite-search

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires liteorm, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill addresses the challenge of efficiently searching and retrieving data within LiteORM's SQLite backend, providing powerful vector, full-text, and hybrid search options.

Core Features & Use Cases

  • Vector Search: Leverage vector embeddings for accurate and fast similarity-based searches.
  • Full-Text Search: Utilize FTS5 for fast and flexible text search capabilities.
  • Hybrid Search: Combine vector and full-text search for a comprehensive search experience.
  • Use Case: Suppose you have a database of articles, and you want to quickly find articles related to a specific topic or those similar to a given reference vector.

Quick Start

To use the sqlite-search skill, first declare the necessary indexes on your model, then use the provided search helpers to perform queries against your SQLite database.

Frequently Asked Questions about sqlite-search

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

FAQPage Schema
How do I add vector search to a LiteORM SQLite backend?▼

To enable full-text search in SQLite, this Skill utilizes the FTS5 extension to provide fast and flexible text search capabilities within your LiteORM backend. It allows for efficient text querying across stored content.

Can I combine full-text and vector search in SQLite?▼

This Skill requires the LiteORM dependency and SQLite's search extensions to function properly. You must have LiteORM configured as your SQLite backend before declaring indexes and using the provided search helpers.

What is the best way to search a knowledge base stored in SQLite?▼

To implement hybrid search, declare the necessary vector and full-text indexes on your LiteORM model, then use the provided search helpers to execute combined queries. This allows you to find articles related to a specific topic or similar to a reference vector.

Does LiteORM support SQLite search extensions like FTS5?▼

Yes, you can use these search capabilities for content management systems. The Skill is designed for efficient data retrieval in administrative workflows, making it particularly useful for searching databases of articles and knowledge bases.

Related Skills

Explore More Software Engineering Skills→
go-againgo-again
5

quicsql

Connect LiteORM to a remote quicSQL server with mTLS authentication.

Official
Intermediate
ratacatratacat
49

brave-search

Search the Brave Search API for web results, images, and news with citations.

Community
Advanced
SignmanalSignmanal
1

chroma

Store and query vector embeddings with metadata filtering for RAG applications.

Community
Intermediate
as4584as4584
2

hybrid-search-implementation

Combine vector and keyword search results using RRF, linear combination, or cross-encoder reranking.

Community
Advanced