Skip to main content

FastGPT Integration with 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, you can enable your AI assistant to have powerful data analysis capabilities.

Step 1: Enter the Workspace​

  1. Open FastGPT Platform

  2. Click Workspace

  3. Select Team Applications

  4. Click New MCP Toolset

    Open FastGPT

Step 2: Configure JSON File​

Preparation​

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

Configure MCP Server Address​

Copy the following URL address for connecting to the AskTable MCP server, establishing a secure data query channel through the API Key and Data Source ID:

http://mcp.asktable.com/sse/?apikey=YOUR_API_KEY&datasource_id=YOUR_DATASOURCE_ID
  1. Replace YOUR_API_KEY with the API Key you obtained from AskTable.
  2. Replace YOUR_DATASOURCE_ID with your data source ID.

Step 3: Configure MCP Connection​

Enter the configured URL into the MCP configuration box​

  1. Click the Parse button.

  2. After confirming the function is working properly, click Confirm Creation.

    Add MCP Server

Step 4: Create New Application​

  1. Return to the workspace, click New Simple Application.

    Configure JSON File

  2. Give the application a name.

  3. Click Create Blank Application.

    Enable MCP Extension

Step 5: Call the MCP Toolset​

  1. Find the tool call, click Select.

    Enable MCP Extension

  2. Click Add to add the toolset to the application.

    Enable MCP Extension

  3. The created MCP will appear in the tool call.

    Enable MCP Extension

  4. Click Save in the top right corner to save the application configuration.

    Enable MCP Extension

🎉 Configuration Completed​

Congratulations! You have successfully integrated the AskTable MCP extension into FastGPT!

Start Using​

Enter the chat interface of the application and ask example questions.

Enable MCP Extension

Example Questions​

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

Query Result Display​

Here are the query results obtained using the AskTable MCP service:

Query Result Display

For further assistance, please contact us.