ThoughtSpot MCP Server
by
Provides secure OAuth authentication and a suite of tools for querying and retrieving relevant analytics data from a ThoughtSpot instance via a remote MCP endpoint.
ThoughtSpot MCP Server Overview
What is ThoughtSpot MCP Server about?
The server acts as a remote bridge that authenticates users with OAuth and exposes ThoughtSpot analytics capabilities (ping, relevant‑question discovery, answer retrieval, liveboard creation, datasource suggestions) through MCP endpoints.
How to use ThoughtSpot MCP Server?
- Connect – For clients that support remote MCPs, simply set the MCP URL to
https://agent.thoughtspot.app/mcp(or the OpenAI‑specific URLhttps://agent.thoughtspot.app/openai/mcp). - Configure a client without native remote support – Add the following JSON to the client’s MCP settings:
{
"mcpServers": {
"ThoughtSpot": {
"command": "npx",
"args": [
"mcp-remote",
"https://agent.thoughtspot.app/mcp"
]
}
}
}
- Select a datasource in the client UI to set query context.
- Ask analytical questions; the LLM will invoke the appropriate ThoughtSpot tool via MCP.
- For API usage, include the MCP definition in OpenAI or Claude request payloads and pass a
TS_AUTH_TOKEN(obtained from ThoughtSpot’s REST Playground or session token endpoint) in theAuthorizationheader.
Key features of ThoughtSpot MCP Server
- OAuth‑based authentication with dynamic client registration support.
- Multiple transports: Server‑Sent Events (
/sse) and streamed HTTP (/mcp). - Built‑in tools:
pinggetRelevantQuestionsgetAnswercreateLiveboardgetDataSourceSuggestions
- Exposes ThoughtSpot datasources as MCP resources.
- Self‑hosting via Docker image.
- Fallback
stdiotransport using the npm package for environments where remote access is blocked.
Use cases of ThoughtSpot MCP Server
- LLM‑enhanced analytics: Enable ChatGPT, Claude, or other LLMs to fetch real‑time business insights from ThoughtSpot.
- Custom AI assistants: Build domain‑specific bots that query ThoughtSpot data without writing bespoke SDK code.
- Automation pipelines: Trigger liveboard creation or answer retrieval from CI/CD or workflow tools.
- Remote analytics access: Provide secure, token‑based access to ThoughtSpot data for distributed teams via Cloudflare Workers.
FAQ from the ThoughtSpot MCP Server
Q: How do I obtain a TS_AUTH_TOKEN?
A: Use the ThoughtSpot REST Playground (Develop → Rest Playground v2.0) to request a full‑access token, or call https://<your‑instance>/api/rest/2.0/auth/session/token after logging in.
Q: What CORS or SAML settings are required?
A: Add agent.thoughtspot.app to both the CORS whitelist and the SAML redirect domains in ThoughtSpot’s security settings.
Q: Which Node version is required? A: Node >= 18.
Q: How can I run the server locally? A: Use the npm package with stdio fallback:
{
"mcpServers": {
"ThoughtSpot": {
"command": "npx",
"args": ["@thoughtspot/mcp-server"],
"env": {
"TS_INSTANCE": "<YOUR_THOUGHTSPOT_INSTANCE_URL>",
"TS_AUTH_TOKEN": "<YOUR_ACCESS_TOKEN>"
}
}
}
}
Q: Where are the HTTP endpoints?
A: /mcp, /sse, /api (tool APIs), OAuth flows (/authorize, /token, /register), and bearer‑auth shortcuts (/bearer/mcp, /bearer/sse).
ThoughtSpot MCP Server's README
ThoughtSpot MCP Server 
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
- Usage
- Demo video
- Usage in APIs
- Features
- Stdio support (fallback)
- Troubleshooting
- Contributing
Connect
If using a client which supports remote MCPs natively (Claude.ai etc) then just enter:
MCP Server URL:
https://agent.thoughtspot.app/mcp
- For OpenAI ChatGPT Deep Research, add the URL as:
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
- Once the connection is done, ThoughtSpot datasources would show under the resources section.
- Select a datasource (resource), to set the context of your query.
- 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.
https://github.com/user-attachments/assets/72a5383a-7b2a-4987-857a-b6218d7eea22
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.
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
- OAuth Authentication: Access your data, as yourself.
- Dynamic Client Registration (DCR) support.
- Any MCP host is allowed. Let's make the world fact driven.
- Tools:
ping: Test connectivity and authentication.getRelevantQuestions: Get relevant data questions from ThoughtSpot analytics based on a user query.getAnswer: Get the answer to a specific question from ThoughtSpot analytics.createLiveboard: Create a liveboard from a list of answers.getDataSourceSuggestions: Get datasource suggestions for a given query.
- MCP Resources:
datasources: List of ThoughtSpot Data models the user has access to.
Supported transports
- SSE https://agent.thoughtspot.app/sse
- Streamed HTTP https://agent.thoughtspot.app/mcp
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": "<your Thoughtspot Instance URL>",
"TS_AUTH_TOKEN": "<ThoughtSpot Access Token>"
}
}
}
}
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.
Alternative way to get TS_AUTH_TOKEN
- Login to the ThoughtSpot instance as you would normally.
- Opem in a new tab this URL:
- You will see a JSON response, copy the "token" value (without the quotes).
- This is the token you could use.
Troubleshooting
Oauth errors due to CORS/SAML.
Make sure to add the following entries in your ThoughtSpot instance:
CORS
- Go to ThoughtSpot => Develop => Security settings
- Click "Edit"
- Add "agent.thoughtspot.app" to the the "CORS whitelisted domains".
SAML (need to be Admin)
- Go to ThoughtSpot => Develop
- Go to "All Orgs" Tab on the left panel if there is one.
- Click "Security settings"
- Click "Edit"
- Add "agent.thoughtspot.app" to the the "SAML redirect domains".
MCP server install error due to node issues
- Make sure node is installed on your machine.
- Make sure the node version is >=18
- Check the node version by using the command
node -v
500 error from MCP server
- Make sure the ThoughtSpot cluster the MCP server is connected to is up and running.
- If the error persists, please collect the logs that you get from the MCP client and the approximate time when the issue occurred.
- Reach out on Discord to get support.
- Create a issue on this repository to get help.
- Submit a ThoughtSpot support case with all the artifacts.
Stale MCP auth
- If for some reason the ThoughtSpot MCP server is failing authentication repeatedly, you can do
rm -rf ~/.mcp-auth. - This will remove all stale authentication info, and restart the auth flow again.
Contributing
Local Development
- Install dependencies:
npm install - Set up environment variables:
- Copy
.dev.varsand fill in your ThoughtSpot instance URL and access token.
- Copy
- 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/bearer/mcp,/bearer/sse: MCP endpoints as bearer auth instead of Oauth, mainly for use in APIs or in cases where Oauth is not working.
MCP Server, © ThoughtSpot, Inc. 2025
ThoughtSpot MCP Server Reviews
Login Required
Please log in to share your review and rating for this MCP.
Actions
ThoughtSpot MCP Server's Information
- Author
- thoughtspot
- Category
- Data & Analytics
- Language
- TypeScript
- License
- Other
- Version
- v0.5.0
- Stars
- 16
- Updated
- 19 days ago
Configuration
{
"mcpServers": {
"thoughtspot": {
"command": "npx",
"args": [
"@thoughtspot/mcp-server"
],
"env": {
"TS_INSTANCE": "<YOUR_THOUGHTSPOT_INSTANCE_URL>",
"TS_AUTH_TOKEN": "<YOUR_ACCESS_TOKEN>"
}
}
}
}Configure Clients
Related MCP Servers
Discover more MCP servers with similar functionality and use cases
Vizro
by mckinsey
Build high-quality data visualization apps quickly with low‑code configuration, leveraging Plotly, Dash, and Pydantic while allowing deep customisation through Python, JavaScript, HTML, and CSS.
AntV Chart
by antvis
mcp-server-chart is a Model Context Protocol (MCP) server developed by AntV that generates over 25 types of visual charts. It provides robust chart generation and data analysis capabilities, integrating with various AI clients and platforms.
Data Exploration
by reading-plus-ai
mcp-server-data-exploration is an MCP server designed for autonomous data exploration on CSV-based datasets. It acts as a personal Data Scientist assistant, providing intelligent insights with minimal effort.
Wren Engine
by Canner
Wren Engine is a semantic engine designed for Model Context Protocol (MCP) clients and AI agents, enabling accurate and context-aware access to enterprise data.
QuickChart
by GongRzhe
A Model Context Protocol (MCP) server for generating various types of charts using QuickChart.io, enabling chart creation through MCP tools.
BigQuery
by ergut
mcp-bigquery-server is a Model Context Protocol (MCP) server that enables Large Language Models (LLMs) to securely and efficiently interact with Google BigQuery datasets. It acts as a translator, allowing LLMs to query and analyze data in BigQuery using natural language instead of SQL.
Mcp Vegalite Server
by isaacwasserman
Provides tools for saving data tables and generating Vega‑Lite visualizations via an MCP interface, supporting both textual specifications and PNG image output.
Google Analytics
by surendranb
Google Analytics MCP Server is a Python-based tool that enables Large Language Models (LLMs) to access and analyze Google Analytics 4 (GA4) data using natural language, providing conversational querying of over 200 GA4 dimensions and metrics.
Mcp Tinybird
by tinybirdco
Provides a Model Context Protocol server implementation for Tinybird, allowing analytics agents to forward data to Tinybird's platform.