An intelligent data analysis tool based on LLM and natural language interaction, featuring built-in data query and data visualization, as well as report generation capabilities.
data_analysis
Author: ada
Version: 1.0.15
Type: tool
English | 中文
Overview
This plugin enables codeless data analysis through natural language interaction. It supports Text2SQL, Text2Data, and Text2Code analysis. Simply upload Excel/CSV files to automatically execute data queries, data interpretation, and data visualization (ChatBI).
New support for multi-sheet queries and cross-sheet analysis, capable of automatically recognizing and parsing structured data in multiple worksheets, improving multi-sheet data processing capabilities.The plugin will intelligently parse time, metrics, and analytical dimensions through conversational queries , then generate SQL queries for data, and create interactive BI charts and structured analysis reports. Optimized for standardized vertical datasets, powered by enterprise-grade analytics engine for reliable results.
Configuration
1. Apply for an API Key
Please apply for an API Key here.
[Image blocked: apply_apikey.png]
2. Get data analysis tools from the Marketplace
The tools could be found at the plugin Marketplace, please install it.
3. Service Authorization
- Select [Plugins] - [data analysis] in Dify navigation page
- Click the "To Authorize" button
- Paste your unique API Key to complete verification
[Image blocked: set_apikey.png]
Workflow Cases
The following are the parameter descriptions and usage scenario examples of each tool.
1. data_connector
Used to connect mainstream databases such as MySQL, PostgreSQL, Starrocks and Doris, allowing users to query database data using natural language. Once data is retrieved, it can be seamlessly integrated with our other tools for analysis, interpretation, and visualization.
The query results support downloading as an .xlsx file for easier local viewing and further processing.
💡 If you want the output to include files, please ensure to add the ' files ' output type in the last component of the flow to get the download link.
Note: For optimal browsing experience, results are limited to 100 rows by default. When working with large datasets, user may retrieve the full dataset by using the intelligently generated SQL query provided by the tool.
Example input: For the database with url="mysql+pymysql://aaaadmin:[email protected]:11110/dify?charset=utf8", fill in the parameters as shown in the following figures.
[Image blocked: data_connector_1_1.png]
[Image blocked: data_connector_1_2.png]
[Image blocked: data_connector_2.png]
[Image blocked: data_connector_3.png]
Common Precautions：
- When the database contains too many tables, you need to specify the table name in the query (the table name must match exactly with the name in the database).
- Pay attention to distinguish between IP and port when entering parameters.
- Internal network, local databases and clustered databases are not currently supported; only databases that can be connected through DBeaver can be used.
2. data_analysis
Note: Only one of input_data or file is needed. If both are provided, file takes precedence. File types support both row-metric-column data files and column-metric-row data files.
[Image blocked: data_analysis_1.png]
[Image blocked: data_analysis_4.png]
The query results support downloading as an .docx file for easier local viewing and further processing.
💡 If you want the output to include files, please ensure to add the ' files ' output type in the last component of the flow to get the download link.
3. data_interpretation
Note: Only one of input_data or file is needed. If both are provided, file takes precedence.
[Image blocked: data_interpretation_1.png]
[Image blocked: data_interpretation_4.png]
The query results support downloading as an .docx file for easier local viewing and further processing.
💡 If you want the output to include files, please ensure to add the ' files ' output type in the last component of the flow to get the download link.
4. data_visualization
Note: Only one of input_data or file is needed. If both are provided, file takes precedence. File types support both row-metric-column data files and column-metric-row data files.
[Image blocked: data_visualization_1.png]
[Image blocked: data_visualization_4.png]
The query results support downloading as an .html file for easier local viewing and further processing.
💡 If you want the output to include files, please ensure to add the ' files ' output type in the last component of the flow to get the download link.
5. time_identify
Used to parse the time required for analysis based on the problem description
Note: Any time range excludes today and future dates. When the user asks about the last 7 days, the end time of the returned does not include today, and it is calculated backwards 7 days from yesterday.
[Image blocked: time_identify_1.png]
6. merge_to_multisheet
Merge multiple files into a single file with multiple worksheets.
Note: The uploaded files must meet the size and quantity requirements of the Dify platform.
[Image blocked: merge_to_multisheet_1.png] [Image blocked: merge_to_multisheet_2.png]
Consult
Contact us for inquiries or feedback.
[Image blocked: QR_code.png]
Discover SwiftAgent: Enterprise-grade data analytics and decision-making powered by LLM and intelligent agents.