自然语言及SQL执行

开发中

开发环境

http://172.29.50.10:2333

POST

/sql_run

sql运行或自然语言查询

请求参数

Header 参数

Body 参数application/json

示例

示例 1示例 2

{
    "database_config": {
        "type": "mysql",
        "url": "172.29.50.10",
        "port": "3306",
        "user": "root",
        "password": "root",
        "database": "DB_sql_test"
    },
    "text": "找到名字为李红梅的人，要求返回名字、id、性别、地址"
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

cURL

示例 1示例 2

curl --location --request POST 'http://172.29.50.10:2333/sql_run' \
--header 'Content-Type: application/json' \
--data-raw '{
    "database_config": {
        "type": "mysql",
        "url": "172.29.50.10",
        "port": "3306",
        "user": "root",
        "password": "root",
        "database": "DB_sql_test"
    },
    "text": "找到名字为李红梅的人，要求返回名字、id、性别、地址"
}'

返回响应

🟢200成功

application/json

Body

示例

{
    "data": {
        "exc_data": [
            [
                "李红梅",
                "02305627-a1d7-4a02-a40d-b46567299cfa",
                "男",
                "政务区"
            ],
            [
                "李红梅",
                "064ad8c8-7213-4bd3-816d-5c590938d495",
                "女",
                "蜀山区"
            ]
        ],
        "field": [
            "name",
            "id",
            "gender",
            "address"
        ]
    },
    "metadata": {
        "database_type": "mysql",
        "query": "SELECT name, id, gender, address FROM feihe_man WHERE name = '李红梅';"
    },
    "status": "success"
}

修改于 2025-06-10 10:09:27

接口整合

schma查询