Deploying the AskTable MCP Server: Pick the Right Mode

Choosing the right deployment method is the first step in using MCP. AskTable MCP Server provides four deployment modes to suit different use cases.

This article will help you understand the characteristics of each deployment mode and choose the best solution for your needs.

---

1. Deployment Mode Overview

AskTable MCP Server supports four deployment modes:

---

2. How to Choose a Deployment Mode?

Decision Tree

Selection Suggestions

Choose SaaS SSE if you:

• •✅ Your database is accessible from the public internet
• •✅ Want the simplest configuration (no installation)
• •✅ Individual use or small team
• •✅ Quick experience and testing

Choose SaaS Stdio if you:

• •✅ Your database is accessible from the public internet
• •✅ Need local process control
• •✅ Prefer using Stdio mode

Choose Local SSE if you:

• •✅ Your database is in the intranet, not accessible from public internet
• •✅ Need multi-user access (team)
• •✅ Have strict data security requirements
• •✅ Need unified management and monitoring

Choose Local Stdio if you:

• •✅ Your database is in the intranet, not accessible from public internet
• •✅ Individual use
• •✅ Need offline work
• •✅ Prefer using Stdio mode

---

3. SaaS SSE Mode (Recommended for New Users)

3.1 Architecture Diagram

3.2 Advantages

✅ Zero Installation: No software to install, use directly ✅ Simple Configuration: Only need one URL ✅ Automatic Updates: Server-side automatic upgrades, no manual maintenance ✅ High Availability: Cloud service, stable and reliable

3.3 Configuration Steps

Step 1: Get Credentials

Log in to AskTable and get:

• •API Key (in "Settings" → "API Keys")
• •Datasource ID (in "Datasources" list)

Step 2: Configure Claude Desktop

Edit the config file (claude_desktop_config.json):

{
  "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
    }
  }
}

Step 3: Restart Claude Desktop

After saving the configuration, restart Claude Desktop to use.

3.4 Parameter说明

---

4. SaaS Stdio Mode

4.1 Architecture Diagram

4.2 Advantages

✅ Local Process: MCP Server runs locally, better control ✅ Visible Logs: Can view detailed operation logs ✅ Easy Debugging: Convenient for troubleshooting

4.3 Configuration Steps

Step 1: Install MCP Server

Using uv (recommended):

# Install uv
curl -LsSf https://astral.sh/uv/install.sh | sh

# Test installation
uvx asktable-mcp-server@latest --help

Or using pip:

pip install asktable-mcp-server

Step 2: Configure Claude Desktop

{
  "mcpServers": {
    "asktable": {
      "command": "uvx",
      "args": ["asktable-mcp-server@latest"],
      "env": {
        "API_KEY": "YOUR_API_KEY",
        "DATASOURCE_ID": "YOUR_DATASOURCE_ID"
      }
    }
  }
}

Step 3: Restart Claude Desktop

4.4 Environment Variable说明

---

5. Local SSE Mode (Recommended for Enterprise Users)

5.1 Architecture Diagram

5.2 Advantages

✅ Data Security: Data stays within the intranet ✅ Multi-User: Supports team sharing ✅ Unified Management: Centralized configuration and monitoring ✅ High Performance: Direct intranet connection, low latency

5.3 Deployment Methods

Method 1: Using AskTable All-in-One Image (Recommended)

AskTable's All-in-One image already includes MCP SSE Server.

Start Service:

docker run -d \
  --name asktable \
  -p 8080:8080 \
  -e DATABASE_URL=postgresql://user:pass@host:5432/db \
  registry.cn-shanghai.aliyuncs.com/datamini/asktable:latest

MCP Server Address:

http://your_server_ip:8080/mcp/sse/

Configure Claude Desktop:

{
  "mcpServers": {
    "asktable": {
      "type": "sse",
      "url": "http://your_server_ip:8080/mcp/sse/?api_key=YOUR_API_KEY&datasource_id=YOUR_DATASOURCE_ID",
      "headers": {},
      "timeout": 300,
      "sse_read_timeout": 300
    }
  }
}

Method 2: Standalone MCP Server Deployment

Using Docker:

docker run -d \
  --name asktable-mcp-server \
  -p 8095:8095 \
  -e API_KEY=your_api_key \
  -e DATASOURCE_ID=your_datasource_id \
  -e BASE_URL=http://your_asktable_server:8080/api \
  registry.cn-shanghai.aliyuncs.com/datamini/asktable-mcp-server:latest

MCP Server Address:

