# ThoughtSpot MCP connector

Connect ThoughtSpot to Elaichi and Claude, ChatGPT, Cursor, Microsoft Copilot, or any MCP client can ask ThoughtSpot questions, manage users, roles, groups, and orgs, and find collections, with every call logged under the person's own access.

Source: https://elaichi.ai/connectors/thoughtspot/

## Facts

| | |
| --- | --- |
| Application | ThoughtSpot |
| Category | Analytics |
| AI tools | 220 |
| Authentication | Connects with an API key |
| Bring your own OAuth app | No |
| MCP endpoint | https://api.elaichi.ai/mcp |
| Works with | Claude, ChatGPT, Cursor, Microsoft Copilot, any MCP client, and the Elaichi Agent |
| Tools advertised by name | No. Connected tools are never listed one by one, however few there are. The endpoint advertises `search_tools` and `execute_tool` instead |

## What you can ask once ThoughtSpot is connected

- Ask ThoughtSpot which region had the highest revenue last quarter
- Create a user for Priya Shah and add her to Finance
- List every ThoughtSpot user with an admin role

## Connect ThoughtSpot in Elaichi

This happens once for the organization, before any client is involved.

1. Open Connections, choose Add connection, and pick ThoughtSpot.
2. Optionally set Share with, then press Connect.
3. Paste a ThoughtSpot API key. One person generates a token in ThoughtSpot and pastes it once. Everyone else works through Share with, and never sees it.

Credentials are vaulted and nobody, including the AI, reads them back. The connection becomes a toolbox immediately, so you can curate which ThoughtSpot tools are exposed, rename them, or freeze arguments before anyone points a client at it.

## ThoughtSpot MCP connector for Claude

Endpoint: https://api.elaichi.ai/mcp

1. Open Customize, then Connectors.
2. Press Add.
3. Name it, paste the MCP server URL, then Continue.
4. Sign in and approve.

On Team and Enterprise, an Owner adds it once. Everyone else turns it on for themselves.

## ThoughtSpot MCP connector for Claude Code

Endpoint: https://api.elaichi.ai/mcp

1. In a terminal, run `claude mcp add` with the endpoint.
2. Start Claude Code and run `/mcp`.
3. Pick elaichi, then sign in and approve in the browser.

```bash
claude mcp add --transport http elaichi --scope user https://api.elaichi.ai/mcp
```

Use `--scope project` instead to share it with the repository through `.mcp.json`.

## ThoughtSpot MCP connector for ChatGPT

Endpoint: https://api.elaichi.ai/mcp

1. Open Plugins, then press the + button.
2. Name it and paste the endpoint into Server URL.
3. Leave Authentication on OAuth, then tick the risk acknowledgement.
4. Press Create, then sign in and approve.

Works on the web. The plugin directory lives at chatgpt.com/plugins.

## ThoughtSpot MCP connector for Cursor

Endpoint: https://api.elaichi.ai/mcp

1. Open `~/.cursor/mcp.json`.
2. Add the endpoint under `mcpServers`.
3. Reload Cursor, then sign in and approve.

Set up per machine, so repeat it on each computer you work from.

## ThoughtSpot MCP connector for Microsoft Copilot

Endpoint: https://api.elaichi.ai/mcp

1. In Copilot Studio, open your agent, then Tools, Add a tool, New tool and Model Context Protocol.
2. Paste the endpoint into Server URL, choose OAuth 2.0, then Dynamic discovery, and press Create.
3. Create a new connection, sign in and approve, then press Add to agent.
4. Under Channels, open Teams and Microsoft Copilot and make the agent available in Microsoft Copilot.

Microsoft Copilot was called Microsoft 365 Copilot. Keep the tool on end-user credentials, so each person signs in as themselves.

## Connect ThoughtSpot to any MCP client

Endpoint: https://api.elaichi.ai/mcp

1. Add the endpoint as a remote MCP server.
2. Sign in and approve.

The Elaichi Agent already has these tools, with nothing to set up.

## What the consent screen decides

