A new Obsidian community plugin lets you run DuckDB SQL queries directly inside your notes. Query results render as interactive SQL panels with Run, Freeze, and Clear freeze buttons. Freezing a result embeds it as a plain markdown table with sentinel comments for future refreshes, keeping notes git-diffable and mobile-friendly. The plugin supports local DuckDB (reading Parquet, CSV, JSON, Excel, Iceberg, Delta, and geospatial files) and MotherDuck cloud connections side by side in the same note, making your vault a readable knowledge base for AI agents without hitting a warehouse.
Table of contents
Why Obsidian and AI fit togetherWhat it doesWait, isn't that Dataview?Quick startScheduled refreshLet your agent refresh notesWhy this matters: cache vs queryBonus: it runs on your phoneTry it7.9K Impressions