The PolarDB AI Assistant is an intelligent operations tool for PolarDB for PostgreSQL and . Built on large language models (LLMs) and an expert knowledge base, it integrates three core capabilities: Intelligent Q&A, Intelligent Diagnostics, and Intelligent Awareness. The AI Assistant supports natural language interaction, proactively detects cluster anomalies, and provides root cause analysis and optimization suggestions. It uses RAM access control to ensure the security of your clusters and data during intelligent operations, which significantly reduces the learning curve and operational complexity of PolarDB for PostgreSQL and .
Core capabilities
Intelligent Q&AQuery metadata and performance metrics across multiple clusters by using natural language to perform batch resource lookups and diagnose issues. | Intelligent DiagnosticsAn entry point for the AI Assistant is integrated into pages such as Slow SQL Query and Parameters to provide real-time, context-aware diagnosis and interpretation. | Intelligent AwarenessAutomatically identifies cluster anomalies, such as CPU or traffic spikes, and notifies you through event pushes while offering AI diagnostic services. | Intelligent Inspection Task (Professional Edition)Supports one-click and scheduled health inspections for multiple clusters under your account. |
AI Assistant editions
The PolarDB AI Assistant offers a free Standard Edition and a more powerful Professional Edition. You can choose the edition that best fits your business needs.
Item | Standard Edition | Professional Edition |
Scope | PolarDB for PostgreSQL and clusters | |
Core functions | Supports functions such as Intelligent Q&A and diagnostics for all your clusters in the console. | |
Pricing | Free | Paid |
Advanced features | Not supported |
|
Task concurrency | 1 (not scalable) |
|
API call limit | Not supported |
|
Service Level Agreement (SLA) | Not provided | ≥99.9% with dedicated technical support. |
Accessing the AI Assistant
Log on to the PolarDB console. In the Clusters, click the AI Assistant icon on the far-right sidebar to open the chat interface.
Standard Edition: When a RAM user accesses the assistant, ensure that the user has the
AliyunPolardbReadOnlyAccessandAliyunYaoChiAgentAccesspermissions. For instructions, see Grant permissions to a RAM user.Professional Edition: For RAM user access, ensure that the AliyunServiceRolePolicyForPolarDBAgent service-linked role has been created. To create the role, see service-linked role.
Intelligent Q&A
The Intelligent Q&A feature allows you to use natural language to quickly query cluster information, analyze performance, and ask product-related questions. This eliminates the need to navigate between multiple pages for information.
Scenario | Question | Example |
Quickly query cluster information | Help me find all PolarDB clusters in the China (Beijing) region. | The AI Assistant returns a list of matching clusters with key information such as cluster ID, name, and status. |
Diagnose cluster performance issues | Does cluster | The AI Assistant automatically analyzes key metrics such as CPU, memory, and connections, and provides a diagnosis and optimization suggestions. |
Ask about product knowledge | What is read/write splitting? | Based on the product knowledge base, the AI Assistant provides a detailed explanation of the technical concept and its usage. |
Intelligent Diagnostics
The Intelligent Diagnostics feature is deeply integrated into key operations pages in the PolarDB console. It uses the current page context, such as a slow log entry or a failover event, to provide targeted root cause analysis and optimization suggestions.
Scenario | Solution | Description |
Analyze and optimize slow logs | On the Slow Log Details tab of the page, if you find a long-running SQL statement, you can click the PolarDB AI Analysis button in the upper-right corner or the AI Assistant icon in the Actions column to perform a one-click deep analysis. | The AI Assistant analyzes the SQL execution plan and index usage, and provides specific optimization suggestions. |
Evaluate kernel parameters | When you need to adjust a kernel parameter on the page, you can use the AI Assistant to understand its function and the potential impact of changes. | The AI Assistant explains the parameter's purpose, value range, and recommended changes to reduce the risk of misconfiguration. |
Intelligent Awareness
The PolarDB AI Assistant can automatically identify cluster anomalies, such as CPU or traffic spikes. It notifies you through event pushes and provides AI diagnostic services.
Intelligent Inspection Task (Professional Edition)
After you activate the Professional Edition, the PolarDB AI Assistant supports one-click and scheduled health inspections for multiple clusters under your account.
Create an inspection task: Click the Create Inspection Task button, select the Inspection Instances, and set the Inspection Frequency to perform scheduled health inspections on multiple clusters.
View inspection reports: Click View Report to the right of a task to view the report for each cluster.
Billing
Standard Edition: Free.
Professional Edition: Consists of a base fee and optional fees for AI Capacity Packs.
Base fee: CNY 6,000/month.
AI Capacity Pack fee: CNY 10,000 per pack per month. You can purchase up to five packs.
AI Capacity Pack
For the Professional Edition, you can purchase an AI Capacity Pack to improve operational efficiency. The AI Capacity Pack is primarily used to increase task concurrency, which significantly reduces the time required for batch O&M tasks, such as one-click inspections, and removes the API call limit.
Task concurrency refers to the number of analysis or diagnostic tasks that the AI Assistant can process simultaneously. For example, to perform a bulk inspection on 100 clusters, a concurrency of 5 requires 20 batches. If the concurrency is increased to 55, the task can be completed in just 2 batches.
The following table shows the efficiency gains from different numbers of AI Capacity Packs when you manage 100 PolarDB for PostgreSQL or clusters.
AI capacity packs | Task concurrency | Bulk inspection time | API call limit |
0 (default) | 5 | Approx. 60 minutes | 100 calls/day |
1 | 15 | Approx. 20 minutes | Unlimited |
2 | 25 | Approx. 12 minutes | Unlimited |
3 | 35 | Approx. 8 minutes | Unlimited |
4 | 45 | Approx. 6 minutes | Unlimited |
5 (maximum) | 55 | Approx. 5 minutes | Unlimited |
Security and compliance
Data access scope: To provide accurate diagnostics and answers, the PolarDB AI Assistant accesses your cluster metadata, performance metrics, log files, and the questions that you enter in the chat interface. It does not execute any DDL or DML statements or directly modify your cluster configuration.
Data privacy: Your query history and cluster data are handled in strict accordance with Alibaba Cloud's privacy policies. Your data is not used for model training or sent to any third party.
Disclaimer: All diagnostic conclusions and optimization suggestions provided by the PolarDB AI Assistant, especially those related to SQL statements and parameter modifications, are for reference only. A professional Database Administrator (DBA) or technical personnel must thoroughly review and assess all changes before you apply them to a production environment.