All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog and follows semantic Versioning.

The following changes are waiting for the next major release:

• supporting only Grafana v10 onwards

• Improve error message when opening a WAL-mode database from a read-only directory: the hint now explains that SQLite requires write access to the directory for the shared-memory (-shm) file and links to the FAQ for solutions.

• Expand FAQ entry "I want to open a read only database and get errors" with the root cause explanation, how to detect WAL mode, and three remediation options (journal_mode=DELETE, writable directory, immutable=1).

• update Go to 1.26.1 (CVE-2025-68121) and grpc to v1.80.0 (CVE-2026-33186)
• update frontend and backend dependencies

• updating the backend (go) and frontend (npm) packages

This is a "semantic versioning" major release and contains breaking changes.

Migration Instructions: The following is the list of breaking changes and how to deal with them.

• AttachLimit: The attach limit has been set to 0 by default. In order to set a value above 0 the unsafe_allow_attach_limit_above_zero plugin configuration value has to be set.

• Default Grafana Internal Blocklist: The plugin blocks various grafana internal paths by default now. In to unblock those set unsafe_disable_grafana_internal_blocklist in the plugin configuration. As per the release of this version the blocked path elements are the following:

  • grafana.db

  For an up to date list please see the plugin documentation

• Default Security Path Blocklist: The plugin blocks various security related paths by default now. In to unblock those set unsafe_disable_security_blocklist in the plugin configuration. As per the release of this version the blocked path elements are the following:

  • .aws
  • .config/gcloud
  • .azure
  • .kube/config
  • .docker/config
  • .ssh
  • .gnupg
  • .pki
  • /etc/shadow
  • /etc/passwd
  • /etc/gshadow
  • /proc/
  • /sys/
  • .env
  • credentials
  • .git/config
  • .netrc
  • .npmrc
  • .pypirc
  • id_rsa
  • id_dsa
  • id_ecdsa
  • id_ed25519

  For an up to date list please see the plugin documentation

• Read only connection: The plugin now sets the _pragma=query_only(1) path option if not specified otherwise. To prevent this use unsafe_disable_query_only_path_option.

• the default value of "AttachLimit" is now 0 (can be adjusted)
• there is a list of "security related" path prefixes, which are blocked by default (can be adjusted)
• adding _pragma=query_only(1) as a default path option (can be adjusted)

• Upgraded some frontend packages due to security alerts

• Replaced the Linux 32-Bit ARM build with an ARMv6 build. This was already the case in v 3.5.0 and below. This should allow seamless usage of the plugin on Raspberry Pi Zero models.

• Added the "block_list" option to allow setting a list of SQLite paths that cannot be accessed

• updated the underlying sqlite library (using SQLite 3.50.1)

• updated the underlying sqlite library

• Added the ability to use "**text" and "**value" columns for query variables

Thank you to the collaborators on this release:

• @eeddaann

• added support for Grafana annotations

• updated frontend packages with the grafana/create-plugin tool

• queries without any content (i.e. "-- not a query") do not cause the plugin to hang

• updated the underlying sqlite library

• Closing database connections after every query (bug from v3.3.0)

• Functional regression: a query without any content (i.e. "-- not a query") causes the plugin to hang

• updated sqlite package version to allow setting limits

• add option to set SQLITE_LIMIT_ATTACHED (current default 10). In a future version the default will be reduced to 0.

• updated go version and go grafana plugin sdk
• use grafana plugin sdk mage file to build the plugin
• update grafana plugin npm packages

Nothing user facing was changed. The only difference is a change in meta data to accommodate new Grafana plugin checks.

• updated go SQLite package to v1.22.1 to fix timezone issues in SQLite

• updated go SQLite package

• removed the "name" metadata from data frames

• Using a different component as the SQL editor
• Updated Readme and added more docs (e.g. example queries)
• improved error message for database checks on folder paths

I would like to thank the sponsors of this project

• one-time: @nikolaialex

This release should show no feature changes. Some underlying packages have been updated, which should improve stability and security but not have any other noticeable impact.

• Fixed some typos in the readme
• Removed the upper Grafana version constraint for the plugin
• Update grafana plugin sdk for the backend
• Updated grafana buildkit and test tool versions for the frontend

