ThoughtSpot MCP Server

The ThoughtSpot MCP Server is a Cloudflare Worker-based service that exposes Model Context Protocol (MCP) endpoints for interacting with ThoughtSpot data and tools. It provides secure OAuth-based authentication and a set of tools for querying and retrieving relevant data from a ThoughtSpot instance.

Table of Contents

• Features
• Project Structure
• Scripts
• Usage
• Endpoints
• Configuration
• License

Features

• OAuth Authentication: Secure endpoints using OAuth flows, as user's own scope.
• Tools:
  • ping: Test connectivity and authentication.
  • getRelevantQuestions: Get relevant data questions from ThoughtSpot database based on a user query.
  • getAnswer: Get the answer to a specific question from ThoughtSpot database.
  • createLiveboard: Create a liveboard from a list of answers.
• MCP Resources:
  • datasources: List of TS Data models the user has access to.

MCP Client Configuration

To configure this MCP server in your MCP client (such as Claude Desktop, Windsurf, Cursor, etc.), add the following configuration to your MCP client settings:

{
  "mcpServers": {
    "ThoughtSpot": {
      "command": "npx",
      "args": [
         "mcp-remote",
         "https://thoughtspot-mcp-server.thoughtspot-485.workers.dev/sse"
      ]
    }
  }
}

Supported transports

• SSE /sse
• Streamed HTTP /mcp

Contributing

Local Development

1. Install dependencies:

   npm install

2. Set up environment variables:
   • Copy .dev.vars and fill in your ThoughtSpot instance URL and access token.
3. Start the development server:

   npm run dev

Endpoints

• /mcp: MCP HTTP Streaming endpoint
• /sse: Server-sent events for MCP
• /api: MCP tools exposed as HTTP endpoints
• /authorize, /token, /register: OAuth endpoints

Configuration

• wrangler.jsonc: Configure bindings, secrets, and compatibility.

MCP Server, © ThoughtSpot, Inc. 2025