Every scope the client asks for starts ticked except "Delete things", which you tick yourself. Calling a ThoughtSpot tool needs "Use your connected apps". Over MCP there is no trusted place to confirm a write in the moment, so the consent screen is the standing approval rather than a formality. Think hard before granting Use your connected apps, which can also delete in connected apps and cannot be undone.

## What teams do with ThoughtSpot through Elaichi

### Ask a question and get the answer

Analytics. Send a plain-language question to a ThoughtSpot analyst agent and read the answer back in the chat you already have open. No dashboard to find, no filter to set.

### Set up a new hire in one go

IT. Create the ThoughtSpot user, add them to the right user groups, and give them the role their job needs, all from one request.

### Check who holds which role

Security. List every ThoughtSpot user and role side by side and spot who still has admin access that they no longer need.

### Find the right collection fast

Operations. Search ThoughtSpot collections by what you remember about them instead of clicking through folders, and get the right one back with its details.

### Pull the numbers before the call

Sales. Ask ThoughtSpot for this quarter's pipeline by region, or last month's wins by rep, and have the answer in front of you before the customer joins.

### Pick up where the last question ended

Finance. List your earlier ThoughtSpot agent conversations, reread the messages, and continue the thread rather than asking the whole question again.

## Elaichi vs Zapier MCP vs Composio for ThoughtSpot

All three can connect ThoughtSpot to an AI assistant, and all three have admin controls. They differ in where access lives and how you pay.

| What to check | Elaichi | Zapier MCP | Composio |
| --- | --- | --- | --- |
| Where the AI connects | One address for the whole organization. Endpoint: https://api.elaichi.ai/mcp | A server per member, created at sign-in. | An MCP endpoint per team, or an SDK. |
| Control over ThoughtSpot tools | Allow or restrict single ThoughtSpot tools, per role or user. | App and action restrictions on the account. | Role permissions, down to the action. |
| Record of calls | One audit entry per ThoughtSpot call. | A History tab of tool calls. | A log of every tool call. |
| Single sign-on | SAML or OIDC, plus SCIM, on Gold. | SAML on Enterprise. | SAML and OIDC on Enterprise. |
| Price | Free for one person; $15 per user per month on Gold. | 2 tasks per successful call. | Billed per tool call. |

