Tableau MCP Server

A Model Context Protocol (MCP) server for Tableau Cloud that provides dashboard access, data querying, and export capabilities through Cursor IDE.

Features

• 🔍 Discovery & Search - Find workbooks, views, and data sources

• 📊 Data Access - Query view data with filters as CSV or JSON

• 📤 Export - Export dashboards as PDF, PNG, or PowerPoint

• 🔄 Data Refresh - Trigger extract refreshes for data sources

Prerequisites

• Node.js 18.x or later

• Google Cloud Platform account with:

  • Cloud Run enabled

  • Secret Manager enabled

  • Cloud Storage bucket for exports

• Tableau Cloud/Server with:

  • Personal Access Token (PAT) credentials

  • API access enabled

Quick Start

1. Clone and Install

cd tableau-mcp
npm install

2. Configure Environment Variables

Create a .env file (or set environment variables):

# Tableau Configuration
TABLEAU_SERVER_URL=https://prod-apnortheast-a.online.tableau.com
TABLEAU_SITE_ID=your-site-content-url
TABLEAU_PAT_NAME=your-pat-name
TABLEAU_PAT_SECRET=your-pat-secret

# MCP Server
MCP_API_KEY=your-secure-api-key

# Google Cloud
GCS_EXPORT_BUCKET=tableau-mcp-exports
GCP_PROJECT_ID=your-project-id

3. Run Locally

npm start

The server starts on http://localhost:8080:

• Health check: GET /health

• SSE endpoint: GET /sse and POST /sse

4. Configure Cursor

Add to your .cursor/mcp.json:

{
  "mcpServers": {
    "tableau": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-remote",
        "https://tableau-mcp-400124661305.australia-southeast1.run.app/sse",
        "--header",
        "X-API-Key: <your-api-key>"
      ]
    }
  }
}

Note: Replace <your-api-key> with your actual API key from Secret Manager (tableau-mcp-api-key).

Available Tools

Utility Tools

Dashboard Tools

Data Tools

Export Tools

Usage Examples

Find and Export a Dashboard

1. Search for dashboards:
   tableau_search({ query: "sales" })

2. List views in a workbook:
   tableau_list_views({ workbookId: "abc123" })

3. Export as PDF:
   tableau_export_pdf({ viewId: "xyz789" })

Query Filtered Data

1. Get available filters:
   tableau_get_filters({ viewId: "xyz789" })

2. Query with filters:
   tableau_query_view({
     viewId: "xyz789",
     format: "json",
     filters: { "Region": "West" }
   })

Deployment

Cloud Run Deployment

1. Create GCS Bucket

   gsutil mb -l australia-southeast1 gs://tableau-mcp-exports

2. Create Secrets in Secret Manager

   echo -n "your-pat-name" | gcloud secrets create tableau-pat-name --data-file=-
   echo -n "your-pat-secret" | gcloud secrets create tableau-pat-secret --data-file=-
   echo -n "your-api-key" | gcloud secrets create tableau-mcp-api-key --data-file=-

3. Grant Service Account Permissions

   # Secret Manager access
   gcloud secrets add-iam-policy-binding tableau-pat-secret \
     --member="serviceAccount:YOUR_SA@PROJECT.iam.gserviceaccount.com" \
     --role="roles/secretmanager.secretAccessor"
   
   # GCS access
   gsutil iam ch serviceAccount:YOUR_SA@PROJECT.iam.gserviceaccount.com:objectCreator,objectViewer \
     gs://tableau-mcp-exports

4. Configure Cloud Build Trigger

   • Source: Your GitHub repository

   • Event: Push to main branch

   • Configuration: cloudbuild.yaml

   • Substitution variables:

     • _TABLEAU_SERVER_URL: Your Tableau Cloud URL

     • _TABLEAU_SITE_ID: Your site content URL

     • _GCS_EXPORT_BUCKET: Your export bucket name

5. Deploy Push to main branch to trigger automatic deployment.

Manual Deployment

gcloud run deploy tableau-mcp \
  --source . \
  --region australia-southeast1 \
  --memory 1Gi \
  --timeout 300s \
  --min-instances 1 \
  --allow-unauthenticated

Configuration Reference

Environment Variables

Cloud Run Settings

Limitations

• Filters: Cannot apply filters to live dashboard views - only at query/export time

• PPTX Export: Generated from PNG images, not native Tableau export

• Data Query: Maximum 100,000 rows per request

• Export URLs: Valid for 1 hour only

• Rate Limits: Throttled to 10 requests/second to Tableau API

Project Structure

tableau-mcp/
├── mcp-http-server.js      # Main Express HTTP server
├── mcp-handler.js          # MCP protocol handler
├── mcp_tools.json          # Tool definitions
├── config.js               # Configuration management
├── package.json            # Dependencies
├── Dockerfile              # Container configuration
├── cloudbuild.yaml         # CI/CD configuration
├── lib/
│   ├── tableau-client.js   # Tableau REST API client
│   ├── gcs-client.js       # GCS upload/signing
│   └── logger.js           # Structured logging
├── 00-utility-tools/tools/
│   ├── get-instructions.js
│   └── search.js
├── 01-dashboard-tools/tools/
│   ├── list-workbooks.js
│   ├── get-workbook.js
│   ├── list-views.js
│   ├── get-filters.js
│   └── apply-filter.js
├── 02-data-tools/tools/
│   ├── query-view-data.js
│   ├── list-datasources.js
│   └── refresh-datasource.js
└── 03-export-tools/tools/
    ├── export-pdf.js
    ├── export-image.js
    └── export-pptx.js

Troubleshooting

Authentication Errors

• Verify PAT credentials are correct

• Check that PAT has not expired

• Ensure site ID matches the site content URL (not the site name)

Export Failures

• Check GCS bucket exists and is accessible

• Verify service account has objectCreator and objectViewer roles

• Large exports may timeout - try smaller views or increase Cloud Run timeout

Rate Limiting

• The server throttles to 10 requests/second

• Batch operations may be slower due to throttling

• Consider increasing throttle limit for Tableau Server (not Cloud)

License

MIT

Author

Agile Market Intelligence