search_notes_sql
Perform SQL SELECT queries on the Flint Note database to retrieve and filter notes and metadata. Use predefined tables and fields for precise searches across notes, titles, content, and metadata.
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. |