Skip to main content
Glama

redash-mcp

Model Context Protocol (MCP) server for Redash - manage queries, dashboards, and visualizations through AI assistants like Claude.

Features

  • 7 tools, 30 actions - compressed for minimal context usage

  • Full query management (list, search, create, update, archive, delete, run, adhoc, export, schedule)

  • Dashboard management (list, get, create, publish, delete)

  • Widget management with positioning (add, move, delete)

  • Alert management (list, get, create, update, delete)

  • Visualization creation (pie, line, bar, counter charts)

  • Data source listing

Related MCP server: redash-mcp

Installation

pip install redash-mcp

Or with uvx:

uvx redash-mcp

Configuration

Environment Variables

Variable

Required

Description

REDASH_URL

Yes

Your Redash instance URL (e.g., https://redash.example.com)

REDASH_API_KEY

Yes

Your Redash API key

REDASH_TIMEOUT

No

Request timeout in seconds (default: 30)

Claude Code

Add to ~/.claude.json (user-level config):

{
  "mcpServers": {
    "redash": {
      "type": "stdio",
      "command": "uvx",
      "args": ["redash-mcp"],
      "env": {
        "REDASH_URL": "https://your-redash-instance.com",
        "REDASH_API_KEY": "your-api-key"
      }
    }
  }
}

Claude Desktop

Add to ~/Library/Application Support/Claude/claude_desktop_config.json:

{
  "mcpServers": {
    "redash": {
      "command": "uvx",
      "args": ["redash-mcp"],
      "env": {
        "REDASH_URL": "https://your-redash-instance.com",
        "REDASH_API_KEY": "your-api-key"
      }
    }
  }
}

Or if installed via pip:

{
  "mcpServers": {
    "redash": {
      "command": "redash-mcp",
      "env": {
        "REDASH_URL": "https://your-redash-instance.com",
        "REDASH_API_KEY": "your-api-key"
      }
    }
  }
}

Tools

redash_data_sources

List all available data sources.

redash_query

Manage Redash queries.

Action

Parameters

Description

list

page

List all queries (paginated)

search

q

Search queries by name

get

id

Get query details

create

name, query, data_source_id

Create new query

update

id, query?, name?

Update existing query

archive

id

Archive (soft-delete) query

delete

id

Permanently delete query

run

id, timeout?

Execute query and wait for results

adhoc

query, data_source_id

Execute SQL without saving

export

id, path

Export query results to file (.csv or .json)

schedule

id, interval, until?

Schedule query execution (interval in seconds)

redash_dashboard

Manage Redash dashboards.

Action

Parameters

Description

list

page

List all dashboards

get

id

Get dashboard with widgets

create

name

Create new dashboard

publish

id

Publish dashboard (remove draft)

delete

id

Delete dashboard

redash_widget

Manage dashboard widgets.

Action

Parameters

Description

add

dashboard_id, viz_id, col?, row?, sizeX?, sizeY?

Add visualization with optional position

move

id, col?, row?, sizeX?, sizeY?

Reposition/resize a widget

delete

id

Remove widget from dashboard

redash_alert

Manage query alerts.

Action

Parameters

Description

list

List all alerts

get

id

Get alert details

create

query_id, name, column, op, value, rearm?

Create alert on query result

update

id, name?, rearm?

Update alert settings

delete

id

Delete alert

redash_viz

Create visualizations.

Type

Parameters

Description

pie

query_id, name, x, y

Pie chart

line

query_id, name, x, y, datetime?

Line chart

bar

query_id, name, x, y, stacked?

Bar chart

counter

query_id, name, x, suffix?

Counter/KPI

Note: For multiple Y columns, pass comma-separated values: y="count,total,avg"

Examples

Create a dashboard with visualizations

1. redash_data_sources() → get data_source_id
2. redash_query(action="create", name="Daily Stats", query="SELECT ...", data_source_id=1)
3. redash_viz(type="line", query_id=123, name="Trend", x="date", y="count")
4. redash_dashboard(action="create", name="My Dashboard")
5. redash_widget(action="add", dashboard_id=456, viz_id=789)
6. redash_dashboard(action="publish", id=456)

Run ad-hoc query

redash_query(action="adhoc", query="SELECT COUNT(*) FROM users", data_source_id=1)

Export query results

redash_query(action="export", id=123, path="/tmp/results.csv")
redash_query(action="export", id=123, path="/tmp/results.json")

Search and update query

redash_query(action="search", q="daily")
redash_query(action="update", id=123, query="SELECT ... WHERE date > NOW() - INTERVAL '7 days'")

Python Library Usage

You can also use redash-mcp as a Python library:

import os
os.environ["REDASH_URL"] = "https://your-redash.com"
os.environ["REDASH_API_KEY"] = "your-key"

from redash_mcp import (
    list_queries, create_query, run_query,
    create_dashboard, publish_dashboard,
    line, bar, pie, counter,
    add_widget
)

# Create query
q = create_query("My Query", "SELECT * FROM events", data_source_id=1)

# Create visualization
viz = line(q["id"], "Events Trend", x="date", y=["count"])

# Create dashboard and add widget
d = create_dashboard("My Dashboard")
add_widget(d["id"], viz["id"])
publish_dashboard(d["id"])

Why redash-mcp?

  • Context efficient - Only 7 tools (~500 tokens) with 30 actions

  • Full-featured - Queries, dashboards, widgets, and visualizations

  • Production ready - Proper error handling and timeouts

  • Dual use - Works as MCP server and Python library

License

MIT

Available Tools

6 tools
redash_alertB

Manage Redash alerts. Actions: list, get, create, update, delete

Inputs: action (required), id, query_id, name, +4 more.

redash_dashboardC

Manage Redash dashboards. Actions: list, get, create, publish, delete

Inputs: action (required), id, name, page, +1 more.

redash_data_sourcesB

List all available data sources

Inputs: no named parameters.

redash_queryC

Manage Redash queries. Actions: list, search, get, create, update, archive, delete, run, adhoc, export, schedule

Inputs: action (required), id, q, name, +8 more.

redash_vizC

Create visualizations. Types: pie, line, bar, counter

Inputs: type (required), query_id (required), name (required), x, +4 more.

redash_widgetA

Manage dashboard widgets. Actions: add, move, delete

Inputs: action (required), id, dashboard_id, viz_id, +4 more.

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    TDQS

    A3.5/5.0

    Scored across 6 tools

    Disambiguation5/5

    Each tool targets a distinct Redash entity (alert, dashboard, data source, query, viz, widget) with clearly separate purposes, no ambiguity for an agent.

    Naming Consistency5/5

    All tools follow a consistent 'redash_<resource>' pattern with snake_case; the slight plural in 'data_sources' does not break the pattern.

    Tool Count5/5

    6 tools cover the main Redash resources without being overwhelming or too sparse, well-scoped for the domain.

    Completeness4/5

    Covers CRUD for alerts, dashboards, queries, and widgets, and lists data sources. Missing update/delete for visualizations is a minor gap.

    Maintenance

    ActivityInactive
    ResponsivenessNo recent community issues

    Related MCP Connectors

    Related MCP Servers

    • A
      license
      B
      quality
      B
      maintenance
      Model Context Protocol (MCP) server that integrates Redash with AI assistants like Claude, allowing them to query data, manage visualizations, and interact with dashboards through natural language.
      67
      4,563 npm
      108
      MIT
    • A
      license
      A
      quality
      B
      maintenance
      MCP server that connects Redash to Claude AI, enabling natural language data queries, dashboard management, and SQL execution.
      25
      2,645 npm
      1
      MIT
    • F
      license
      Not graded
      quality
      C
      maintenance
      Model Context Protocol (MCP) server that gives AI assistants a safe, correct data-analyst capability over business metrics - without raw SQL improvisation.
      -