Starting from August 2026, AI Assistant is upgraded to Hologres Agent. Hologres Agent is an intelligent assistant built into the Hologres console. Powered by large language models, it lets you use natural language to get product answers, operate instances, develop data warehouses, and analyze data.
After the upgrade, Hologres Agent covers the following four capability areas, so that you can complete daily Hologres work from a single conversation entry point.
Product consulting: Combines the official Hologres documentation with an in-house data warehouse knowledge base to answer questions about features and usage, so that you no longer need to search the documentation yourself.
Instance operations: Covers performance diagnostics, resource diagnostics, job troubleshooting, and governance, and inspects instance health on a schedule. Instead of tracing an issue across multiple pages, you get the root cause and the recommended actions in one conversation.
Data warehouse development: Connects table creation, SQL authoring, and data processing into one flow, so that you no longer switch between development platforms. You can go from modeling to data ingestion using natural language.
Data analysis: Provides natural language driven data retrieval, chart generation, and trend interpretation, so that business users no longer depend on developers to get conclusions from data.
Disclaimers
Read the following notes before you use Hologres Agent:
AI-generated content is for reference only: Responses are produced by an AI model. Alibaba Cloud cannot guarantee that the content is secure, reliable, compliant, complete, or accurate, and the content does not represent the position or views of Alibaba Cloud. Evaluate each response against your own situation, and do not run critical operations on unverified output. Alibaba Cloud is not liable for any loss that results from decisions or actions you take based on generated content.
Apply changes with caution: Before you act on any suggestion that changes a configuration or performs a high-risk operation, such as a deletion or a permission change, validate it in a test environment first.
Permission boundary: Hologres Agent runs as the currently logged-on user and never exceeds the permissions of that account. Diagnostics, optimization, and data analysis read project metadata, job logs, table schemas, and table data, so the requester must hold the corresponding permissions.
Data privacy: Diagnostic features read only job logs, metadata, and similar information, and do not modify data. Data warehouse development and data processing features run SQL within the scope that you authorize, and may create tables or write data. Confirm the impact before you run such an operation. No feature transfers your data outside Alibaba Cloud.
Compliant use: You are responsible for how you use this service. Make sure that any content you publish, upload, or provide through the service is lawful and compliant, does not disrupt public order, and does not infringe on the rights of others.
Typical use cases
Hologres Agent covers the typical scenarios that you encounter when you use Hologres. Common usage by role is as follows:
User role | Typical use cases |
Data warehouse developer | Layered modeling and DDL generation, writing SQL in natural language, data import and export, identifying cold and empty tables, lifecycle and storage cost governance, table schema and index design, and data processing. |
DBA and platform O&M engineer | Instance management, daily inspection reports, diagnostics for slow and failed queries, execution plan optimization, table governance, ticket troubleshooting, and cost governance. |
Data analyst and BI engineer | Querying data in natural language, query performance optimization, and interpreting and sharing diagnostic results. |
Feature list
Hologres Agent supports the following features.
Category | Feature | Description |
Product consulting | Knowledge Q&A | Answers questions about Hologres, including feature usage, feature introductions, and best practices, based on the official documentation and an internal knowledge base. This feature does not connect to instances or execute SQL. |
Instance operations | CPU diagnostics | Analyzes abnormal CPU usage based on instance monitoring data, identifies high-consumption SQL statements and resource bottlenecks, and provides optimization recommendations. |
Memory diagnostics | Analyzes memory usage trends and memory consumption categories, identifies risks such as memory leaks and large memory consumers, and provides tuning recommendations. | |
Slow SQL analysis | Identifies slow and failed SQL statements, performs root-cause analysis based on execution plans and system load, and provides targeted recommendations such as index optimization and SQL rewriting. Optimization suggestions can also be obtained by Query ID. | |
Operations reports | Generates instance health-check reports, aggregating multi-dimensional operational information such as resource usage, performance trends, SQL activity, and cost and capacity. You can generate the report manually, or use a scheduled task to generate it daily, weekly, or monthly. | |
Write job diagnostics | Diagnoses write jobs from Flink, DataWorks, and other services. Provide the job link, and the agent locates write failures, write latency, and write performance bottlenecks, and returns optimization suggestions. | |
Table governance | Identifies cold and empty tables, reviews storage format, index, and key design, and returns suggestions on table structure optimization, time to live (TTL), and storage cost governance based on actual query patterns. | |
Data warehouse development | Natural language-driven data warehouse development | Generates and corrects SQL, designs data warehouse layers, and assists you in creating tables and indexes. You can complete data warehouse development tasks using natural language, including newly supported scenarios such as Dynamic Table creation and diagnostics, multimodal processing job creation, and MaxCompute data ingestion. |
Data analysis | Natural language-driven data analysis | Retrieves data on a self-service basis, generates charts quickly, interprets analysis results, and forecasts trends. Newly supported scenarios include multimodal data retrieval and analysis, and data trend interpretation. |
Scheduled tasks | Scheduled operations report | You can create a scheduled task for an operations report. The report is generated on schedule and pushed to a DingTalk group through a DingTalk chatbot. Scheduled tasks are currently supported only for operations reports. |
Files | File management and sharing | All files that Hologres Agent produces are listed in the Files entry, and you can share them with others. |
Supported regions and pricing
Before July 1, 2026, Hologres Agent is in public preview at no charge.
Starting July 1, 2026, Hologres Agent reaches general availability and is billed on a pay-as-you-go basis by token consumption. For details, see Hologres AI Assistant billing announcement.
Hologres Agent uses qwen3.8-max as the default model.
The following tables list the billing rates by region.
Region | Billable item | 0 < Tokens per request ≤ 1M |
Mainland China:
| Input (USD/1K tokens) | 0.00198 |
Explicit cache creation (USD/1K tokens) | 0.00248 | |
Explicit cache hit (USD/1K tokens) | 0.00020 | |
Implicit cache hit (USD/1K tokens) | 0.00040 | |
Output (USD/1K tokens) | 0.00594 | |
Regions outside mainland China (excluding the US):
| Input (USD/1K tokens) | 0.00240 |
Explicit cache creation (USD/1K tokens) | 0.00375 | |
Explicit cache hit (USD/1K tokens) | 0.00030 | |
Implicit cache hit (USD/1K tokens) | 0.00060 | |
Output (USD/1K tokens) | 0.00720 | |
US (Virginia) | Input (USD/1K tokens) | 0.00198 |
Explicit cache creation (USD/1K tokens) | 0.00248 | |
Explicit cache hit (USD/1K tokens) | 0.00020 | |
Implicit cache hit (USD/1K tokens) | 0.00040 | |
Output (USD/1K tokens) | 0.00594 |
Activate Hologres Agent
Purchase Hologres Agent
To purchase Hologres Agent, perform the following steps:
Log on to the Hologres console. In the left-side navigation pane, click AI Assistant.
If Hologres Agent has not been purchased in the current region, the page prompts you to purchase it.
Click Buy Now. The Hologres Agent purchase page opens in a new browser tab.
NoteHologres Agent is a region-level service. Make sure that you select the region that matches your Hologres instances. After the purchase, Hologres Agent becomes available to all Hologres instances in that region.
On the purchase page, select a subscription duration and complete the payment.
After the purchase is complete, return to the Hologres console and refresh the page. The page displays your Hologres Agent instance information.
If your Hologres Agent subscription has expired and the instance status is Stopped, click Renew to go to the renewal page and extend your subscription.
View the Hologres Agent instance
After the purchase is complete, log on to the Hologres console. In the left-side navigation pane, click AI Assistant to verify that Hologres Agent is activated.
Hologres Agent is a region-level service. After you purchase Hologres Agent in a region, every Hologres instance in that region can use its diagnostic capabilities. You do not need to associate instances one by one. To target a specific instance in a conversation, enter @ and select the instance.
Permission requirement: the AliyunHologresFullAccess policy is required to purchase, renew, and release Hologres Agent.
The page displays different content depending on the purchase status:
Not purchased: The page displays a message indicating that Hologres Agent has not been purchased in the current region. Click Buy Now to go to the purchase page. If Hologres Agent has been suspended, click Renew to go to the renewal page.
Purchased: The page displays the following information about your Hologres Agent instance:
Field
Description
AI Assistant ID
The unique identifier of the Hologres Agent instance.
AI Assistant Status
The current running status: Normal or Stopped. Click Release next to the status to unsubscribe and release the Hologres Agent instance.
Days Remaining
The number of days until the subscription expires. Click Renew to go to the renewal page and extend the subscription period.
Auto-Renewal
Whether auto-renewal is enabled. Click Enable Auto-Renewal or Disable Auto-renewal to toggle this setting. The link redirects you to the renewal management page.
Region
The region where Hologres Agent is deployed. This must match the region of your Hologres instances.
Start Time
The time when the Hologres Agent instance was activated.
End Time
The time when the current subscription expires.
Use Hologres Agent
To open the Hologres Agent chat panel from any page in the Hologres console, click the Hologres AI Assistant link in the upper part of the page.
Below the input box, the chat panel shows scenario templates. Click a template to fill the matching command into the input box, complete the target instance, time range, and other prompted values, and then send it. Templates are grouped into the following four categories. Use the category tabs to filter them, or click View all to browse all 15 templates.
Category | Scenario templates |
Instance operations | CPU diagnostics, Slow SQL analysis, Write task diagnosis, Memory usage diagnostics, Operations report, and Table governance. |
Product guidance | Hologres Agent capabilities, How to accelerate a data lake, and Introduction to Hologres vector search. |
Warehouse development | Create a Dynamic Table task, Create a multimodal processing job, and MaxCompute import. |
Data analysis | Multimodal data search analysis, Query data metrics, and Interpret data trends. |
Diagnostic templates generate a parameterized command. For example, CPU diagnostics requires a target instance and a diagnostic time range. Slow SQL analysis supports two modes: by time range and by Query ID. The time range mode requires a target instance and a time range, and the Query ID mode requires a target instance and a Query ID.
Instead of using a scenario template, you can also type questions directly in the input box for free-form conversations with Hologres Agent. You can also use Hologres Agent through HoloWeb.
Each feature has its own permission requirements. For more information, see Permissions. You must grant the required permissions in the RAM console before you can use diagnostic features. Otherwise, the diagnostic request fails.
Quick start
Shortcuts: Enter
/to choose a skill that the agent supports. Enter@to choose an instance in the current region for a conversation or diagnostics.Scenario templates: 15 built-in templates are grouped into Instance operations, Product guidance, Warehouse development, and Data analysis. Pick the one that matches your task, or talk to the agent in natural language without using a template. For the full list, see the scenario template table above.
The input box also provides the Sandbox, Auto, Deep thinking, and Full Access switches. Enable them as needed.
Execution history
In the upper-left corner of the chat panel, click the menu button and select Conversation history to view your past conversations, which are retained for 7 days by default. Each user can view only their own session history, not the history of other accounts.
Scheduled tasks
You can create a scheduled task for an operations report so that the report is generated on schedule without manual triggering, and pushed to a DingTalk group through a DingTalk chatbot. Scheduled tasks are currently supported only for operations reports.
In the upper-left corner of the chat panel, click the menu button and select Scheduled tasks. Then click New task and configure the following parameters.
Parameter | Description |
Task type | Only operations reports are supported. |
Hologres instance | The instance for which the operations report is generated. |
Task name | A custom name of up to 50 characters. |
Executor | The account that runs the scheduled task. |
Frequency | The execution cycle. Daily, weekly, and monthly are supported. |
Run time | The time when the task runs. You can select any half-hour slot from 00:00 to 23:30, such as 09:00. |
Report language | The language of the generated report. Chinese and English are supported. |
Notification channels | Select DingTalk and enter the webhook URL of a DingTalk chatbot. The report is pushed to the corresponding DingTalk group after it is generated. Note A DingTalk custom chatbot enforces security settings. If you use the custom keyword method, add a keyword such as operations report or Hologres to the keyword list of the chatbot. Otherwise, messages are blocked and the push fails. |
Monitor token usage
Below the basic information section, the Usage Consumption area displays your Hologres Agent token usage statistics. The Last Calculation Time is shown in the upper-right corner along with a refresh button.
You can switch between two views:
Summary: Displays three cards showing token consumption over different time ranges:
Card
Description
Yesterday's Usage
The total number of tokens consumed on the previous day.
Weekly Usage
The total number of tokens consumed in the last 7 days.
Last Month's Usage
The total number of tokens consumed in the last 30 days.
Details: Displays a table of individual request records. You can filter records by selecting Request ID or User ID from the drop-down list and entering a search value. The table contains the following columns:
Column
Sortable
Request ID
No
User ID
No
Start Time
Yes
End Time
Yes
Enter a Token
Yes
Output Token
Yes
Total Tokens
Yes
The table supports pagination with 10, 20, or 50 records per page.
Permissions
Hologres Agent requires different permissions on different pages, as described in the following sections.
Permission for managing Hologres Agent
The AliyunHologresFullAccess policy is required to purchase, renew, and release Hologres Agent.
Permissions for diagnostic capabilities
CPU diagnostics, memory diagnostics, and slow SQL analysis rely on monitoring data, the instance's slow SQL log, and metadata tables such as Table Info. The following permissions are required:
HoloRAM permission: AliyunHologresReadOnlyAccess or AliyunHologresFullAccess. The following is a minimal-permission example:
{ "Version": "1", "Statement": [ { "Effect": "Allow", "Action": [ "hologram:GetInstance", "hologram:GetExecuteStatementEnabled", "hologram:EnableExecuteStatement", "hologram:ListDatabases", "hologram:ListWarehouses", "hologram:ExecuteStatement" ], "Resource": "*" }, { "Effect": "Allow", "Action": [ "cms:DescribeMetricList" ], "Resource": "*" } ] }Hologres instance permission: Hologres Agent supports only Alibaba Cloud account and RAM user authentication for instance access; Basic accounts are not supported. The account must have connection permission and slow SQL log access. The
pg_read_all_statsrole or Superuser privileges are sufficient to view all slow SQL and Table Info records in the instance. For more information, see Prerequisites.CloudMonitor RAM permission: AliyunCloudMonitorFullAccess (full access to CloudMonitor) or AliyunCloudMonitorReadOnlyAccess (read-only access to CloudMonitor).
If any of the above permissions is missing, the corresponding feature is unavailable.
Chat history
Each user can view only their own chat history and cannot see the history of other accounts.
Operations reports
By default, each user can view only the operations reports that they generated. To let other users view a report, share it from the Files and sharing entry.
FAQ
Q: Can Hologres Agent access my business data?
A: It depends on the capability area. Product consulting answers only from documentation and the knowledge base, and does not connect to an instance. Instance operations diagnostics read only monitoring data, slow SQL logs, Table Info, and similar metadata. Data warehouse development and data analysis connect to an instance and run SQL, so they access business data within the scope that you authorize. All operations run as the currently logged-on user, never exceed the permissions of that account, and do not modify or transfer your data.
Q: Why is an answer sometimes inaccurate?
A: Provide more context, such as the table schema and the exact error message, so that the model can interpret your question more accurately.
Q: Does Hologres Agent affect instance performance?
A: Instance operations diagnostics read only monitoring data and metadata, and have almost no impact on query performance. Data warehouse development and data analysis run SQL on the instance and consume compute resources. Run heavy analysis tasks during off-peak hours, or let the agent connect to a read-only secondary instance or a separate virtual warehouse to reduce the impact on the instance.