find_in_db
Search a SQLite database for a string or number across all non-BLOB columns. Returns matching rows, columns, and snippets, with per-table time and match limits to prevent long scans.
Instructions
Find where a string or number appears anywhere in the database: a substring search over every non-BLOB column of every ordinary table (virtual and shadow tables are skipped). Returns, per table, the matching rows (rowid or primary key), the column and a snippet around the match. Each table has a time budget and a match cap, so a huge database cannot hang the call; tables that ran out of budget are listed.
case_sensitive: default false (SQLite folds ASCII letters only, so Turkish or other non-ASCII letters match case-sensitively). max_matches_per_table: 1-50. seconds_per_table: 0.1-30.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| path | Yes | ||
| term | Yes | ||
| case_sensitive | No | ||
| seconds_per_table | No | ||
| max_matches_per_table | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |