search_notes_sql
Execute SQL SELECT queries to search and filter notes from the Flint Note vault. Retrieve data from tables like notes and note_metadata, with options for parameterized queries, field selection, and result limits.
Instructions
Direct SQL search against notes database for maximum flexibility. Only SELECT queries allowed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fields | No | Optional array of field names to include in response. Supports dot notation for nested fields (e.g. "metadata.tags") and wildcard patterns (e.g. "metadata.*"). If not specified, all fields are returned. | |
| limit | No | Maximum number of results | |
| params | No | Optional parameters for parameterized queries | |
| query | Yes | SQL SELECT query. Tables: notes (id, title, content, type, filename, path, created, updated, size), note_metadata (note_id, key, value, value_type) | |
| timeout | No | Query timeout in milliseconds | |
| vault_id | No | Optional vault ID to operate on. If not provided, uses the current active vault. |