README - ThoughtSpot MCP Server by 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.

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://agent.thoughtspot.app/sse"
      ]
    }
  }
}

Supported transports

SSE
Streamed HTTP

Contributing

Local Development

Install dependencies:
```
npm install
```
Set up environment variables:
- Copy .dev.vars and fill in your ThoughtSpot instance URL and access token.
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:

{
  "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.