Skip to content

Grafana Datasource Plugin

The Micromegas Grafana datasource plugin enables you to query your telemetry data directly in Grafana dashboards using SQL queries via Apache Arrow FlightSQL protocol.

Plugin Origin

This plugin was forked from InfluxDB's FlightSQL Grafana plugin and adapted for Micromegas while maintaining FlightSQL protocol compatibility.

Overview

The plugin provides:

  • SQL Query Builder: Visual interface for building queries with dropdowns for tables and columns
  • Raw SQL Mode: Full SQL support for complex queries
  • Multiple Authentication Methods: Choose between API keys or OAuth 2.0 client credentials
  • Time-Series Visualization: Native support for Grafana time-series panels
  • Table Support: Display query results in Grafana tables

Quick Start

Prerequisites

  • Grafana 9.0 or later
  • Micromegas analytics server (flight-sql-srv) running
  • Authentication credentials (API key or OAuth 2.0 client credentials)

Installation

  1. Download the latest plugin release
  2. Extract to your Grafana plugins directory
  3. Restart Grafana
  4. Add Micromegas as a data source

For detailed installation instructions, see the Installation Guide.

Adding a Data Source

  1. Navigate to Configuration → Data Sources in Grafana
  2. Click Add data source
  3. Search for and select Micromegas
  4. Configure connection settings:
  5. Host: Your flight-sql-srv address (e.g., localhost:50051)
  6. Authentication Method: Choose API Key or OAuth 2.0
  7. TLS/SSL: Enable if your server uses TLS
  8. Click Save & Test

For detailed configuration, see the Configuration Guide.

Key Features

Query Builder

The visual query builder helps you construct SQL queries:

  • Select tables from dropdown
  • Choose columns with autocomplete
  • Add WHERE clauses with + button
  • Switch to raw SQL for advanced queries

Authentication Options

Choose the authentication method that fits your environment:

  • API Keys: Simple, direct authentication (recommended for quick setup)
  • OAuth 2.0 Client Credentials: Enterprise-grade authentication with identity provider integration

See the Authentication Guide for setup instructions.

FlightSQL Protocol

The plugin uses Apache Arrow FlightSQL protocol for efficient data transfer:

  • High-performance binary protocol
  • Efficient columnar data format
  • Streaming support for large result sets
  • Compatible with any FlightSQL server

Documentation

Development

For development instructions, see the grafana/DEVELOPMENT.md file in the repository.

Support

For issues or questions: