Mcp Redash
What is Mcp Redash
mcp-redash is an MCP server designed for the Redash API, enabling users to execute queries and retrieve results efficiently.
Use cases
Use cases for mcp-redash include automating query executions, integrating Redash with other applications, and simplifying data retrieval processes for analytics.
How to use
To use mcp-redash, you need to set up your environment with the Redash API key and base URL. You can either clone the repository and build it using npm or run it via Docker. After setup, you can execute queries, list data sources, and get details about specific data sources using the provided functions.
Key features
Key features of mcp-redash include the ability to execute queries and wait for results, list all available data sources, and retrieve detailed information about specific data sources.
Where to use
mcp-redash can be used in data analysis, business intelligence, and reporting environments where Redash is utilized to visualize and analyze data.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Mcp Redash
mcp-redash is an MCP server designed for the Redash API, enabling users to execute queries and retrieve results efficiently.
Use cases
Use cases for mcp-redash include automating query executions, integrating Redash with other applications, and simplifying data retrieval processes for analytics.
How to use
To use mcp-redash, you need to set up your environment with the Redash API key and base URL. You can either clone the repository and build it using npm or run it via Docker. After setup, you can execute queries, list data sources, and get details about specific data sources using the provided functions.
Key features
Key features of mcp-redash include the ability to execute queries and wait for results, list all available data sources, and retrieve detailed information about specific data sources.
Where to use
mcp-redash can be used in data analysis, business intelligence, and reporting environments where Redash is utilized to visualize and analyze data.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
Redash MCPサーバー
Redash APIのMCPサーバーで、クエリの実行、結果の取得などの機能を提供します。
ツール
-
execute_query_and_wait- クエリを実行し、結果が利用可能になるまで待機します
- 入力パラメータ:
data_source_id(数値): クエリを実行するデータソースのIDquery(文字列): 実行するSQLクエリ
- 戻り値: 利用可能になったクエリ結果
-
list_data_sources- 利用可能なすべてのデータソースを一覧表示します
- 入力パラメータ: なし
- 戻り値: データソースの配列
-
get_data_source- 特定のデータソースに関する詳細を取得します
- 入力パラメータ:
data_source_id(数値): データソースのID
- 戻り値: データソースの詳細情報
セットアップ
APIキー
Redash APIキーを取得してください。
- Redashにログイン
- 「Edit Profile」をクリック
- APIキーをコピーする
環境変数
以下の環境変数が必要です:
REDASH_API_KEY: RedashのAPIキーREDASH_BASE_URL: RedashのURL（例: https://redash.example.com）
git clone
このリポジトリをローカルにcloneしてください
npxで利用する場合
ビルドとnpxコマンドの登録を行ってください
npm install
npm run build
npm link
Claude DesktopまたはCursorのMCP設定に以下を追加してください
{
"mcpServers": {
"redash": {
"command": "npx",
"args": [
"mcp-redash"
],
"env": {
"REDASH_API_KEY": "<YOUR_API_KEY>",
"REDASH_BASE_URL": "https://redash.example.com"
}
}
}
}Dockerで利用する場合
ビルドを行ってください
docker build -t yuki9541134/mcp-redash .
Claude DesktopまたはCursorのMCP設定に以下を追加してください
{
"mcpServers": {
"redash": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"REDASH_API_KEY",
"-e",
"REDASH_BASE_URL",
"yuki9541134/mcp-redash"
],
"env": {
"REDASH_API_KEY": "<YOUR_API_KEY>",
"REDASH_BASE_URL": "https://redash.example.com"
}
}
}
}SSEモードで利用する場合
HTTPサーバーとして起動し、Server-Sent Events (SSE) を使用した通信を行うことも可能です。
開発時
npm run dev -- --sse
ビルド後
node dist/index.js --sse
SSEモードではHTTPサーバーがポート3000で起動します。エンドポイント：
GET /sse- SSE接続の確立POST /messages- メッセージの送信
Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
