Help Center/ AI/ Quickly Implement Intelligent Data Queries Based on SQLBot/ Procedure/ USing Started
Updated on 2026-07-24 GMT+08:00
View PDF
Share

USing Started

(Optional) Modifying Security Group Rules

  • This solution uses port 8000 to access SQLBot. It is open to all by default. Please refer to modifying the security group rules and configure the IP address whitelist.
  • This solution uses port 22 for remote login to the cloud server via SSH. If remote login is required, please refer to modifying the security group rules and configure the IP address whitelist to ensure normal access to the service.

New API login

  1. Log in to the SQLBot platform: Enter the access address "http://IP Address:8000" from the "Outputs" tab of the stack in a browser to access the SQLBot platform, and log in using the default administrator username and password.

    Default Username: admin Default Password: SQLBot@123456

    Figure 1 Enter the username and password

    Figure 2 SQLBot platform

  2. Click "Administrator" under the user icon in the lower-left corner, select "Change Password", and enter the new password as required.

    Figure 3 Change Password

Integration with MaaS services

  1. Log in to the MaaS platform. This document takes deploying the DeepSeek-v3 in China-Hong Kong as an example. In the left navigation bar, select "Online Inference".

    Figure 4 MaaS platform

  2. In the preset service list, select the desired service and click "Activate Service" in the operation column on the right. When grayed out, it indicates that the service has been activated.

    Figure 5 Activate Service

  3. After successful activation, select the desired service in the service list, click "Usage Instructions", and choose "OpenAI" as the interface type in the pop-up window to obtain the API address and model name.

    Figure 6 Usage Instructions

  4. When invoking model services deployed on MaaS, you need to fill in the API Key for interface authentication. In the left navigation bar, click "API Key Management" (you can create up to 30 keys. Each key is only displayed once upon creation, so please ensure it is properly saved. If a key is lost, it cannot be retrieved, and you will need to create a new API Key to obtain a new access key).

    Figure 7 API Key Management

  5. On the "API Key Management" page, click "Create API Key" in the upper-right corner, fill in the label (custom label for the API Key; labels must be unique and cannot be duplicated. Only uppercase and lowercase English letters, numbers, underscores, and hyphens are supported, with a length range of 1–100 characters) and description (custom description for the API Key), then click "OK." The label and description information cannot be modified after creation.

    Figure 8 Create API Key

  6. Click "System Administration" under the user icon in the lower-left corner, select "AI model config", and add a model.

    Figure 9 Model Config

    Figure 10 Model Provider

  7. Configure model information: select "OpenAI" for "Model Provider", customize and enter the "Model Name", enter the "Model Name" from "Figure 6 Commissioning Instructions" for "Base Model", enter the "API Address" from "Figure 6 Commissioning Instructions" for "API Domain", enter the API key from "Figure8 Create API Key" for "API Key", and click "Save" after completion.

    Figure 11 Configure Model Information

Integrate with DWS

  1. Navigate to the DWS console, and locate the purchased DWS instance.

    Figure 12 DWS instance

  2. Click the "LogIn" button in the Actions column of the DWS instance list to login DWS.

    Figure 13 Login DWS

  3. Create a new schema and table under the "postgres" database in DWS, and insert data.

  4. Click the "Cluster Name" of the DWS instance, and copy the "Intranet IP" address from the "Connection Information".

    Figure 14 Intranet IP of the Data Warehouse Instance

  5. Select "Data Source" on the right side of the SQLBot platform, click "Add Data Source", select the corresponding data source, and choose "PostgreSQL" this time.

    Figure 15 Select Data Source

    Figure 16 Data Source

  6. Configure the data source information: Enter a custom name for "Data Source Name", enter the "Hostname/IP Address" set in "Intranet IP of the DWS Instance" for "Intranet IP", enter the "Database Port" set in "Configure DWS Information" for "Port", enter the "Administrator User" set in "Configure DWS Information" for "Username", enter the "Login Password" set in "Configure DWS Information" for "Password", enter "postgres" for "Database", enter "client_encoding=utf8" for "Database Connection Configuration", click "Get Schema" to select the corresponding "Schema", perform "Validation" upon completion, and click "Next".

    Figure 17 Data source information

    Figure 18 Data source added successfully

  7. After the data source is added, click the data source to add tables as required.

    Figure 19 Add Table
    Figure 20 Select Table
    Figure 21 Table added successfully

  8. Click "Enable Data Query" and select the associated data source to start the intelligent data query conversation.

    Figure 22 Enable Data Query

    Figure 23 Select Associated Data Source

Parent Topic: Procedure