seob717/redash-mcp

English | 한국어 | 日本語
> MCP server that connects Redash to Claude, Cursor, Gemini CLI, Codex, and any MCP client — query data, manage dashboards, and run SQL with natural language.
Why · Features · Install · Env · Examples · Privacy
---
Why redash-mcp?
There are several Redash MCP servers. This one is built for letting an LLM touch **production** data safely:
- **🛡️ SQL Safety Guard** — blocks DROP/TRUNCATE/ALTER and DELETE/UPDATE without WHERE; strict/warn/off modes, PII detection, and auto-LIMIT. Hand Claude your real Redash without flinching.
- **🧠 BIRD Smart Query** — analyzes the question, auto-selects the right tables, and guides SQL generation (based on the BIRD text-to-SQL methodology). Optional Claude Haiku fallback for table selection.
- **⚡ One-command setup** — npx redash-mcp setup configures Claude Desktop / Claude Code / Cursor / Gemini CLI / Codex CLI for you. No hand-editing JSON.
- **🔒 Fully local** — talks directly to your Redash instance. API key and query results never leave your machine.
- **📊 End-to-end** — query, save, fork, dashboards, widgets, and alerts — 20+ tools across 6 categories.
---
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 |
| Smart Query | smart_query | Analyze a question, auto-select tables, guide SQL generation (BIRD) |
| Smart Query | get_bird_config | Inspect the active BIRD smart-query configuration |
| Smart Query | evaluate_queries | Evaluate generated SQL against expected results |
| Smart Query | submit_query_feedback | Record feedback to improve future table selection |
| Smart Query | manage_few_shot_examples | Add/list BIRD few-shot examples |
| Smart Query | manage_keyword_map | Add/list keyword→table mappings |
| 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)
The setup wizard will guide you through configuring Claude Desktop, Claude Code (CLI), Cursor, Gemini CLI, and Codex CLI — pick any combination.
Shell Script Install
Installs Node.js, Claude Desktop, and MCP config all at once: