SQLSeal Charts

SQLSeal Charts is an extension for SQLSeal Obsidian Plugin allowing to visualise your data using charts!

Powered by ECharts. Check their documentation for more examples of usage.

Features

• Support for basic charts: line, bar, pie charts
• Support for compex charts like scatterplot, heatmap, etc.

Getting started

Install the plugin by downloading latest release and unpacking it in .obsidian/plugins/sqlseal-charts. Make sure you have SQLSeal plugin already installed.

Example query

Pie Chart

Query below takes the first table in your current markdown tile and displays it as a piechart.

TABLE finances = table(0)

CHART {
    series: [{
        type: 'pie'
    }]
}
SELECT * FROM finances

Line Chart

CHART {
    xAxis: {
        type: 'category'
    },
    yAxis: {},
        series: [{
        type: 'bar',
        }]
}
SELECT
    strftime("%Y-%m-%d", created_at) as created_date,
    COUNT(*) as count
FROM files
GROUP BY created_date
ORDER BY created_date

Syntax

SQLSeal Charts uses ECharts under the hood. It automatically exposes data returned by your SQL query as a data dataset in ECharts. This means you can generate plenty of charts without worrying too much about how the data is being passed down. For more complex use-cases, you can always refer to the data by column name, it's index or even filter it down to create separate data-sets for different series. To read more about datasets, check out ECharts documentation.

For more advanced transformations, SQLSeal Charts exposes the following data and functions to be used to transform data further.

Data

Functions

The following functions are exposed in your query to allow you to further process data.