redash-mcp

English | 한국어 | 日本語

MCP server that connects Redash to Claude AI — query data, manage dashboards, and run SQL with natural language.

Features · Install · Env · Examples · Privacy

---

Features

Tools

Category	Tool	Description
Data Sources	list_data_sources	List connected data sources
Schema	list_tables	List tables (supports keyword search)
Schema	get_table_columns	Get column names and types
Query	run_query	Execute SQL and return results
Saved Queries	list_queries	List saved queries
Saved Queries	get_query	Get query details (SQL, visualizations)
Saved Queries	get_query_result	Run a saved query and get results
Saved Queries	create_query	Save a new query
Saved Queries	update_query	Update a saved query
Saved Queries	fork_query	Fork a saved query
Saved Queries	archive_query	Archive (delete) a query
Dashboards	list_dashboards	List dashboards
Dashboards	get_dashboard	Get dashboard details and widgets
Dashboards	create_dashboard	Create a new dashboard
Dashboards	add_widget	Add a visualization widget to a dashboard
Alerts	list_alerts	List alerts
Alerts	get_alert	Get alert details
Alerts	create_alert	Create a new alert

SQL Safety Guard

Protects your database from dangerous queries:

• Blocked always: DROP, TRUNCATE, ALTER TABLE, GRANT/REVOKE, DELETE/UPDATE without WHERE
• Warned (warn mode) / Blocked (strict mode): SELECT *, queries without WHERE or LIMIT, PII column access
• Auto-LIMIT: Automatically appends LIMIT N when REDASH_AUTO_LIMIT is set

Query Cache

Results are cached in-memory to reduce redundant API calls:

• TTL: configurable via REDASH_MCP_CACHE_TTL (default: 300s)
• Max memory: configurable via REDASH_MCP_CACHE_MAX_MB (default: 50MB)

---

Installation

Auto Setup (Recommended)

npx redash-mcp setup

The setup wizard will guide you through configuring Claude Desktop, Claude Code (CLI), or both.

Shell Script Install

Installs Node.js, Claude Desktop, and MCP config all at once:

curl -fsSL https://raw.githubusercontent.com/seob717/redash-mcp/main/install.sh | bash

Manual Setup

1. Get your Redash API Key

Go to Redash → Profile (top right) → Edit Profile → Copy API Key

2-A. Claude Desktop

Open ~/Library/Application Support/Claude/claude_desktop_config.json and add:

{
  "mcpServers": {
    "redash-mcp": {
      "command": "npx",
      "args": ["-y", "redash-mcp"],
      "env": {
        "REDASH_URL": "https://your-redash-instance.com",
        "REDASH_API_KEY": "your_api_key_here"
      }
    }
  }
}

Fully quit and restart Claude Desktop after saving.

2-B. Claude Code (CLI)

Open ~/.claude/settings.json and add:

{
  "mcpServers": {
    "redash-mcp": {
      "command": "npx",
      "args": ["-y", "redash-mcp"],
      "env": {
        "REDASH_URL": "https://your-redash-instance.com",
        "REDASH_API_KEY": "your_api_key_here"
      }
    }
  }
}

macOS: If npx is not found, run which npx to get the full path and use that instead.

---

Environment Variables

Required

Variable	Description
REDASH_URL	Redash instance URL (e.g. https://redash.example.com)
REDASH_API_KEY	Redash user API key

Optional

Variable	Default	Description
REDASH_SAFETY_MODE	`

... View full README on GitHub