sqlite
Execute SQLite commands and search documents using keyword, semantic, and hybrid retrieval methods.
Instructions
SQLite database operations + document-corpus search. Commands: catalog, exec, list_databases, open_database, health_check, docs_search, docs_semantic_search, docs_hybrid, docs_full, docs_context, docs_search_in_doc. docs_search: FTS5 keyword search over the ingested docs corpus. Use for exact terms, API names, phrases. docs_semantic_search: Embedding similarity search over docs. Use for general queries. docs_hybrid: PREFER THIS Run both keyword + semantic with RRF fusion. Best recall. docs_full: Retrieve complete document by exact path. Use sql param with path from search results. Wildcard % optional for fuzzy match. docs_context: Expand around a chunk - params: {chunk_id, before, after}. docs_search_in_doc: Hybrid search within a specific document - params: {query, limit, threshold}. sql=path. Returns chunk positions. All docs search commands: query via 'sql' param. docs_* filters: {doc_type, source, limit, threshold}. docs_* results are pre-chunked - do NOT use file reads; run more searches or use docs_context/docs_full instead.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | No | SQL query, or search query for docs_search | |
| write | No | ||
| params | No | Query params or search filters: {doc_type, source, limit, threshold} | |
| command | Yes | ||
| sqlite_file | No | Database path: absolute or relative (resolved under ./data/). Ignored for docs_* commands. |