The SQLSeal plugin enables Obsidian users to transform CSV files in their vault into SQL databases for advanced querying. By creating sqlseal code blocks, users can define tables based on CSV files and execute SQL statements like SELECT, providing powerful data manipulation and analysis capabilities directly within Obsidian. Multiple tables can be defined in a single snippet, and tables remain local to the note for efficient organization. This plugin is ideal for managing and querying structured data within a vault, seamlessly integrating database functionality into the note-taking environment.
SQLSeal allow you to query for files, tags and tasks in your vault using familar SQL syntax.
It also enables you to preview any CSV file in your vault as a database.
It brings fully featured database into your vault!
You can install plugin from the Community Plugins directly from Obsidian, just look for SQLSeal in the marketplace.
To manually install the package, open Releases and download .zip of the last one. Unzip it in your vault under .obsidian/Plugins/sqlseal.
Once you install the plugin, you can use it by creating sqlseal codeblocks in your notes. To create table base on the existing CSV file in your vault simply address it using the following command:
TABLE transactions = file(transactions.csv)
SELECT * FROM transactions LIMIT 10The code above will create table called transactions based on the transactions.csv file from your vault. Further you can refer to it using regular SELECT statements.
You can define multiple tables in a single snippet. You can also point to the tables defined in different snippets within the same note (for now tables stay local to the file).
For more comprehensive documentation head to hypersphere.blog/sql-seal.
The plugin authors do not take any resposibility for any potential data loss. Always backup your files before usage. That said, plugin does not modify any files in the Vault so you should be fine :)
If you have any questions about the project, ideas or want to share your use-cases, join our Discord Channel!