DMS Dify tools help developers create more powerful AI applications. The SQL executor is an important tool in the DMS Dify development process. This topic describes features and configurations of the SQL executor.
SQL executor
Overview
The SQL executor sends SQL statements that are received from upstream nodes or entered during the SQL executor configuration to the corresponding database and executes these SQL statements. Downstream nodes can edit SQL statements sent by the SQL executor.
Configure the SQL executor
On the Studio tab, click the workflow that you have created.
If you do not have an existing workflow, click Generate from Blank, configure the relevant information, and then click Create. Then, the system automatically redirects to the workflow editing page.
Click the icon after the START node to add a node and select AliyunDMS SQL Executor.
Click the ALIYUNDMS SQL EXECUTOR node and configure the following parameters.
Parameter
Required
Description
SQL
Yes
Enter SQL statements. The entered SQL statements can be executed in the database together with the SQL statements generated by the upstream DMS AI tool which can convert natural language to SQL statements.
DATABASE TYPE
Yes
Select the engine type of the destination database. The following database engine types are supported: ApsaraDB RDS for MySQL, ApsaraDB RDS for PostgreSQL, AnalyticDB for MySQL, and AnalyticDB for PostgreSQL.
HOST
Yes
Enter the database endpoint. Example: pgm-bp1938789****.pg.rds.aliyuncs.com.
DATABASE NAME
Yes
Enter the name of the destination database.
USERNAME
Yes
Enter the database account.
PASSWORD
Yes
Enter the password of the database account.
SCHEMA_NAME
No
Enter the schema to connect to. The default schema for PostgreSQL is Public.
After the configuration is complete, click Run.
View the running status, runtime, and input and output information in the result.