app:
description: mysql查询
icon: 🤖
icon_background: '#FFEAD5'
icon_type: emoji
mode: advanced-chat
name: 数据库查询
use_icon_as_answer_icon: false
dependencies:
- current_identifier: null
type: marketplace
value:
marketplace_plugin_unique_identifier: langgenius/mimo:0.0.8@18947da24866d0e1e84558ae7dcc96d491f8d9f96c982f1704945e24a65c0362
version: null
kind: app
version: 0.6.0
workflow:
conversation_variables: []
environment_variables: []
features:
file_upload:
allowed_file_extensions:
- .JPG
- .JPEG
- .PNG
- .GIF
- .WEBP
- .SVG
allowed_file_types:
- image
allowed_file_upload_methods:
- local_file
- remote_url
enabled: false
fileUploadConfig:
attachment_image_file_size_limit: 2
audio_file_size_limit: 50
batch_count_limit: 5
file_size_limit: 15
file_upload_limit: 20
image_file_batch_limit: 10
image_file_size_limit: 10
single_chunk_attachment_limit: 10
video_file_size_limit: 100
workflow_file_upload_limit: 10
image:
enabled: false
number_limits: 3
transfer_methods:
- local_file
- remote_url
number_limits: 3
opening_statement: ''
retriever_resource:
enabled: true
sensitive_word_avoidance:
enabled: false
speech_to_text:
enabled: false
suggested_questions: []
suggested_questions_after_answer:
enabled: false
text_to_speech:
enabled: false
language: ''
voice: ''
graph:
edges:
- data:
sourceType: llm
targetType: answer
id: llm-answer
source: llm
sourceHandle: source
target: answer
targetHandle: target
type: custom
- data:
isInIteration: false
isInLoop: false
sourceType: start
targetType: tool
id: 1782035365693-source-1782035406856-target
source: '1782035365693'
sourceHandle: source
target: '1782035406856'
targetHandle: target
type: custom
zIndex: 0
- data:
isInIteration: false
isInLoop: false
sourceType: tool
targetType: llm
id: 1782035406856-source-llm-target
source: '1782035406856'
sourceHandle: source
target: llm
targetHandle: target
type: custom
zIndex: 0
nodes:
- data:
selected: false
title: 用户输入
type: start
variables: []
height: 72
id: '1782035365693'
position:
x: 80
y: 282
positionAbsolute:
x: 80
y: 282
selected: false
sourcePosition: right
targetPosition: left
type: custom
width: 242
- data:
context:
enabled: false
variable_selector: []
memory:
query_prompt_template: '{{#sys.query#}}
{{#sys.files#}}'
role_prefix:
assistant: ''
user: ''
window:
enabled: false
size: 10
model:
completion_params:
temperature: 0.7
mode: chat
name: mimo-v2.5-pro
provider: langgenius/mimo/mimo
prompt_template:
- id: d287a401-abe1-413b-8059-0672e885ef77
role: system
text: 你是一个数据优化小助手，现在需要将用户的问题和数据库查询的结果，结果是json格式，你需要提前进行解析，数据在records中，你需要结合温和和数据进行润色，并输出，如果用户的问题在数据中查询不到，你就直接返回暂无此人。
- id: 1b8fe55d-45c4-44ca-9eae-0e4dd7fbfb27
role: user
text: '{{#1782035406856.text#}}{{#sys.query#}}'
selected: false
title: LLM
type: llm
vision:
enabled: false
height: 87
id: llm
position:
x: 680
y: 282
positionAbsolute:
x: 680
y: 282
selected: false
sourcePosition: right
targetPosition: left
type: custom
width: 241
- data:
answer: '{{#llm.text#}}'
selected: false
title: 直接回复
type: answer
variables: []
height: 102
id: answer
position:
x: 980
y: 282
positionAbsolute:
x: 980
y: 282
selected: false
sourcePosition: right
targetPosition: left
type: custom
width: 241
- data:
is_team_authorization: true
paramSchemas:
- auto_generate: null
default: mysql
form: llm
human_description:
en_US: Used for selecting the database type, mysql, oracle, oracle11g,
postgresql or mssql.
ja_JP: Used for selecting the database type, mysql, oracle, oracle11g,
postgresql or mssql.
pt_BR: Used for selecting the database type, mysql, oracle, oracle11g,
postgresql or mssql.
zh_Hans: 用于选择数据库类型，mysql、oracle、oracle11g、postgresql或mssql。
label:
en_US: Database type
ja_JP: Database type
pt_BR: Database type
zh_Hans: 数据库类型
llm_description: ''
max: null
min: null
name: db_type
options:
- icon: ''
label:
en_US: MySQL
ja_JP: MySQL
pt_BR: MySQL
zh_Hans: MySQL
value: mysql
- icon: ''
label:
en_US: Oracle
ja_JP: Oracle
pt_BR: Oracle
zh_Hans: Oracle
value: oracle
- icon: ''
label:
en_US: Oracle11g
ja_JP: Oracle11g
pt_BR: Oracle11g
zh_Hans: Oracle11g
value: oracle11g
- icon: ''
label:
en_US: PostgreSQL
ja_JP: PostgreSQL
pt_BR: PostgreSQL
zh_Hans: PostgreSQL
value: postgresql
- icon: ''
label:
en_US: Microsoft SQL Server
ja_JP: Microsoft SQL Server
pt_BR: Microsoft SQL Server
zh_Hans: Microsoft SQL Server
value: mssql
placeholder: null
precision: null
required: true
scope: null
template: null
type: select
- auto_generate: null
default: localhost
form: llm
human_description:
en_US: Database hostname or IP address (Original string, not URL-encoded
string).
ja_JP: Database hostname or IP address (Original string, not URL-encoded
string).
pt_BR: Database hostname or IP address (Original string, not URL-encoded
string).
zh_Hans: 数据库的主机名或IP地址（原始字符串，非URL编码字符串）。
label:
en_US: Database Host
ja_JP: Database Host
pt_BR: Database Host
zh_Hans: 数据库地址
llm_description: ''
max: null
min: null
name: db_host
options: []
placeholder: null
precision: null
required: true
scope: null
template: null
type: string
- auto_generate: null
default: null
form: llm
human_description:
en_US: Database port.
ja_JP: Database port.
pt_BR: Database port.
zh_Hans: 数据库的端口。
label:
en_US: Port
ja_JP: Port
pt_BR: Port
zh_Hans: 端口
llm_description: ''
max: null
min: null
name: db_port
options: []
placeholder: null
precision: null
required: false
scope: null
template: null
type: number
- auto_generate: null
default: null
form: llm
human_description:
en_US: Database username (Original string, not URL-encoded string).
ja_JP: Database username (Original string, not URL-encoded string).
pt_BR: Database username (Original string, not URL-encoded string).
zh_Hans: 数据库的用户名（原始字符串，非URL编码字符串）。
label:
en_US: Username
ja_JP: Username
pt_BR: Username
zh_Hans: 用户名
llm_description: ''
max: null
min: null
name: db_username
options: []
placeholder: null
precision: null
required: true
scope: null
template: null
type: string
- auto_generate: null
default: null
form: llm
human_description:
en_US: Database password (Original string, not URL-encoded string).
ja_JP: Database password (Original string, not URL-encoded string).
pt_BR: Database password (Original string, not URL-encoded string).
zh_Hans: 数据库的密码（原始字符串，非URL编码字符串）。
label:
en_US: Password
ja_JP: Password
pt_BR: Password
zh_Hans: 密码
llm_description: ''
max: null
min: null
name: db_password
options: []
placeholder: null
precision: null
required: true
scope: null
template: null
type: secret-input
- auto_generate: null
default: null
form: llm
human_description:
en_US: Database name (Original string, not URL-encoded string).
ja_JP: Database name (Original string, not URL-encoded string).
pt_BR: Database name (Original string, not URL-encoded string).
zh_Hans: 数据库的名称（原始字符串，非URL编码字符串）。
label:
en_US: Database name
ja_JP: Database name
pt_BR: Database name
zh_Hans: 库名
llm_description: ''
max: null
min: null
name: db_name
options: []
placeholder: null
precision: null
required: false
scope: null
template: null
type: string
- auto_generate: null
default: null
form: llm
human_description:
en_US: 'Database properties, for example: alt_host=host1&alt_host=host2&ssl_cipher=%2Fpath%2Fto%2Fcrt'
ja_JP: 'Database properties, for example: alt_host=host1&alt_host=host2&ssl_cipher=%2Fpath%2Fto%2Fcrt'
pt_BR: 'Database properties, for example: alt_host=host1&alt_host=host2&ssl_cipher=%2Fpath%2Fto%2Fcrt'
zh_Hans: 数据库属性，例如：alt_host=host1&alt_host=host2&ssl_cipher=%2Fpath%2Fto%2Fcrt
label:
en_US: Database properties
ja_JP: Database properties
pt_BR: Database properties
zh_Hans: 数据库属性
llm_description: ''
max: null
min: null
name: db_properties
options: []
placeholder: null
precision: null
required: false
scope: null
template: null
type: string
- auto_generate: null
default: null
form: llm
human_description:
en_US: 'SQL query statement, for example: select * from tbl_name'
ja_JP: 'SQL query statement, for example: select * from tbl_name'
pt_BR: 'SQL query statement, for example: select * from tbl_name'
zh_Hans: SQL查询语句，例如：select * from tbl_name
label:
en_US: Query SQL
ja_JP: Query SQL
pt_BR: Query SQL
zh_Hans: SQL查询语句
llm_description: 'SQL query statement, for example: select * from tbl_name'
max: null
min: null
name: query_sql
options: []
placeholder: null
precision: null
required: true
scope: null
template: null
type: string
- auto_generate: null
default: markdown
form: form
human_description:
en_US: Used for selecting the output format, markdown or json.
ja_JP: Used for selecting the output format, markdown or json.
pt_BR: Used for selecting the output format, markdown or json.
zh_Hans: 用于选择输出格式，markdown或json。
label:
en_US: Output format
ja_JP: Output format
pt_BR: Output format
zh_Hans: 输出格式
llm_description: ''
max: null
min: null
name: output_format
options:
- icon: ''
label:
en_US: MARKDOWN
ja_JP: MARKDOWN
pt_BR: MARKDOWN
zh_Hans: MARKDOWN
value: markdown
- icon: ''
label:
en_US: JSON
ja_JP: JSON
pt_BR: JSON
zh_Hans: JSON
value: json
placeholder: null
precision: null
required: true
scope: null
template: null
type: select
params:
db_host: ''
db_name: ''
db_password: ''
db_port: ''
db_properties: ''
db_type: ''
db_username: ''
output_format: ''
query_sql: ''
plugin_id: junjiem/db_query
plugin_unique_identifier: junjiem/db_query:0.0.11@2eae0951f13c4e8daa099310d706c9502c349236bca81fcc996f2aea9524c97c
provider_icon: /console/api/workspaces/current/plugin/icon?tenant_id=116743ea-2986-4663-b539-4af98624f4ce&filename=ce2ce5af47e39e9476fc06eea7fbd05446ad16043d4d16c671e69a3c650a976a.svg
provider_id: junjiem/db_query/db_query
provider_name: junjiem/db_query/db_query
provider_type: builtin
selected: true
title: SQL查询
tool_configurations:
output_format:
type: constant
value: markdown
tool_description: 数据库SQL查询工具。
tool_label: SQL查询
tool_name: sql_query
tool_node_version: '2'
tool_parameters:
db_host:
type: mixed
value: 8.216.37.111
db_name:
type: mixed
value: test_heima
db_password:
type: mixed
value: Liu5201314&
db_port:
type: constant
value: 3306
db_properties:
type: mixed
value: null
db_type:
type: constant
value: mysql
db_username:
type: mixed
value: root
query_sql:
type: mixed
value: insert into user values(null,'abc','454545');
type: tool
height: 87
id: '1782035406856'
position:
x: 380
y: 282
positionAbsolute:
x: 380
y: 282
selected: true
sourcePosition: right
targetPosition: left
type: custom
width: 241
viewport:
x: -74
y: 52
zoom: 1
rag_pipeline_variables: []