Skip to main content

Button Integration with AskTable MCP

By integrating the AskTable MCP extension, you can directly query databases in Coze using natural language. With simple configuration, your AI assistant will be able to analyze data.

Step 1: Open the Button Space​

  1. Log in to the Coze platform
  2. Enter your Button space
  3. Click on Extensions
Open Button Space

Step 2: Add a Custom Extension​

  1. Select Add Custom Extension
Add a Custom Extension

Step 3: Configure the JSON File​

  1. Before starting the configuration, you need to first get an API-Key and get a data source ID in AskTable.
  2. Copy the following JSON configuration to create a connection to AskTable's MCP (SSE) service. If you have other special requirements, please refer to the documentation
{
    "mcpServers": {
        "asktable": {
            "type": "sse",
            "url": "https://mcp.asktable.com/sse/?api_key=YOUR_API_KEY&datasource_id=YOUR_DATASOURCE_ID",
            "headers": {},
            "timeout": 300,
            "sse_read_timeout": 300
        }
    }
}
  1. Replace YOUR_API_KEY with the API Key you obtained from AskTable
  2. Replace YOUR_DATASOURCE_ID with your data source ID
  3. Click Confirm to save the configuration
Configure JSON File

Step 4: Enable the MCP Extension​

  1. After saving the configuration, find the AskTable MCP extension you just created in the list of extensions
  2. Enable this extension
    Enable the MCP Extension

🎉 Configuration Completed​

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

Configuration Completed

After the configuration is completed, you can 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:

Ready to Start a Conversation

For further assistance, please contact us.