Obsidian SQLSeal
Query your vault using SQL
SELECT * FROM files
ORDER BY modified_at DESC
LIMIT 10
Query your notes and data using familiar SQL syntax. Perfect for both SQL experts and beginners.
Seamlessly work with CSV and JSON files in your vault. Preview, query, and even edit them directly in Obsidian.
Works on both desktop and mobile devices. Your data insights everywhere you go.
You can query any CSV and JSON data stored in your vault. SQLSeal can help you analyse your finances, workouts, goals and whatever you imagine!
TABLE commute = file(transport.csv)
SELECT
Date,
transport_type,
SUM(distance_km) AS total_distance,
group_concat(purpose) as purposes
FROM commute
WHERE date = @date
GROUP BY Date, Transport_Type
date | transport_type | total_distance | purposes |
---|---|---|---|
2024-01-02 | bike | 8.4 | commute |
2024-01-02 | walk | 6.2 | lunch,leisure |
Take your analysis to the next level with SQLSeal Charts that expands the plugin with full visualisation tool.
Coming Soon
SQLSeal Charts is currently being reviewed by Obsidian. As soon as it gets approved, full documentation will be released.