Skip to main content

Cherry Studio integrates AskTable MCP

By integrating the AskTable MCP extension, you can directly query and analyze data using natural language within Cherry Studio, gaining insights. With just a simple configuration, your AI assistant can be equipped with powerful data analysis capabilities.

Step 1: Open Cherry Studio Settings

  1. Launch the Cherry Studio application

  2. Click on the "Settings" option

    Open Cherry Studio

Step 2: Add an MCP Server

  1. In the settings interface, select the MCP server

  2. Click on "Add Server"

  3. Choose "Import from JSON"

    Add MCP Server

Step 3: Configure the JSON File

  1. Before starting the configuration, you need to first get your API-Key and get your data source ID in AskTable.

  2. Copy the following JSON configuration and create a connection to the AskTable MCP (SSE) service. If you have any other special requirements, please refer to the documentation

    {
    "mcpServers": {
    "asktable": {
    "type": "sse",
    "url": "https://mcp.asktable.com/sse/?apikey=YOUR_API_KEY&datasource_id=YOUR_DATASOURCE_ID",
    "headers": {},
    "timeout": 300,
    "sse_read_timeout": 300
    }
    }
    }
  3. Replace YOUR_API_KEY with the API Key you obtained from AskTable

  4. Replace YOUR_DATASOURCE_ID with your data source ID

  5. Click Confirm to save the configuration

    Configure JSON File

Step 4: Enable the MCP Service

  1. After the configuration is complete, click on the "Assistant" option
  2. Select the MCP server
  3. Choose AskTable
    Enable MCP Extension

🎉 Configuration Completed

Congratulations! You have successfully integrated the AskTable MCP extension into Cherry Studio! You can now start having intelligent conversations with your data.

Example Question

Query the average scores of all teachers in teaching, research, and services, and select the top 5 departments with the highest average teaching scores.

Query Result Display

Here is the query result obtained using the AskTable MCP service:

Display of Query Results

For further assistance, please contact us.