Sources: Zapier MCP [docs](https://docs.zapier.com/mcp/get-started/quickstart), [security](https://docs.zapier.com/mcp/manage/security), [usage](https://docs.zapier.com/mcp/features/usage); Composio [docs](https://docs.composio.dev/docs/composio-connect), [gateway](https://composio.dev/mcp-gateway), [enterprise](https://composio.dev/enterprise), [pricing](https://composio.dev/pricing). Checked September 2026.

Longer take: [Zapier MCP alternative](/blog/zapier-mcp-alternative/) and [when you don't need an MCP gateway](/blog/when-you-dont-need-an-mcp-gateway/).

## Frequently asked questions

### How do I connect ThoughtSpot to Claude?

Two steps. In Elaichi, add the ThoughtSpot connector and paste in a ThoughtSpot API key, which is the only sign-in step, with no OAuth application to register and no client ID or secret to generate. Then in Claude, open Customize, then Connectors, then Add, and paste https://api.elaichi.ai/mcp. Claude can then reach ThoughtSpot as you.

### Does ThoughtSpot work with ChatGPT and Cursor as well as Claude?

Yes. Once ThoughtSpot is connected in Elaichi, the same endpoint, https://api.elaichi.ai/mcp, works in Claude, ChatGPT, Cursor, Microsoft Copilot, any MCP client, and the Elaichi Agent. You connect ThoughtSpot once and every client you use picks it up.

### What can an AI agent actually do with my ThoughtSpot data?

With ThoughtSpot connected, an agent can send a question to a ThoughtSpot analyst agent and bring the answer back, list and continue earlier conversations, and search collections. It can also list, create, update, and remove ThoughtSpot users, user groups, roles, and orgs. Short, concrete asks work better than long paragraphs.

### Does connecting ThoughtSpot give the AI access to every org and every user?

No. Every call runs under the access of the person who signed in, so an agent sees the ThoughtSpot orgs, users, and collections that person can already see. Elaichi can narrow that access further with roles and restrictions, and it can never widen it beyond what ThoughtSpot already allows.

### Can my team share one ThoughtSpot connection?

Yes. One person connects ThoughtSpot in Elaichi and shares the connection with a team, and nobody else ever handles the API key. Each teammate still signs in to Elaichi as themselves, so the audit log names the actual person behind every ThoughtSpot call.

### Can I stop an agent from deleting or changing things in ThoughtSpot?

Yes. Restrictions in Elaichi apply per action, for example deleting a ThoughtSpot user or updating a role, and are set on a role or on one person. A restricted action still appears in Elaichi's tool search, flagged as restricted, but no client can run it, whatever the prompt says.

### What happens to a ThoughtSpot connection when someone leaves?

Offboarding a person in Elaichi ends their access to ThoughtSpot through every client at once. A ThoughtSpot connection shared with a team keeps working for everyone else. If you disconnect ThoughtSpot in Elaichi, it is removed from Claude, ChatGPT, Cursor, Microsoft Copilot, and every other client in one step.

### Does the ThoughtSpot MCP connector work with Gemini, Codex, Claude Code or other MCP clients?

Yes. ThoughtSpot is reached over the same MCP endpoint every client uses, so anything that speaks MCP can call it — Gemini, Codex, Claude Code, Windsurf, Cline, Zed and OpenCode among them — alongside Claude, ChatGPT, Cursor, Microsoft Copilot, and the Elaichi Agent. The tools on offer and the access behind them are identical whichever client asks. Only the setup screen differs.

### Is Elaichi an alternative to Zapier MCP for ThoughtSpot?

Yes. Both let Claude, ChatGPT or Cursor use ThoughtSpot. Zapier MCP fits a team that already automates in Zapier, since each person signs in and acts as themselves in that account. Elaichi fits when IT wants one address for the whole company, per-tool rules by role, and a record of every ThoughtSpot call.

### How is Elaichi different from Composio for ThoughtSpot?

Composio gives AI agents tools and sign-in handling across 1,000+ apps, for developers building agents or people using an assistant, billed per tool call. Elaichi gives a company's own people governed access to ThoughtSpot: one address, restrictions per role or user, and $15 per user per month. Both have role permissions and a log of every call.

## All 220 ThoughtSpot tools

Every tool below is callable through https://api.elaichi.ai/mcp once ThoughtSpot is connected, subject to the toolbox it is in and the restrictions on the caller.

- **Create a ThoughtSpot authentication** (Create). Generate a full-access authentication token for a ThoughtSpot user via trusted authentication. Returns: token, creation_time_in_millis, expiration_time_in_millis, scope, valid_for_user_id, valid_for_username. Required: username, secret_key. Tokens expire after 300 seconds by default.
- **Create a ThoughtSpot role** (Create). Create a role in ThoughtSpot with a defined set of privileges, such as CAN_MANAGE_VERSION_CONTROL. Returns the created role object including id, privileges, created_at, and updated_at. Required: name.
- **Update a ThoughtSpot role by ID** (Update). Update a role in ThoughtSpot, including its assigned privileges. Returns the updated role object including id, privileges, created_at, and updated_at. Required: role_identifier.
- **Delete a ThoughtSpot role by ID** (Delete). Delete a role from ThoughtSpot by its identifier. Returns an empty 204 response on success. Required: role_identifier.
- **List all ThoughtSpot roles** (List). Search and list role objects available in ThoughtSpot. Returns roles including id, privileges, created_at, and updated_at.
- **List all ThoughtSpot users** (List). Search ThoughtSpot users and get details of one or several users. Returns: id, name, display_name, visibility, author_id, can_change_password, complete_detail, creation_time_in_millis, current_org, deleted, deprecated, account_type, account_status, email, expiration_time_in_millis, external, orgs, privileges, user_groups, and 20 more.
- **Create a ThoughtSpot user** (Create). Create a user in ThoughtSpot. Returns the created user record including id, name, display_name, email, account_status, and user_groups. Required: name, display_name, email.
- **Update a ThoughtSpot user by ID** (Update). Update the properties of a ThoughtSpot user object. Returns the updated user record including id, name, display_name, email, account_status, and user_groups. Required: id.
- **Delete a ThoughtSpot user by ID** (Delete). Delete a user object from ThoughtSpot by id. Returns an empty 204 response on success. Required: id.
- **List all ThoughtSpot user groups** (List). Search and list user groups in ThoughtSpot. Returns matching group records with their id.
- **Create a ThoughtSpot user group** (Create). Create a user group in ThoughtSpot. Returns the created group record with its id. Required: name, display_name.
- **Update a ThoughtSpot user group by ID** (Update). Update a user group's object properties in ThoughtSpot by id, including adding or removing users, sub-groups, and privileges. Returns the updated group record with its id. Required: id.
- **Delete a ThoughtSpot user group by ID** (Delete). Delete a user group from ThoughtSpot by id. Returns an empty 204 response on success. Required: id.
- **List all ThoughtSpot orgs** (List). List the Orgs configured on the ThoughtSpot system. Returns each matched Org record with its id and Org-specific attributes (upstream-defined; see ThoughtSpot docs for the field-level breakdown). Available in ThoughtSpot Cloud 9.2.0.cl or later.
- **Create a ThoughtSpot org** (Create). Create a new Org object in ThoughtSpot. Returns the created Org record with its id and Org-specific attributes (upstream-defined; see ThoughtSpot docs for the field-level breakdown). Available in ThoughtSpot Cloud 9.2.0.cl or later. Required: name.
- **Delete a ThoughtSpot org by ID** (Delete). Delete an Org object from ThoughtSpot. Returns an empty 204 response on success. Required: org_identifier. Available in ThoughtSpot Cloud 9.2.0.cl or later.
- **Update a ThoughtSpot org by ID** (Update). Update the object properties of an Org in ThoughtSpot. Returns the updated Org record with its id and Org-specific attributes (upstream-defined; see ThoughtSpot docs for the field-level breakdown). Required: org_identifier. Available in ThoughtSpot Cloud 9.2.0.cl or later.
- **List all ThoughtSpot me** (List). Get session information for the currently logged-in ThoughtSpot user. Returns: id, name, display_name, visibility, author_id, can_change_password, complete_detail, creation_time_in_millis, current_org, deleted, account_type, account_status, email, privileges, super_user, user_groups, user_inherited_groups, and 22 more. Takes no parameters.
- **ThoughtSpot 2 0 auths search** (Search). Retrieve ThoughtSpot authentication settings for the specified auth type at cluster and org level. Returns: auth_type, cluster_preferences, org_preferences. Currently supports TRUSTED_AUTH only. Required: auth_type.
- **ThoughtSpot 2 0 collections search** (Search). Search ThoughtSpot collections by name pattern (using '%' as a wildcard), by collection identifiers (GUID or name), or by author. Returns: collections, record_offset, record_size, is_last_batch, count. Available on ThoughtSpot 26.4.0.cl or later.
- **ThoughtSpot agent analysts search** (Search). Search ThoughtSpot Spotter Analysts. Provide analyst_identifier to fetch a single analyst, or omit it to page through analysts visible to you, optionally filtered by a case-insensitive name match (query) and ownership (type). Returns: analysts, total_size. Results are ordered by most recently accessed.
- **List all ThoughtSpot agent conversations** (List). List ThoughtSpot Spotter agent conversations saved by the currently authenticated user. Returns: conversation_identifier, conversation_title, created_at, updated_at, data_source_identifiers, data_source_names, is_pinned, analyst_id. Only conversations created with enable_save_chat: true are returned.
- **ThoughtSpot agent conversations send** (Send). Send natural language messages to an existing Spotter agent conversation in ThoughtSpot and get the complete agent response synchronously. Returns: messages. Required: conversation_identifier, messages. Create the conversation first via createAgentConversation; for real-time streamed responses use sendAgentConversationMessageStreaming instead.
- **List all ThoughtSpot agent conversations messages** (List). List the messages of a saved agent conversation in ThoughtSpot, in order. Returns: message_id, timestamp_in_millis, user_prompt, response_items. Required: conversation_identifier.
- **Create a ThoughtSpot AI analytical question** (Create). Decompose a natural language question into analytical sub-questions in ThoughtSpot, each mapped to a relevant data source. Returns a decomposedQueryResponse with the generated sub-questions (query, worksheetId, worksheetName). Deprecated — use getRelevantQuestions instead.
- **Create a ThoughtSpot AI data source suggestion** (Create). Get ThoughtSpot data source suggestions for a natural language query, ranked by confidence with LLM-generated reasoning. Returns: data_sources. Required: query. Beta endpoint — breaking changes may occur before GA.
- **Create a ThoughtSpot AI relevant question** (Create). Decompose a natural language query into analytical sub-questions in ThoughtSpot. Returns relevant_questions, each containing query, data_source_identifier, and data_source_name. Beta endpoint. Required: metadata_context, query.
- **Delete a ThoughtSpot analyst delete by ID** (Delete). Permanently delete a Spotter Analyst in ThoughtSpot. Irreversible — deleted analysts cannot be recovered. Returns: id. Required: id.
- **Create a ThoughtSpot analyst share** (Create). Share a ThoughtSpot Spotter Analyst with users or groups by updating its share permissions; READ_ONLY/MODIFY grant access, NO_ACCESS revokes it. Returns an empty 204 response on success. Required: analyst_identifier, permissions.
- **Update a ThoughtSpot analyst update by ID** (Update). Update a Spotter Analyst in ThoughtSpot by id. Returns: id, name, description, instructions, sources, mcp_connectors, starter_prompts, updated_time_in_millis, created_by, updated_by. Required: id, name, description, sources. The update is a full replace — optional fields omitted from the request are reset.
- **Create a ThoughtSpot analysts create** (Create). Create a Spotter Analyst in ThoughtSpot — a configured agent with data sources and optional instructions, MCP connectors, and starter prompts. Returns: id, name, description, instructions, sources, mcp_connectors, starter_prompts, and 3 more fields. Required: name, description, sources. Requires name, description, and at least one source.
- **Create a ThoughtSpot answer create** (Create). Generate a single AI answer for a natural language query against a ThoughtSpot data model, without a conversation session. Returns: session_identifier, generation_number, message_type, visualization_type, tokens, display_tokens. Required: query, metadata_identifier. Beta endpoint; breaking changes may occur before GA.
- **List all ThoughtSpot answer details** (List). Load the full answer payload for a specific answer in a ThoughtSpot agent conversation. Returns an answer object with title, tokens, visualization_type, and ac_state. Available from 26.7.0.cl. Required: conversation_identifier, answer_identifier.
- **Create a ThoughtSpot auth configure** (Create). Enable or disable Trusted Authentication (TRUSTED_AUTH) at cluster level or for specific Orgs in ThoughtSpot. Returns an empty 204 response on success. Requires auth_type and at least one of cluster_preferences or org_preferences. Required: auth_type.
- **Update a ThoughtSpot collection update by ID** (Update). Update an existing ThoughtSpot collection: change its name, description, or visibility settings, and add (ADD), remove (REMOVE), or replace (REPLACE, the default) its metadata objects. Returns an empty 204 response on success. Required: id.
- **Create a ThoughtSpot collections create** (Create). Create a new collection in ThoughtSpot to group metadata objects like Liveboards, Answers, and worksheets, optionally nested as sub-collections. Returns: id, name, obj_id, description, metadata, created_at, updated_at, author_name, author_id, org. Required: name. Requires version 26.4.0.cl or later.
- **ThoughtSpot collections deletes bulk delete** (Delete). Delete one or more collections from ThoughtSpot. Returns: metadata_deleted, metadata_skipped. Required: collection_identifiers. Requires ThoughtSpot version 26.4.0.cl or later.
- **Update a ThoughtSpot connection configuration update by ID** (Update). Update a ThoughtSpot connection configuration by its GUID or name. Returns an empty 204 response on success. If the configuration is disabled, re-set disabled to true in the payload or it defaults to false; parameterized OAuth connections accept only same_as_parent and policy_process_options. Required: id,…
- **Create a ThoughtSpot connection configurations create** (Create). Create an additional configuration for an existing ThoughtSpot data warehouse connection. Returns: configuration_identifier, name, configuration, data_warehouse_type, policy_type, and 6 more. Required: name, connection_identifier, configuration. policy_principals is required when policy_type is PRINCIPALS; policy_processes when PROCESSES.
- **ThoughtSpot connection configurations deletes bulk delete** (Delete). Delete one or more connection configuration objects in ThoughtSpot (v10.12.0.cl or later). Returns an empty 204 response on success. Requires a JSON request body identifying the connection configuration objects to delete. Required: configuration_identifier, connection_identifier.
- **Create a ThoughtSpot connection create** (Create). Create a data warehouse connection in ThoughtSpot for live query services. Returns the created connection including id, name, data_warehouse_type, configuration, and databases. Required: name, data_warehouse_type, data_warehouse_config. Set validate to false for connections without tables. Available in ThoughtSpot 9.2.0.cl or later.
- **Create a ThoughtSpot connection delete** (Create). Delete a ThoughtSpot connection (V2 endpoint) by its unique ID or name. Returns an empty 204 response on success. Required: connection_identifier. Remove the connection's dependent-object associations before deleting.
- **ThoughtSpot connection deletes bulk delete** (Delete). Delete a ThoughtSpot connection object. Returns an empty 204 response on success. Requires a JSON request body; remove the connection's dependent-object associations before deleting. This endpoint is deprecated and will be removed in September 2025 — prefer the V2 delete method. Required: connection_identifier.
- **Create a ThoughtSpot conversation create** (Create). Create a new Spotter conversation in ThoughtSpot. Returns: conversation_identifier. Required: metadata_identifier. Requires ThoughtSpot 10.4.0.cl or later (Beta).
- **Create a ThoughtSpot conversation creates create** (Create). Create a new Spotter AI agent conversation in ThoughtSpot. Returns: conversation_id, conversation_identifier, analyst_id. Required: conversation_settings. Available in ThoughtSpot 26.2.0.cl or later.
- **ThoughtSpot conversation deletes bulk delete** (Delete). Delete a saved Spotter agent conversation in ThoughtSpot, permanently removing it and all its associated messages — this operation is irreversible. Returns an empty 204 response on success. Required: conversation_identifier. Only conversations created with enable_save_chat: true are persisted and can be deleted.
- **List all ThoughtSpot conversation get share infos** (List). Get the current share state for a ThoughtSpot conversation you own: whether the shared view is outdated and which principals have access. Returns: conversation_id, is_shared_content_outdated, principals. Required: conversation_identifier. principals is empty and is_shared_content_outdated is null when the conversation was never shared.
- **List all ThoughtSpot conversation get shared contents** (List). Get the full read-only view of a shared ThoughtSpot conversation. Returns: conversation_id, shared_conversation_id, conversation_title, creator_user_id, data_sources, analyst_ids, messages, code_execution_files. Required: conversation_identifier. Use shared_conversation_id (not conversation_id) as the loadAnswer conversation_identifier.
- **Create a ThoughtSpot conversation share** (Create). Share a ThoughtSpot Spotter conversation with users or groups, granting or revoking read-only access or regenerating the point-in-time shared snapshot. Returns: refresh_shared_content, grant, revoke, notify_on_share. Required: conversation_identifier, grant, revoke.
- **Update a ThoughtSpot conversation update by ID** (Update). Update a ThoughtSpot agent conversation's display title or pinned state. Returns an empty 204 response on success. Only saved conversations can be updated; is_pinned requires version 26.10.0.cl or later. Required: id.
- ...and 170 more tools. Call `tools/list` via the MCP endpoint, or see the full catalog via the API, for the complete set.
