How do I install Redash?

Redash is a local plugin. Install it using npm package: redash-mcp and add the generated configuration snippet to your AI app's MCP config file. Then restart your AI app.

What credentials does Redash need?

Redash requires the following credentials or environment variables: REDASH_URL, REDASH_API_KEY. You can find setup instructions on the server detail page.

What AI apps work with Redash?

Redash uses the Model Context Protocol (MCP) and works with any MCP-compatible AI app, including Claude, ChatGPT / Codex, Gemini, Copilot, Cursor, and more.

Back to Browse

Redash MCP Server

by seob717

Developer ToolsModerate7.0Local

Free

Connect Redash to Claude -- query data, manage dashboards, and run SQL with natural language.

About

Connect Redash to Claude -- query data, manage dashboards, and run SQL with natural language.

Security Report

7.0

Moderate7.0Low Risk

Valid MCP server (2 strong, 5 medium validity signals). 4 known CVEs in dependencies (0 critical, 2 high severity) Package registry verified. Imported from the Official MCP Registry.

5 files analyzed · 5 issues found

Security scores are indicators to help you make informed decisions, not guarantees. Always review permissions before connecting any MCP server.

Permissions Required

This plugin requests these system permissions. Most are normal for its category.

env_vars

Check that this permission is expected for this type of plugin.

file_system

Check that this permission is expected for this type of plugin.

What You'll Need

Set these up before or after installing:

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

Environment variable: REDASH_URL

Your Redash user API key (found in Settings > Account)Required

Environment variable: REDASH_API_KEY

How to Install

Add this to your MCP configuration file:

{
  "mcpServers": {
    "io-github-seob717-redash-mcp": {
      "env": {
        "REDASH_URL": "your-redash-url-here",
        "REDASH_API_KEY": "your-redash-api-key-here"
      },
      "args": [
        "-y",
        "redash-mcp"
      ],
      "command": "npx"
    }
  }
}

Documentation

View on GitHub

From the project's GitHub README.

redash-mcp

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

한국어 문서

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`	`warn`	SQL safety level: `off` / `warn` / `strict`
`REDASH_SAFETY_DISABLE_PII`	`false`	Disable PII detection
`REDASH_SAFETY_DISABLE_COST`	`false`	Disable cost warnings
`REDASH_AUTO_LIMIT`	`0`	Auto-append `LIMIT N` to queries without one (0 = disabled)
`REDASH_DEFAULT_MAX_AGE`	`0`	Redash cache TTL in seconds
`REDASH_MCP_CACHE_TTL`	`300`	MCP query cache TTL in seconds (0 = disabled)
`REDASH_MCP_CACHE_MAX_MB`	`50`	Max memory for MCP query cache in MB

Usage Examples

Just ask Claude in natural language:

"Show me the columns in the users table"
"Run a query to get order counts for the last 7 days"
"List all saved queries"
"Show widgets in the revenue dashboard"
"Create an alert when daily signups drop below 100"

Example 1: Query data with natural language

Prompt: "How many new users signed up this month?"

Tool flow:

list_data_sources → Identify the target data source
smart_query → Analyze the question, auto-select the User table, provide SQL generation guidance
run_query → Execute the generated SQL

Result:

There were 18,197 new signups this month.

Example 2: Complex business questions

Prompt: "What percentage of last week's new users made a purchase?"

Tool flow:

smart_query → Analyze the question, auto-select User and Payment tables, provide JOIN query guidance
run_query → Execute the SQL

Result:

Out of 1,204 new users last week, 312 made a purchase (25.9%).

Example 3: Create a query and dashboard

Prompt: "Create a monthly revenue trend query and add it to a dashboard"

Tool flow:

smart_query → Analyze revenue-related tables
create_query → Save the "Monthly Revenue Trend" query
create_dashboard → Create a "Revenue Dashboard"
get_query → Get the visualization ID from the saved query
add_widget → Add the chart widget to the dashboard

Result:

Created "Revenue Dashboard" with the monthly revenue trend chart.
View in Redash: https://your-redash.com/dashboard/monthly-revenue

Privacy Policy

Data Collection and Processing

redash-mcp is a local MCP server that communicates directly with your Redash instance. No intermediate servers are involved.

Item	Description
Redash API Key	Stored only as a local environment variable (`REDASH_API_KEY`). Never transmitted externally.
Query content & results	Delivered only to the local MCP client (Claude Desktop/Code) via the MCP protocol.
BIRD SQL settings	Stored only in local files (`~/.redash-mcp/`). Includes few-shot examples, keyword maps, and feedback.
LLM Fallback	When `ANTHROPIC_API_KEY` is set, only table name lists are sent to the Anthropic API. Query data and results are never transmitted.

Third-Party Sharing

We do not sell or share user data with third parties. When the LLM Fallback feature is active, only table name lists are sent to the Anthropic API, and only when the user has explicitly configured an ANTHROPIC_API_KEY.

Data Retention

Config files: Stored locally in ~/.redash-mcp/ (user can delete at any time)
Query cache: In-memory only, cleared on server shutdown
Schema cache: In-memory only, auto-expires after 10-minute TTL