MCP server integration
ThoughtSpot’s Agentic Model Context Protocol (MCP) Server allows you to integrate ThoughtSpot analytics directly into any AI agent, custom chatbot, or LLM-based platforms that support MCP. It acts as a connector between the ThoughtSpot instance and external AI client, and provides a set of tools for interacting with ThoughtSpot’s data and its analytics capabilities programmatically.
The ThoughtSpot MCP Server is an add-on feature available with the ThoughtSpot Analytics and ThoughtSpot Embedded offerings.
To purchase the MCP Server subscription and enable the MCP Server in your environment, you must have an active subscription to one of the following ThoughtSpot license plans:
-
Enterprise Edition of ThoughtSpot Analytics
-
ThoughtSpot Embedded subscription
To learn more about the MCP Server subscription options and to get started, please contact your ThoughtSpot Sales representative.
Integration overview🔗
The Agentic MCP Server integration requires the following core components and authentication framework:
- MCP Server
-
The MCP Server exposes a set of tools that can be invoked by an LLM or external AI. ThoughtSpot’s MCP Server acts as a bridge between the LLM/agent and ThoughtSpot application backend.
- MCP tools and resources
-
MCP tools are the actions that the MCP Server exposes to the agent for interaction with ThoughtSpot.
-
Ask natural language questions and get data in a structured format from ThoughtSpot
-
Retrieve relevant analytical questions based on user queries
-
Create a Liveboard with the answers generated from the queries
Currently, the MCP Server supports the following tools:
-
pingto test connection to ThoughtSpot -
getRelevantQuestionsto get relevant analytical questions
ThegetRelevantQuestionstool to fetch relevant data questions for a given data context by breaking down a user’s query. -
getAnswerto execute the queries and fetch data
ThegetAnswertool generates answers and insights for a given data context. -
createLiveboardto create a Liveboard in ThoughtSpot
-
The createLiveboard tool calls the Liveboard creation workflow and creates a Liveboard with the answers generated from the user’s query.
- MCP client/ LLM agent
-
The external system or application environment with AI Agent, Claude, OpenAI, or a custom chatbot that acts as a user interface and orchestrates interaction with the ThoughtSpot MCP Server. This is the model or system that processes the user’s natural language input, determines which tool to call, and integrates the tool results into its final output.
- Authentication and security settings
-
-
Access to ThoughtSpot instance
For MCP Server connection, users require access to a ThoughtSpot instance. For tool invocation, the MCP server must accept authenticated requests, and the LLM tool specification must carry those credentials or headers.
ThoughtSpot administrators can use the SSO framework with SAML or OAuth token-based authentication methods to authenticate and sign in users. -
SAML redirect settings:
For SAML SSO users, the SAML redirect domain configuration is required to ensure that users are redirected to an allowed and trusted domain after they are authenticated. -
To get answers to their data queries, your application users require at least view access to ThoughtSpot data sources. To generate an Answer or to create a Liveboard, users require the data download privilege.
-
CSP and CORS settings:
To secure communication between the MCP client and the ThoughtSpot instance, administrators must add the MCP Server URL to CSP (Content Security Policy) and CORS (Cross-Origin Resource Sharing) allowlists in ThoughtSpot. -
Client connection configuration:
MCP Server integration also requires configuration on the client side, typically via a config file, to include the MCP Server addresses, credentials, and other details.
-