Plugins 〉Sqlyze Datasource


Developer

Grafana Labs

Sign up to receive occasional product news and updates:



Data Source
grafana
Enterprise

Sqlyze Datasource

Documentation →

Grafana Sqlyze Data source

A Grafana data source plugin that connects to hundreds of datasources using one language: SQL. Connect to your favorite SQL databases, NoSQL databases, and many other non-SQL sources...and query them with SQL.

This plugin is not yet supported in Grafana Cloud.

The data source uses ODBC

This plugin has a dependency on ODBC. Windows/Linux/MacOS all support ODBC. Some dependencies may need to be installed.

Using ODBC with Linux ARM or MacOS

Install or make sure unixODBC is installed

https://www.ibm.com/docs/en/db2/11.5?topic=managers-installing-unixodbc-driver-manager

This plugin requires an ODBC driver. ODBC Drivers are available through 3rd parties. See below for a list.


Time series

To format your queries for time series, simply use the alias: as time

select date_start as time, foo, avg(bar) as bar
from foo_bar

Short list of known drivers and settings

DB2

SettingExample Value
Driver/Applications/dsdriver/lib/libdb2o.dylib
Timeout (seconds)10
host127.0.0.1
port50000
uiddb2inst1
pwd••••••••••••
databasesample

Impala

Databricks

Third party drivers

Settings vary per driver. This plugin allows any key/value pair to support various ODBC drivers.

Installing Sqlyze Datasource:

For more information, visit the docs on plugin installation.

Installing on a local Grafana:

For local instances, plugins are installed and updated via a simple CLI command. Plugins are not updated automatically, however you will be notified when updates are available right within your Grafana.

1. Install the Data Source

Use the grafana-cli tool to install Sqlyze Datasource from the commandline:

grafana-cli plugins install 

The plugin will be installed into your grafana plugins directory; the default is /var/lib/grafana/plugins. More information on the cli tool.

2. Configure the Data Source

Accessed from the Grafana main menu, newly installed data sources can be added immediately within the Data Sources section.

Next, click the Add data source button in the upper right. The data source will be available for selection in the Type select box.

To see a list of installed data sources, click the Plugins item in the main menu. Both core data sources and installed data sources will appear.

Changelog

v1.5.11 - 2025-02-04

  • update frontend dependencies

v1.5.10 - 2025-01-10

  • ⚙️ Chore: Update backend dependencies

v1.5.9 - 2025-01-06

  • ⚙️ Chore: update backend dependencies

v1.5.8 - 2024-12-18

  • ⚙️ Chore: Update backend dependencies

v1.5.7 - 2024-12-16

  • ⚙️ Chore: Update backend dependencies

v1.5.6 - 2024-11-12

  • ⚙️ Chore: Updated backend dependencies

v1.5.5 - 2024-10-03

  • ⚙️ Chore: Update frontend dependencies
  • ⚙️ Chore: Minimal supported Grafana version is now 10.4.8

v1.5.4 - 2024-10-01

  • ⚙️ Chore: log more in test mode

v1.5.3 - 2024-09-24

  • ⚙️ Chore: add some helpful logging on env variables

v1.5.2 - 2024-09-24

  • 🐛 Fix: fix default time to UTC not local

v1.5.1 - 2024-09-23

  • ⚙️ Chore: Update backend dependencies

v1.5.0 - 2024-09-13

  • ⚙️ Chore: Update UI and documentation

v1.4.3 - 2024-08-30

  • ⚙️ Chore: update backend dependencies

v1.4.2 - 2024-06-19

  • ⚙️ Chore: update backend dependencies

v1.4.1 - 2024-04-19

  • 🐛 Fix: Dynamic frame panic

v1.4.0 - 2024-04-10

  • 🐛 Fix: Cross-compile on older versions of linux to lower glibc version requirements

v1.3.1 - 2024-03-13

  • ⚙️ Chore: Backend binaries are now compiled with Go version 1.22.1

v1.3.0 - 2023-10-30

  • ⚙️ Chore: Update sqlds and sdk to capture error source

v1.2.0 - 2023-10-24

  • ⚙️ Chore: Update Grafana npm dependencies to 9.5.13

v1.1.7 - 2023-10-04

  • 🐛 Fix: VariableQueryEditor - model updates without running queries

v1.1.6 - 2023-10-02

  • 🐛 Fix: VariableQueryEditor - trigger model update onblur

v1.1.5 - 2023-09-08

  • ⚙️ Chore: binary compiled with newest version of the plugin-sdk which fixes bugs when dealing with float32 types

v1.1.4 - 2023-06-08

  • ⚙️ Chore: backend libs updated with golang:1.20.5

v1.1.3 - 2023-06-05

  • ⚙️ Chore: Backend dependencies updated

v1.1.2 - 2023-05-05

  • ⚙️ Chore: Backend binaries are now compiled with Go 1.20.4

v1.1.1 - 2023-04-20

  • ⚙️ Chore: Backend binaries are now compiled with Go 1.20.3

v1.1.0 - 2023-01-24

  • 🚀 Feature: include unixodbc libs in linux amd64 dist

v1.0.2 - 2022-12-21

  • ⚙️ Chore: Backend binaries are now compiled with Go 1.19.4
  • ⚙️ Chore: Backend Grafana dependencies updated to latest version
  • ⚙️ Chore: Add spellcheck

v1.0.1 - 2022-07-11

  • 🐛 Fix: default time to UTC not Local

v1.0.0 - 2022-06-16

  • 🐛 Fix: run button position on variable page

v0.4.1 - 2022-06-09

  • 🐛 Fix: set exec permission

v0.4.0 - 2022-04-29

  • 🚀 Feature: Template variables

v0.3.0 - 2022-04-28

  • 🚀 Feature: Infer data types

v0.0.2 - 2022-04-25

  • Beta release.