GitHub - thoughtspot/mcp-server: The ThoughtSpot MCP Server (original) (raw)

ThoughtSpot

The ThoughtSpot MCP Server provides secure OAuth-based authentication and a set of tools for querying and retrieving relevant data from your ThoughtSpot instance. It's a remote server hosted on Cloudflare.

If you do not have a Thoughtspot account, create one for free here.

Learn more about ThoughtSpot.

Join our Discord to get support.

Table of Contents

Connect

If using a client which supports remote MCPs natively (Claude.ai etc) then just enter:

MCP Server URL:

https://agent.thoughtspot.app/mcp

Preferred Auth method: Oauth

https://agent.thoughtspot.app/openai/mcp

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

{ "mcpServers": { "ThoughtSpot": { "command": "npx", "args": [ "mcp-remote", "https://agent.thoughtspot.app/mcp" ] } } }

See the Troubleshooting section for any errors / more details.

Usage

  1. Once the connection is done, ThoughtSpot datasources would show under the resources section.
  2. Select a datasource (resource), to set the context of your query.
  3. Now you could ask analytical questions, which claude can decide to use the relevant ThoughtSpot tools for.

See the video below for a complete demo.

Demo

Here is a demo video using Claude Desktop.

ThoughtSpot-MCP-server-demo.mp4

Watch on Loom

Usage in APIs

ThoughtSpot's remote MCP server can be used in LLM APIs which support calling MCP tools.

Here are examples with the common LLM providers:

OpenAI Responses API

curl https://api.openai.com/v1/responses
-H "Content-Type: application/json"
-H "Authorization: Bearer $OPENAI_API_KEY"
-d '{ "model": "gpt-4.1", "tools": [ { "type": "mcp", "server_label": "thoughtspot", "server_url": "https://agent.thoughtspot.app/bearer/mcp", "headers": { "Authorization": "Bearer $TS_AUTH_TOKEN", "x-ts-host": "my-thoughtspot-instance.thoughtspot.cloud" } } ], "input": "How can I increase my sales ?" }'

More details on how can you use OpenAI API with MCP tool calling can be found here.

Claude MCP Connector

curl https://api.anthropic.com/v1/messages
-H "Content-Type: application/json"
-H "X-API-Key: $ANTHROPIC_API_KEY"
-H "anthropic-version: 2023-06-01"
-H "anthropic-beta: mcp-client-2025-04-04"
-d '{ "model": "claude-sonnet-4-20250514", "max_tokens": 1000, "messages": [{ "role": "user", "content": "How do I increase my sales ?" }], "mcp_servers": [ { "type": "url", "url": "https://agent.thoughtspot.app/bearer/mcp", "name": "thoughtspot", "authorization_token": "$TS_AUTH_TOKEN@my-thoughtspot-instance.thoughtspot.cloud" } ] }'

Note: In the authorization_token field we have suffixed the ThoughtSpot instance host as well with the @ symbol to the TS_AUTH_TOKEN.

More details on Claude MCP connector here.

Gemini API

MCP tools can be used with the Gemini Python/Typescript SDK. Here is an example using typescript:

import { GoogleGenAI, FunctionCallingConfigMode , mcpToTool} from '@google/genai'; import { Client } from "@modelcontextprotocol/sdk/client/index.js"; import { StreamableHTTPClientTransport } from "@modelcontextprotocol/sdk/client/streamableHttp.js";

// Create server parameters for stdio connection const serverParams = new StreamableHTTPClientTransport(new URL("https://agent.thoughtspot.app/bearer/mcp"), { requestInit: { headers: { "Authorization": "Bearer TSAUTHTOKEN",//ReadbelowhowtogettheTS_AUTH_TOKEN", // Read below how to get the TSA​UTHT​OKEN",//ReadbelowhowtogettheTS_AUTH_TOKEN "x-ts-host": "my-thoughtspot-instance.thoughtspot.cloud" }, } });

const client = new Client( { name: "example-client", version: "1.0.0" } );

// Configure the client const ai = new GoogleGenAI({});

// Initialize the connection between client and server await client.connect(serverParams);

// Send request to the model with MCP tools const response = await ai.models.generateContent({ model: "gemini-2.5-flash", contents: What is the weather in London in ${new Date().toLocaleDateString()}?, config: { tools: [mcpToTool(client)], // uses the session, will automatically call the tool // Uncomment if you don't want the sdk to automatically call the tool // automaticFunctionCalling: { // disable: true, // }, }, }); console.log(response.text)

// Close the connection await client.close();

Read this, for more details on Gemini API MCP tool calling.

An example using Google ADK + Python can be found here.

Gemini CLI extenstions

ThoughtSpot MCP server can also be installed as a Gemini CLI extension.

gemini extensions install https://github.com/thoughtspot/mcp-server

Read more about Gemini CLI here.

How to get TS_AUTH_TOKEN for APIs ?

For API usage, you would the token endpoints with a secret_key to generate the API_TOKEN for a specific user/role, more details here.

Features

Supported transports

Manual client registration

For MCP hosts which do not(yet) support Dynamic client registration, or they require statically adding Oauth Client Id etc. Go to this page, to register a new client and copy the details over. The most relevant values are Oauth Client Id and Oauth Client Secret which should be added when adding ThoughtSpot as an MCP connector in the MCP client (ChatGPT/Claude etc). The generated client details are only available when they are generated and are NOT available later for reference.

Associate with a ThoughtSpot instance

Manual client registration also allows to associate with a specific ThoughtSpot instance, so that your users do not have to enter the Thoughtspot instance URL when doing the authorization flow. While registering the Oauth client add ThoughtSpot URL to the appropriate value.

Self hosted

Use the published docker image to deploy the MCP server in your own environment.

See this for details.

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:

{ "mcpServers": { "ThoughtSpot": { "command": "npx", "args": [ "@thoughtspot/mcp-server" ], "env": { "TS_INSTANCE": "", "TS_AUTH_TOKEN": "" } } } }

How to obtain a TS_AUTH_TOKEN ?

Alternative way to get TS_AUTH_TOKEN

Troubleshooting

Oauth errors due to CORS/SAML.

Make sure to add the following entries in your ThoughtSpot instance:

CORS

SAML (need to be Admin)

MCP server install error due to node issues

500 error from MCP server

Stale MCP auth

Contributing

Local Development

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

Endpoints

MCP Server, © ThoughtSpot, Inc. 2025