Skip to main content
Glama

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
REDASH_URLYesRedash instance URL (e.g. https://redash.example.com)
REDASH_API_KEYYesRedash user API key
ANTHROPIC_API_KEYNoIf set, BIRD smart_query falls back to Claude Haiku for table selection when keyword scoring fails
REDASH_AUTO_LIMITNoAuto-append LIMIT N to queries without one (0 = disabled)0
REDASH_SAFETY_MODENoSQL safety level: off / warn / strictwarn
REDASH_BIRD_ENABLEDNoSet to false to disable BIRD smart query toolstrue
REDASH_MCP_CACHE_TTLNoMCP query cache TTL in seconds (0 = disabled)300
REDASH_MCP_CONFIG_DIRNoDirectory for BIRD few-shot, feedback, eval, keyword-map data~/.redash-mcp
REDASH_DEFAULT_MAX_AGENoRedash cache TTL in seconds0
REDASH_MCP_CACHE_MAX_MBNoMax memory for MCP query cache in MB50
REDASH_HTTP_TIMEOUT_SECSNoPer-request HTTP timeout against the Redash API30
REDASH_SAFETY_DISABLE_PIINoDisable PII detectionfalse
REDASH_SAFETY_DISABLE_COSTNoDisable cost warningsfalse

Capabilities

Features and capabilities supported by this server

CapabilityDetails
tools
{
  "listChanged": true
}

Tools

Functions exposed to the LLM to take actions

NameDescription
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

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

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