Skip to main content
Glama
wise-toddler

redash-mcp

by wise-toddler
OverviewSchemaRelated ServersScoreDiscussions
Python
Remote

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

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

Install Server
A
license - permissive license
A
quality
B
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
3wRelease cycle
3Releases (12mo)

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/wise-toddler/redash-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server