Tableau MCP Server

# Tableau MCP Server A Model Context Protocol (MCP) server for Tableau Cloud and Tableau Server operations. ## Project Status **Current Phase: Phase 6 Complete** ✅ - **Ready for Cloud Run Deployment** ### Completed Phases - ✅ Phase 1: Project Setup - ✅ Phase 2: Tableau API Client (13 methods) - ✅ Phase 3: MCP Server Core (SSE transport, authentication) - ✅ Phase 4: Core MCP Tools (6 tools) - ✅ Phase 5: Advanced MCP Tools (3 tools) - ✅ **Phase 6: Cloud Run Deployment Infrastructure** ✨ NEW! ### Phase 6 Deliverables - ✅ Optimized multi-stage Dockerfile - ✅ Staging and production Cloud Run configurations - ✅ Automated deployment scripts (`deploy-staging.sh`, `deploy-production.sh`) - ✅ Secrets management automation (`create-secrets.sh`) - ✅ Comprehensive deployment documentation (2,000+ lines) - ✅ Automated testing script (`smoke-test.sh`) - ✅ Monitoring and logging guides ### Next Steps 1. **Deploy to staging**: Run `./deploy-staging.sh` (requires Google Cloud project) 2. **Test deployment**: Run `./smoke-test.sh staging` 3. **Phase 7**: Create Cursor MCP configuration file 4. **Phase 8**: Comprehensive testing and documentation See `PHASE_6_LOG.md` for detailed Phase 6 implementation notes. See `PASS_OFF.md` for complete project roadmap. ## Project Structure ``` tableau-mcp-project/ ├── src/ │ ├── server.ts # Main MCP server (Phase 3) │ ├── tableau-client.ts # Tableau API client (Phase 2) │ ├── tools/ # MCP tool implementations (Phase 4-5) │ │ ├── list-workbooks.ts │ │ ├── list-views.ts │ │ ├── query-view.ts │ │ ├── refresh-extract.ts │ │ ├── search-content.ts │ │ └── get-metadata.ts │ └── types.ts # TypeScript type definitions ├── package.json ├── tsconfig.json ├── Dockerfile # Cloud Run deployment (Phase 6) └── env.example # Environment variable template ``` ## Development Scripts ```bash # Install dependencies npm install # Run in development mode with hot reload npm run dev # Build for production npm run build # Run production build npm start # Clean build artifacts npm run clean ``` ## Quick Start - Cloud Run Deployment (Phase 6) ### Prerequisites - Google Cloud Project with billing enabled - gcloud CLI installed and authenticated - Docker installed locally - Tableau Personal Access Token ### Deploy to Staging 1. **Create secrets**: ```bash chmod +x create-secrets.sh ./create-secrets.sh staging ``` 2. **Deploy service**: ```bash chmod +x deploy-staging.sh ./deploy-staging.sh ``` 3. **Test deployment**: ```bash chmod +x smoke-test.sh ./smoke-test.sh staging ``` ### Deploy to Production (When Ready) ```bash # Create production secrets ./create-secrets.sh production # Deploy to production chmod +x deploy-production.sh ./deploy-production.sh # Test production deployment ./smoke-test.sh production ``` ### Comprehensive Guides - **Deployment**: See `DEPLOYMENT_GUIDE.md` - **Secrets**: See `SECRETS_SETUP.md` - **Testing**: See `TEST_DEPLOYMENT.md` - **Monitoring**: See `MONITORING_GUIDE.md` - **Phase 6 Log**: See `PHASE_6_LOG.md` ## Environment Configuration Copy `env.example` to `.env` and configure: ```env TABLEAU_SERVER_URL=https://your-server.tableau.com TABLEAU_SITE_ID=your-site TABLEAU_TOKEN_NAME=your-token-name TABLEAU_TOKEN_VALUE=your-token-value MCP_API_KEY=secure-random-key-here PORT=8080 TABLEAU_API_VERSION=3.21 ``` ## Dependencies ### Core Dependencies - `@modelcontextprotocol/sdk` (^1.0.4) - MCP Server SDK - `express` (^4.21.2) - HTTP server for SSE transport - `axios` (^1.7.9) - HTTP client for Tableau REST API - `zod` (^3.24.1) - Schema validation - `dotenv` (^16.4.7) - Environment variable management ### Development Dependencies - `typescript` (^5.7.2) - TypeScript compiler - `tsx` (^4.19.2) - TypeScript execution and hot reload - `@types/node` & `@types/express` - Type definitions ## Phase 1 Implementation Log See `PHASE_1_LOG.md` for detailed implementation steps. ## Next Implementation Phase See `PASS_OFF.md` for Phase 2-8 implementation details. --- **License**: MIT **Author**: Agile Market Intelligence