search_text
Run a regex search over selected SQLite table columns in one call, with an optional SQL WHERE filter to narrow rows first. Returns matching key, column, and snippet rows plus totals.
Instructions
Regex search inside column values in one call: the WHERE filter narrows rows in SQL, then ripgrep matches the pattern over the selected columns. Returns CSV rows of key, column, snippet, one per matching value, plus a trailer with the totals.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Rows to return, 1 to 1000. | |
| table | Yes | Table or view to search. | |
| where | No | SQL WHERE clause (without the WHERE keyword) to narrow rows first. | |
| columns | No | Columns to search; defaults to the text columns. | |
| pattern | Yes | ripgrep (Rust regex) pattern; literal text when fixed_strings=true. | |
| key_column | No | Column that identifies a row in the results; defaults to rowid, required for views. | |
| ignore_case | No | ||
| context_chars | No | Characters of context around the match in the snippet. | |
| fixed_strings | No |