Skip to main content

Single-Node Deployment

🚀 The single-node version of AskTable is now available for free download, installation, and use.

💪 This guide will help you quickly deploy AskTable in your local environment and start using it with your internal data.

By continuing to download, install, and use AskTable, you agree to the Software Download, Installation, and Usage Agreement.

Prerequisites​

Hardware​

Minimum requirements: 2-core CPU, 4GB memory, 10GB hard disk. Supports both x86 and ARM architectures.

Operating System​

  1. Linux System The following software needs to be installed:

    1. Docker: Docker Installation Documentation.
    2. Docker Compose: Used to package and deploy AskTable and the MySQL database. Docker Compose Installation Documentation.

  2. macOS System The following software needs to be installed:

    1. Docker Desktop: An application on macOS desktop computers that includes Docker and Docker Compose. Installation Documentation.

Quick Deployment​

Save the following content as a docker-compose.yml file:

services:
  asktable:
    # AskTable
    image: registry.cn-shanghai.aliyuncs.com/datamini/asktable-all-in-one:latest  # For Mainland China
    # image: datamini/asktable-all-in-one:latest   # For other regions
    container_name: asktable
    depends_on:
      - asktable_mysql
    ports:
      - 8000:80
    environment:
      TZ: Asia/Shanghai
      BASE_URL: http://127.0.0.1:8000          # 【Must Modify】Address exposed by the container (i.e., the address from which it can be accessed externally, such as via a browser)
      LLM_API_KEY: your_api_key_here           # 【Must Modify】AI model token, a string starting with “asktable-”. Obtain it by logging into AskTable at https://cloud.asktable.com/?dialog=deployment.
      MYSQL_HOST: asktable_mysql               # MySQL database address (this MySQL is the AskTable database, not the database you want to query using AskTable, the latter needs to be added on the web page)
      MYSQL_USER: asktable                     # MySQL database username
      MYSQL_PASSWORD: asktable                 # MySQL database password
      MYSQL_DB: asktable                       # MySQL database name
      MYSQL_ROOT_PASSWORD: asktable            # Used to initialize sample data
      VDB_ADDRESS: http://asktable_vdb:6333    # Vector database address
      VDB_API_KEY: asktable                    # Vector database API key
    volumes:
      - ./asktable_data:/asktable
  
  asktable_mysql:
    image: registry.cn-shanghai.aliyuncs.com/dminfra/mysql:8.0.27  # For Mainland China
    # image: mysql:8.0.27   # For other regions
    container_name: asktable_mysql
    ports:
      - "3306:3306"
    environment:
      TZ: Asia/Shanghai
      MYSQL_ROOT_PASSWORD: asktable
      MYSQL_DATABASE: asktable
      MYSQL_USER: asktable
      MYSQL_PASSWORD: asktable
    volumes:
      - ./mysql_data:/var/lib/mysql

  asktable_vdb:
    image: registry.cn-shanghai.aliyuncs.com/dminfra/qdrant:v1.11.5
    container_name: asktable_vdb
    ports:
      - "6333:6333"
      - "6334:6334"
    environment:
      RUN_MODE: production
      TZ: Asia/Shanghai
      QDRANT__SERVICE__API_KEY: asktable
    volumes:
      - ./qdrant_storage:/qdrant/storage
      - ./qdrant_snapshots:/qdrant/snapshots

Note: The configuration items BASE_URL and LLM_API_KEY must be modified according to actual conditions.

Among them, LLM_API_KEY is obtained by clicking "Local Deployment of AskTable" at the top of the page after logging into https://cloud.asktable.com, as shown in the figure below.

intro
intro

Run AskTable​

After configuring, you can start AskTable using Docker Compose:

  1. Build and Start Containers

Run the following command in the directory where the docker-compose.yml file is located:

docker compose up -d
# Or docker-compose up -d

This command starts the AskTable application and MySQL database containers in the background.

  1. Access AskTable

Now that AskTable has started, you can access it via the browser:

http://127.0.0.1:8000

Here, you can log in with the default administrator account (admin@asktable.com, password admin) and start exploring the application.

Explore AskTable​

After logging in, you can start using AskTable for various tasks, such as:

  • Data Management: Create, manage, and query data sources.
  • Interact with AskTable AI: Use language models to query and analyze your data.
  • Customize Business Knowledge: Configure term libraries, training datasets, and default preferences as needed to adapt to your business scenarios.

Advanced Configuration (Optional)​

  1. Set Administrator Account: If you wish to set an administrator account, you can configure the following parameters:

    AUTH_EMAIL_INIT_ADMIN_EMAIL: admin@asktable.com
    AUTH_EMAIL_INIT_ADMIN_PASSWORD: admin

  2. Use Local LLM Model: If you want to use a local model, assuming the model inference service has already been deployed, you can configure the following parameters:

    Warning

    Using models not provided by AskTable may not guarantee performance, and we recommend applying for models at https://cloud.asktable.com.

    LLM_BASE_URL: http://10.10.0.3:11434/v1  # Local LLM service address
    LLM_API_KEY: your_api_key_here  # Local LLM service API Key (if no key authentication is required, do not configure)
    AT_FORCE_LLM_MODEL: Qwen2.5-72B-Instruct-128K  # Name of the model to force use

    Note: We recommend the full-version DeepSeek-V3-671B for local models. Other models must meet the following conditions:

    • At least 72B
    • At least 64K context
    • Support Function Call
    • Support JSON (Instruct) Output

Update Version​

If you need to update to the latest version, run the following commands in the directory where the docker-compose.yml file is located:

docker compose pull
docker compose down
docker compose up -d

Common Issues​

  1. Docker fails to run, prompts network error, how to solve?

    Ensure that the firewall allows access to the following addresses:

    • registry.cn-shanghai.aliyuncs.com (to download images)
    • aiproxy.asktable.com (to access AI model services)
    • lf.asktable.com (to access AI Tracing services)

  2. AskTable can open, but login fails with connection failure

    Please check the parameter BASE_URL in docker-compose.yaml. It needs to be configured as the address from which it can be accessed via a browser.

  3. How to verify connectivity between containers and the database (connection status)

    docker exec -ti asktable bash -c 'telnet DB_HOST DB_PORT'

    • DB_HOST (database host address)

    • DB_PORT (database port number)

    1. Successful connection will display Connected to localhost.
    2. Connection refused / Network unreachable / Timeout will display telnet: Unable to connect to remote host: Connection refused/host/timed out

  4. How to uninstall?

    In the directory where the docker-compose.yml file is located, perform the following operations:

    1. Execute the command docker compose down
    2. Delete the directories asktable_data and mysql_data (if any)

Precautions​

This deployment mode is suitable for quickly experiencing AskTable but is not suitable for production environments. Performance, accuracy, and stability cannot be guaranteed. If higher requirements are needed, please contact us.

Once again, thank you for using AskTable, and good luck! 🚀