Get frontmatter schema from files matching glob pattern.

Args: glob: Glob pattern relative to base directory (e.g. "atoms/**/*.md").

Returns: Dict with file_count, schema (type, nullable, examples).

Query frontmatter with DuckDB SQL.

Args: glob: Glob pattern relative to base directory (e.g. "atoms/**/*.md"). sql: SQL query string. Reference 'files' table. Columns are frontmatter properties plus 'path'.

Semantic search (when enabled and indexing is complete): - embedding: document embedding vector (NULL if not indexed) - embed('text'): converts text to embedding vector - array_cosine_similarity(a, b): similarity score (0-1)

Example - find similar documents:
    SELECT path,
           array_cosine_similarity(embedding, embed('search term')) as score
    FROM files WHERE embedding IS NOT NULL
    ORDER BY score DESC LIMIT 10

Returns: Dict with results array, row_count, and columns.

Update frontmatter properties in a single file.

Args: path: File path relative to base directory. set: Properties to add or overwrite. Values are applied as-is (null becomes YAML null, empty string becomes empty value). unset: Property names to remove completely.

Returns: Dict with path and updated frontmatter.

Notes: - If same key appears in both set and unset, unset takes priority. - If file has no frontmatter, it will be created.

Update frontmatter properties in multiple files matching glob pattern.

Args: glob: Glob pattern relative to base directory (e.g. "atoms/**/*.md"). set: Properties to add or overwrite in all matched files. unset: Property names to remove from all matched files.

Returns: Dict with updated_count, updated_files, and warnings.

Notes: - If same key appears in both set and unset, unset takes priority. - If a file has no frontmatter, it will be created. - Errors in individual files are recorded in warnings, not raised.

Add a value to an array property in multiple files.

Args: glob: Glob pattern relative to base directory (e.g. "atoms/**/*.md"). property: Name of the array property. value: Value to add. If value is an array, it's added as a single element. allow_duplicates: If False (default), skip files where value already exists.

Returns: Dict with updated_count, updated_files, and warnings.

Notes: - If property doesn't exist, it will be created with [value]. - If property is not an array, file is skipped with a warning. - Files are only included in updated_files if actually modified.

Remove a value from an array property in multiple files.

Args: glob: Glob pattern relative to base directory (e.g. "atoms/**/*.md"). property: Name of the array property. value: Value to remove.

Returns: Dict with updated_count, updated_files, and warnings.

Notes: - If property doesn't exist, file is skipped. - If value doesn't exist in array, file is skipped. - If property is not an array, file is skipped with a warning. - Files are only included in updated_files if actually modified.

Replace a value in an array property in multiple files.

Args: glob: Glob pattern relative to base directory (e.g. "atoms/**/*.md"). property: Name of the array property. old_value: Value to replace. new_value: New value.

Returns: Dict with updated_count, updated_files, and warnings.

Notes: - If property doesn't exist, file is skipped. - If old_value doesn't exist in array, file is skipped. - If property is not an array, file is skipped with a warning. - Files are only included in updated_files if actually modified.

Sort an array property in multiple files.

Args: glob: Glob pattern relative to base directory (e.g. "atoms/**/*.md"). property: Name of the array property. reverse: If True, sort in descending order. Default is ascending.

Returns: Dict with updated_count, updated_files, and warnings.

Notes: - If property doesn't exist, file is skipped. - If array is empty, file is skipped. - If array is already sorted, file is skipped. - If property is not an array, file is skipped with a warning. - Files are only included in updated_files if actually modified.

Remove duplicate values from an array property in multiple files.

Args: glob: Glob pattern relative to base directory (e.g. "atoms/**/*.md"). property: Name of the array property.

Returns: Dict with updated_count, updated_files, and warnings.

Notes: - Preserves the order of first occurrence. - If property doesn't exist, file is skipped. - If array is empty or has single element, file is skipped. - If array has no duplicates, file is skipped. - If property is not an array, file is skipped with a warning. - Files are only included in updated_files if actually modified.