http://your_server_ip:8095/sse/

Configure Claude Desktop:

{
  "mcpServers": {
    "asktable": {
      "type": "sse",
      "url": "http://your_server_ip:8095/sse/?api_key=YOUR_API_KEY&datasource_id=YOUR_DATASOURCE_ID",
      "headers": {},
      "timeout": 300,
      "sse_read_timeout": 300
    }
  }
}

5.4 Advanced Configuration

Using Nginx Reverse Proxy:

server {
    listen 80;
    server_name mcp.your-company.com;

    location /mcp/ {
        proxy_pass http://localhost:8095/;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection "upgrade";
        proxy_set_header Host $host;
        proxy_set_header X-Real-IP $remote_addr;
        proxy_buffering off;
    }
}

Configure Claude Desktop:

{
  "mcpServers": {
    "asktable": {
      "type": "sse",
      "url": "http://mcp.your-company.com/mcp/sse/?api_key=YOUR_API_KEY&datasource_id=YOUR_DATASOURCE_ID",
      "headers": {},
      "timeout": 300,
      "sse_read_timeout": 300
    }
  }
}

---

6. Local Stdio Mode

6.1 Architecture Diagram

6.2 Advantages

✅ Fully Local: All components run locally ✅ Offline Work: No network connection needed ✅ Data Security: Data stays on local machine

6.3 Configuration Steps

Step 1: Install MCP Server

uvx asktable-mcp-server@latest

Step 2: Configure Claude Desktop

{
  "mcpServers": {
    "asktable": {
      "command": "uvx",
      "args": ["asktable-mcp-server@latest"],
      "env": {
        "API_KEY": "YOUR_API_KEY",
        "DATASOURCE_ID": "YOUR_DATASOURCE_ID",
        "BASE_URL": "http://localhost:8080/api"
      }
    }
  }
}

Step 3: Restart Claude Desktop

---

7. Configuration Comparison

7.1 Feature Comparison

7.2 Performance Comparison

---

8. Production Environment Recommendations

8.1 Enterprise Intranet Deployment

Recommended Solution: Local SSE Mode

Deployment Architecture:

[User] → [Nginx] → [MCP Server] → [AskTable] → [Database]

Key Configuration:

• •Use HTTPS (configure SSL certificate)
• •Configure access control (IP whitelist)
• •Enable logging and monitoring
• •Configure backup and disaster recovery

8.2 Individual/Small Team

Recommended Solution: SaaS SSE Mode

Advantages:

• •No server maintenance required
• •Automatic updates and backups
• •High availability guarantee

8.3 Hybrid Deployment

Scenario: Part of the data is in the cloud, part is in the intranet

Solution: Configure multiple MCP Servers

{
  "mcpServers": {
    "asktable-cloud": {
      "type": "sse",
      "url": "https://mcp.asktable.com/sse/?api_key=KEY1&datasource_id=DS1"
    },
    "asktable-local": {
      "type": "sse",
      "url": "http://internal-mcp:8095/sse/?api_key=KEY2&datasource_id=DS2"
    }
  }
}

---

9. Troubleshooting

9.1 SSE Connection Failed

Symptom: Cannot connect to MCP Server

Troubleshooting Steps:

1. •Check if URL is correct
2. •Test network connection: curl -v URL
3. •Check firewall settings
4. •Check server logs

9.2 Stdio Process Failed to Start

Symptom: Tools fail to load

Troubleshooting Steps:

1. •Test by running command manually: uvx asktable-mcp-server@latest
2. •Check if environment variables are correct
3. •Check Claude Desktop logs

9.3 Permission Error

Symptom: API Key invalid prompt

Troubleshooting Steps:

1. •Confirm API Key is correct
2. •Check if API Key has expired
3. •Confirm datasource ID is correct
4. •Check network connection

---

10. Summary

Choosing the right deployment mode requires considering:

• •Data location (cloud vs intranet)
• •Use scenario (individual vs team)
• •Security requirements (data security vs convenience)
• •Technical capability (configuration difficulty vs maintenance cost)

Quick Decision:

• •🚀 Quick experience → SaaS SSE
• •🏢 Enterprise intranet → Local SSE
• •💻 Personal development → SaaS Stdio or Local Stdio

Next Steps:

• •MCP User Guide - Learn how to use
• •MCP Architecture and Principles - Deep dive into technology

---

Related Reading:

• •MCP Introduction Guide
• •MCP Quick Start Guide

Technical Exchange:

• •Website: asktable.com