Thoughtspot

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:

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.

Stdio support (fallback)

If you are unable to use the remote MCP server due to connectivity restrictions on your Thoughtspot instance. You could use the stdio local transport using the npm package.

Here is how to configure stdio with MCP Client:

How to obtain a TS_AUTH_TOKEN ?

• Go to ThoughtSpot => Develop => Rest Playground v2.0
• Authentication => Get Full access token
• Scroll down and expand the "body"
• Add your "username" and "password".
• Put whatever "validity_time" you want the token to be.
• Click on "Try it out" on the bottom right.
• You should get a token in the response, thats the bearer token.

MCP Server, © ThoughtSpot, Inc. 2025