thoughtspot-admin-mcp

billdback-ts/thoughtspot-admin-mcp

3.1

If you are the rightful owner of thoughtspot-admin-mcp and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

MCP server for ThoughtSpot admin capabilities.

thoughtspot-admin-mcp

A Model Context Protocol (MCP) server that provides ThoughtSpot administrative capabilities through Claude Desktop. This server allows you to search and analyze metadata from your ThoughtSpot instance, including liveboards, answers, logical tables, connections, tags, and user groups.

Features

  • Metadata Search: Search across all ThoughtSpot metadata types with filtering capabilities
  • User & Group Management: List, search, and manage users and groups
  • Advanced Filtering: Filter by metadata type, author, tags, and other criteria
  • Pagination Support: Handle large result sets with offset and limit parameters
  • Usage Analytics: Access view counts and last access timestamps
  • Content Governance: Analyze content distribution and tagging strategies
  • Permission Management: Add and remove users from groups

Available Tools

search-metadata

Searches ThoughtSpot metadata objects with flexible filtering options.

Parameters:

  • types (optional): Array of metadata types to search for
    • Valid types: LIVEBOARD, ANSWER, LOGICAL_TABLE, CONNECTION, TAG, USER_GROUP
    • Leave empty to search all types
  • authors (optional): Array of author names to filter by
  • tags (optional): Array of tag names to filter by
  • offset (optional): Record offset for pagination (default: 0)
  • limit (optional): Maximum number of records to return (default: 100, max: 1000)

Returns:

  • Metadata ID and object ID
  • Object name and type
  • Author information
  • Creation and modification timestamps
  • Associated tags
  • Usage statistics (views, last access)
  • Object descriptions

list-users

Lists ThoughtSpot users with optional filtering capabilities.

Parameters:

  • user_identifier (optional): Filter by user identifier (username/email)
  • display_name (optional): Filter by display name
  • name_pattern (optional): Filter by name pattern (supports wildcards like 'Bill*')
  • email (optional): Filter by email address
  • group_identifiers (optional): Filter by group identifiers (users who belong to these groups)
  • offset (optional): Record offset for pagination (default: 0)
  • limit (optional): Maximum number of records to return (default: 100, max: 1000)

Note: At least one filter must be provided (user_identifier, display_name, name_pattern, email, or group_identifiers).

Returns:

  • User ID, name, and display name
  • Email address and account status
  • Account type and privileges
  • Group memberships and inherited groups
  • Creation and modification timestamps

list-groups

Lists ThoughtSpot groups with optional filtering and user inclusion.

Parameters:

  • display_name (optional): Filter by group display name
  • group_identifier (optional): Filter by group identifier
  • name_pattern (optional): Filter by name pattern (supports wildcards)
  • include_users (optional): Include users in each group (default: false)
  • include_sub_groups (optional): Include sub-groups (default: false)
  • offset (optional): Record offset for pagination (default: 0)
  • limit (optional): Maximum number of records to return (default: 100, max: 1000)

Returns:

  • Group ID, name, and display name
  • Group description and type
  • System group status and privileges
  • List of users in the group (if include_users=true)
  • Creation and modification timestamps

manage-user-groups

Adds or removes users from groups in ThoughtSpot.

Parameters:

  • username (required): Username/email of the user to manage
  • operation (required): Operation to perform - "ADD" to add user to groups, "REMOVE" to remove user from groups
  • group_identifiers (required): List of group identifiers to add/remove the user from

Returns:

  • Success status and operation details
  • Confirmation message with operation performed
  • Username and group identifiers affected

Installation

  1. Clone this repository:
git clone <repository-url>
cd thoughtspot-admin-mcp
  1. Install dependencies:
pip install -r requirements.txt

Configuration for Claude Desktop

1. Create MCP Configuration File

Create a configuration file for Claude Desktop. The location depends on your operating system:

macOS:

~/Library/Application Support/Claude/claude_desktop_config.json

Windows:

%APPDATA%\Claude\claude_desktop_config.json

Linux:

~/.config/Claude/claude_desktop_config.json

2. Add MCP Server Configuration

Add the following configuration to your claude_desktop_config.json:

{
  "mcpServers": {
    "thoughtspot-admin": {
      "command": "python",
      "args": [
        "/path/to/thoughtspot-admin-mcp/thoughtspot_admin_mcp.py",
        "--tsurl", "https://your-thoughtspot-server.cloud",
        "--username", "your-username",
        "--token", "your-api-token"
      ]
    }
  }
}

NOTE that you will likely need to specify the full path to your Python environment that has the requirements installed.

Replace the following values:

  • /path/to/thoughtspot-admin-mcp/: Full path to this repository
  • https://your-thoughtspot-server.cloud: Your ThoughtSpot server URL
  • your-username: Your ThoughtSpot username
  • your-api-token: Your ThoughtSpot API token

3. Generate API Token

To get your ThoughtSpot API token:

  1. Log into your ThoughtSpot instance
  2. Go to Developer → REST Playground v2.0 → Authentication → Get Full Access Token
  3. Create a new token using your username, password, and validity time. A longer time is probably wise so it doesn't expire.
  4. Copy the token value for use in the configuration

4. Restart Claude Desktop

After updating the configuration file, restart Claude Desktop for the changes to take effect.

Usage Examples

Find All Liveboards

Search for all liveboards in the system

Find Content by Specific Author

Find all content created by john.doe

Find Objects with Specific Tags

Find all objects tagged with "Finance" or "Marketing"

Analyze Usage Patterns

Find liveboards with low usage (less than 10 views)

Content Audit

Find all objects that haven't been accessed in the last 30 days

User Management Examples

Find All Users

List all users in the system

Find Users by Name Pattern

Find users whose names start with "Bill"

Find Users in Specific Groups

Find all users who belong to the "Developers" group

Group Management Examples

List All Groups

List all groups in the system

List Groups with Users

List all groups and include the users in each group

User-Group Management Examples

Add User to Group

Add user john.doe@company.com to the "Developers" group

Remove User from Group

Remove user john.doe@company.com from the "Analysts" group

Add User to Multiple Groups

Add user john.doe@company.com to both "Developers" and "Analysts" groups

Development

Testing the Connection

You can test the connection to your ThoughtSpot instance:

python thoughtspot_admin_mcp.py --tsurl https://your-server.cloud --username your-username --token your-token --test

This will fetch all liveboards and answers and output them as JSON.

Running the Server Directly

For development or debugging:

python thoughtspot_admin_mcp.py --tsurl https://your-server.cloud --username your-username --token your-token

Requirements

  • Python 3.10 or higher
  • ThoughtSpot REST API v1 library
  • MCP library
  • Valid ThoughtSpot instance with API access

Security Notes

  • Store your API token securely
  • Use environment variables for sensitive configuration in production
  • Regularly rotate your API tokens
  • Ensure your ThoughtSpot instance has proper security configurations

Troubleshooting

Common Issues

  1. Connection Failed: Verify your ThoughtSpot URL, username, and token
  2. Permission Denied: Ensure your API token has appropriate permissions
  3. Invalid URL: Make sure the URL starts with http:// or https://
  4. Python Path: Ensure the correct Python interpreter is specified in the MCP configuration

Debug Logging

The server creates debug logs in mcp_debug.log (or /tmp/mcp_debug.log if the current directory is not writable). Check this file for detailed error information.

License

MIT License