redash-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| REDASH_URL | Yes | Redash instance URL (e.g. https://redash.example.com) | |
| REDASH_API_KEY | Yes | Redash user API key | |
| ANTHROPIC_API_KEY | No | If set, BIRD smart_query falls back to Claude Haiku for table selection when keyword scoring fails | |
| REDASH_AUTO_LIMIT | No | Auto-append LIMIT N to queries without one (0 = disabled) | 0 |
| REDASH_SAFETY_MODE | No | SQL safety level: off / warn / strict | warn |
| REDASH_BIRD_ENABLED | No | Set to false to disable BIRD smart query tools | true |
| REDASH_MCP_CACHE_TTL | No | MCP query cache TTL in seconds (0 = disabled) | 300 |
| REDASH_MCP_CONFIG_DIR | No | Directory for BIRD few-shot, feedback, eval, keyword-map data | ~/.redash-mcp |
| REDASH_DEFAULT_MAX_AGE | No | Redash cache TTL in seconds | 0 |
| REDASH_MCP_CACHE_MAX_MB | No | Max memory for MCP query cache in MB | 50 |
| REDASH_HTTP_TIMEOUT_SECS | No | Per-request HTTP timeout against the Redash API | 30 |
| REDASH_SAFETY_DISABLE_PII | No | Disable PII detection | false |
| REDASH_SAFETY_DISABLE_COST | No | Disable cost warnings | false |
Capabilities
Features and capabilities supported by this server
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| list_data_sourcesA | List connected data sources (id, name, type). Call this first to get data_source_id. |
| list_tablesA | List tables in a data source. Use keyword to filter by name. Verify table names here before writing SQL. |
| get_table_columnsA | Get column names and types for one or more tables (comma-separated). Verify columns before writing SQL. |
| run_queryA | Execute SQL against a data source and return results. Check schema with list_tables and get_table_columns first. |
| list_queriesB | List saved queries in Redash. |
| get_query_resultA | Execute a saved query by ID and return results. |
| get_queryA | Get saved query details (SQL, visualizations, tags). |
| create_queryC | Save a new query to Redash. |
| update_queryA | Update a saved query's name, SQL, description, or tags. |
| fork_queryA | Fork (duplicate) an existing query. |
| archive_queryA | Archive (delete) a query. This action is irreversible. |
| list_dashboardsC | List dashboards in Redash. |
| get_dashboardA | Get dashboard details including widgets and visualizations. |
| create_dashboardA | Create a new dashboard. |
| add_widgetA | Add a visualization widget to a dashboard. Get visualization_id from get_query. |
| list_alertsB | List alerts in Redash. |
| get_alertA | Get alert details (threshold, linked query, state). |
| create_alertA | Create a new alert. Triggers when a query result column crosses a threshold. |
| smart_queryA | BIRD SQL-based intelligent query tool. Analyzes natural-language questions to (1) extract relevant schema, (2) match similar few-shot examples, (3) assess complexity, (4) request clarification for ambiguous questions. Call this tool before run_query. For a new data source, first inspect the schema with list_tables, then register keyword-to-table mappings via manage_keyword_map to significantly improve accuracy. Note: when ANTHROPIC_API_KEY is set, table-name lists (never query results or row data) may be sent to the Anthropic API as a fallback for table selection. |
| manage_few_shot_examplesB | Manage few-shot examples (list/add/remove). Register domain-specific examples to improve SQL accuracy. |
| submit_query_feedbackA | Submit feedback on generated SQL. Incorrect SQL is automatically classified and may be promoted to a few-shot example. |
| evaluate_queriesB | Manage SQL accuracy evaluation. Add/list test cases, run evaluations, and view results. |
| manage_keyword_mapA | Manage keyword-to-table-name mappings. After inspecting the schema with list_tables, register domain-specific mappings to improve smart_query table-matching accuracy. e.g., {"revenue": ["payment"], "creator": ["creator"]} |
| get_bird_configA | View BIRD SQL configuration and status. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
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/seob717/redash-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server