schma查询

开发中

开发环境

http://172.29.50.10:2333

POST

/schema/schema

请求参数

Header 参数

Body 参数application/json

示例

{
  "database_config": {
    "type": "mysql",
    "url": "172.29.50.10",
    "port": "3306",
    "user": "root",
    "password": "root",
    "database": "LLM_test_data"
  }
}

请求示例代码

Shell

JavaScript

Java

Swift

PHP

Python

HTTP

Objective-C

Ruby

OCaml

Dart

curl --location --request POST 'http://172.29.50.10:2333/schema/schema' \
--header 'Content-Type: application/json' \
--data-raw '{
  "database_config": {
    "type": "mysql",
    "url": "172.29.50.10",
    "port": "3306",
    "user": "root",
    "password": "root",
    "database": "LLM_test_data"
  }
}'

返回响应

🟢200成功

application/json

Body

示例

{
    "all_tables_info": "\n表 i_c_n (浣熊市人员信息):\n  列信息:\n  - 列名: id, 类型: float, 注释: id\n  - 列名: cname, 类型: varchar(50), 注释: 中文名\n  - 列名: name, 类型: varchar(50), 注释: 英文名\n\n表 table_name (格陵兰岛人员个人信息):\n  列信息:\n  - 列名: user_name, 类型: varchar(50), 注释: 用户名\n  - 列名: mobile, 类型: bigint, 注释: 手机号\n  - 列名: email, 类型: varchar(50), 注释: 邮箱\n  - 列名: id, 类型: varchar(50), 注释: id\n",
    "full_database_schema": {
        "database_name": "LLM_test_data",
        "tables": [
            {
                "columns": [
                    {
                        "comment": "id",
                        "name": "id",
                        "type": "float"
                    },
                    {
                        "comment": "中文名",
                        "name": "cname",
                        "type": "varchar(50)"
                    },
                    {
                        "comment": "英文名",
                        "name": "name",
                        "type": "varchar(50)"
                    }
                ],
                "table_comment": "浣熊市人员信息",
                "table_name": "i_c_n"
            },
            {
                "columns": [
                    {
                        "comment": "用户名",
                        "name": "user_name",
                        "type": "varchar(50)"
                    },
                    {
                        "comment": "手机号",
                        "name": "mobile",
                        "type": "bigint"
                    },
                    {
                        "comment": "邮箱",
                        "name": "email",
                        "type": "varchar(50)"
                    },
                    {
                        "comment": "id",
                        "name": "id",
                        "type": "varchar(50)"
                    }
                ],
                "table_comment": "格陵兰岛人员个人信息",
                "table_name": "table_name"
            }
        ]
    }
}

修改于 2025-06-10 10:13:31

自然语言及SQL执行

单表的字段描述查询