This release moved to a new underlying SQLite library: https://pkg.go.dev/modernc.org/sqlite. This should have no big changes to regular queries but can have effects on more subtle configurations (e.g. path options). Fore more information see the Changed section below.

This library has no dependency on CGO, which allows much easier cross-compilation for other systems. This way the plugin has a much simpler build process now and also supports more platforms (see information below under Added)

• Added new platforms to the release: Darwin (MacOS) for ARM (Apple Silicon) and FreeBSD for AMD64

• Changed the underlying SQLite library to: https://pkg.go.dev/modernc.org/sqlite. While the general SQLite features and especially queries should remain unchanged by this, path options need to be checked for compatibility with the new library now. Please refer to the link above for more information on the options.

• No separate release is created anymore for ARM v7. ARM v6 should suffice for all devices. If that is not the case for your device, please open a new issue.

• An additional option securePathOptions has been added in case the user wants to protect some options (typically credentials). For examples see here: https://github.com/mattn/go-sqlite3#connection-string

The plugin now supports adding a Path Prefix and Options to the SQLite connection string.

• Ability to provide a prefix and options in the connection string. For examples see here: https://github.com/mattn/go-sqlite3#connection-string

• slightly changed the Plugin Health Check (when adding the data source) to provide better error messages.
• conversion errors during a query are now logged at DEBUG level to avoid too large log files.

This release adds support for sub second precision for unix time.

• When using numeric values for a timestamp in SQLite (unix timestamp) the plugin now supports precision below the second (at nanosecond precision)

This release adds the JSON extension to the compiled SQLite code.

• JSON extension for SQLite

This release adds testing against Grafana v8.1.0 and fixes an issue with query variables.

• Query variables can now also be used in Grafana v8.X.X

This release fixes some long standing issues that prevented the right use of the alerting feature of the plugin even though it was enabled already.

• Using the $__from and $__to variables for alerting
• Fixing a caching bug for the query (for alerting)

All current Raspberry Pi Zero and 1 models have an ARMv6 architecture. All other models (2 Mod. B v1.2, 3 and 4) have an 64Bit ARMv8 architecture. As only the Raspberry Pi 2 Mod. B has an ARMv7 architecture this is not used as default anymore. The Raspberry Pi 2 Mod. B will require a manual installation and all others will be handled via the Grafana CLI.

• Using ARMv6 instead of ARMv7 as 32Bit ARM default

• More debug level logging from the plugin

• The type inference of columns in the backend is now ignoring the letter casing

• The response of the plugin includes the final query as metadata and can be checked in the inspector now
• Macro unixEpochGroupSeconds:
  • replace time columns with an expression to group by
  • Allow filling up missing values with NULL

• return additional time formatted column for time-series formats as normal values (previously they were skipped)

• Experimental support for MacOS (no static linking)

• Showing better error messages for certain fail conditions of the plugin health check (e.g. permission error)

• Fixed bug preventing using query variables when SQLite is the default datasource (<= Grafana 7.4)

• Enabled the alerting feature for the plugin (no code change)

No breaking change was introduced but due to code stability the first major version is released.

• variables like $__interval and $__interval_ms are supported now

• Changing plugin name to SQLite
• added category to plugin.json for better grouping on the Grafana homepage
• updated Readme after first official release of plugin on Grafana homepage

• Documentation about the time conversion in the README and in the query editor help text.

• Correct handling of "NUMERIC" columns with mixed data (e.g. float and integer)

• Added option to explicitly convert backend data frame to time series:

  • This requires the initial data frame to be in a Long Format
  • The resulting time series consists of one data frame per metric

• Releasing arm6 (RaspberryPi Zero) as separate distribution (Github only)

• Renamed the arm7 executable to arm (newer Raspberry Models should run fine now)

• Different content of zip file published with Github release according to new Grafana v7.3 standards

• Query variables are now supported

• The plugin is now signed

• For Signing grafana-toolkit 7.3.3 was necessary. The grafana version to test against was bumped to version 7.3.3

• Fixed: Handling of NULL values in queries is now correct

First "working" version

• Fixed: Plugin files in the zip file are now executable