Database is a system used to store and manage structured data files. By connecting a database to the Tencent Cloud Agent Development Platform, you can enable agents to perform Q&A based on structured data, supporting both single-table and multi-table queries.
Unlike traditional BI tools, which require professionals to build models, write SQL, or configure reports, integrating databases with agents allows business users to query and analyze data directly through natural language. In Data+AI scenarios, this approach not only provides greater interactivity but also enables multi-dimensional exploration and analysis with contextual understanding. This shifts data analysis from being “expert-driven” to “business-driven,” greatly improving enterprise data utilization and decision-making agility.
Note:
The target database must be MySQL 5.7 or later, or SQL Server 2012 or later.
If database connection security is a major concern, it is recommended to configure security groups and only allowlisted Tencent Cloud egress IPs (specific IPs can be obtained by contacting technical support ). This effectively reduces the risks of public network exposure.
Creating a Database
1. Click Knowledge Base > Create Knowledge Base, and fill in the basic information.
2. Enter the knowledge base, click Knowledge Base > Create, and fill in the basic information of the database. Here, you can enter the database name (required), database description, and data source information (required).
Database name: Supports Chinese, English, digits, underscores (_), hyphens (-), and periods (.). Character limit: 50.
Database description: Enter a repository description, up to 100 characters.
Database type: Supports drop-down selection of MySQL and SQL Server Database.
Database Host: The data source Host must be a public network address.
Port number: A unique ID for the database service.
Username: Manually input the username of the current database.
Password: Manually input the password of the current database.
Note:
Each account supports up to 100 databases. Each database can have up to 100 data tables.
3. After filling in the basic information, click Next to select the scope of integration, i.e., choose the database and tables to connect. Then click Confirm Integration to complete the integration.
Database list
On the database list page, you can view, edit, or delete a database.
The description of each field is as shown in the table below:
Field Name
Description
Database name.
Database name
Database ID
Unique identifier string for locating the data source and troubleshooting
Release Status
Released, Pending
Creation time.
The time when the database was integrated
Update time
The time the database list notes were last updated
Database Operations
Edit database: Click Edit Database basic information, need to enter database login password, editable after verification passes.
View database: Click View Database to enter the data table list page. The list supports viewing database table name, table description, creation time, update time, data volume, publishing status, and enable status.
Delete database: Click Delete Database to drop the currently connected database.
Note:
The database deletion will take effect once released.
Table Operations
On the data table list page, you can click edit data table to enter the data table settings. Here, you can:
Edit data table Chinese name: Add a Chinese name for the data table.
Edit data table description: Accurately describe the scenario of the table. The large model will identify and call the table based on this description.
Column settings support adding column descriptions (up to 100 characters), column Chinese names (up to 15 characters), organization information, and turning on or off the column index.
