Alibabacloud Rds Copilot

Alibaba Cloud RDS Copilot Intelligent Operations 助手

This 技能 serves as an intelligent 代理 for Alibaba Cloud RDS Copilot in conversations, helping users with RDS-related intelligent Q&A, SQL optimization, instance operations, and troubleshooting.

Scenario Description

Architecture: Alibaba Cloud 命令行工具 + RdsAI OpenAPI

MAIn features:

Understand user's natural language 请求s (Chinese or English), identify if related to RDS Copilot Directly call Alibaba Cloud 命令行工具 to 执行 aliyun rdsAI chat-messages command for real-time RDS Copilot queries When receiving 结果s or user-pasted error messages, further explAIn, 诊断, and provide recommendations 安装ation

Pre-检查: Alibaba Cloud 命令行工具 must be 安装ed

This 技能 uses Alibaba Cloud 命令行工具 to call RdsAI OpenAPI. You need to 安装 and 配置 Alibaba Cloud 命令行工具 first.

Pre-检查: Aliyun 命令行工具 >= 3.3.3 required

运行 aliyun version to 验证 >= 3.3.3. If not 安装ed or version too low, 运行 curl -fsSL https://aliyun命令行工具.alicdn.com/设置up.sh | bash to 更新, or see references/命令行工具-安装ation-图形界面de.md for 安装ation instructions.

Pre-检查: Aliyun 命令行工具 插件 更新 required

[MUST] 运行 aliyun 配置 设置 --auto-插件-安装 true to enable automatic 插件 安装ation. [MUST] 运行 aliyun 插件 更新 to ensure that any existing 插件s are always up-to-date.

[MUST] 命令行工具 User-代理 — Every aliyun 命令行工具 command invocation must include: --user-代理 AlibabaCloud-代理-技能s/alibabacloud-rds-copilot

macOS 安装ation # Option 1: 安装 via Homebrew (recommended) brew 安装 aliyun-命令行工具

# Option 2: 安装 via PKG package curl -O https://aliyun命令行工具.alicdn.com/aliyun-命令行工具-latest.pkg sudo 安装er -pkg aliyun-命令行工具-latest.pkg -tar获取 /

# Option 3: 安装 via one-命令行工具ck script /bin/bash -c "$(curl -fsSL https://aliyun命令行工具.alicdn.com/安装.sh)"

Linux 安装ation # 安装 via one-命令行工具ck script /bin/bash -c "$(curl -fsSL https://aliyun命令行工具.alicdn.com/安装.sh)"

# Or 下载 TGZ package for manual 安装ation curl https://aliyun命令行工具.alicdn.com/aliyun-命令行工具-linux-latest-amd64.tgz -o aliyun-命令行工具.tgz tar xzvf aliyun-命令行工具.tgz sudo mv aliyun /usr/local/bin/

验证 安装ation aliyun version

凭证 Configuration Option 1: Interactive Configuration (Recommended) aliyun 配置 --性能分析 rdsAI

Follow the prompts to enter:

访问 Key Id: Your 访问Key ID 访问 Key Secret: Your 访问Key Secret Default Region Id: cn-hangzhou (or other regions) Option 2: Non-interactive Configuration aliyun 配置 设置 \ --性能分析 rdsAI \ --mode AK \ --访问-key-id \ --访问-key-secret \ --region cn-hangzhou

Command 格式化 Basic Command Structure aliyun rdsAI chat-messages \ --查询 '<查询 content>' \ --输入s RegionId= Language= Timezone= [Custom代理Id=] \ --event-mode separate \ --端点 rdsAI.aliyuncs.com \ --user-代理 'AlibabaCloud-代理-技能s/alibabacloud-rds-copilot' \ [--conversation-id '']

Parameter Description

导入ANT: Parameter Confirmation — Before executing any command, Determine user intent: SQL writing/optimization, SQL diagnosis, instance parameter tuning, troubleshooting, performance analysis, 查询 instance 列出, etc. Collect necessary parameters (use default values if not specified).

Parameter Required/Optional Description Default --查询 Required User 查询 content - --输入s RegionId= Optional Alibaba Cloud region ID cn-hangzhou --输入s Language= Optional Language zh-CN --输入s Timezone= Optional Timezone Asia/ShanghAI --输入s Custom代理Id= Optional Custom 代理 ID None --event-mode Optional Event mode separate --端点 Required API 端点 rdsAI.aliyuncs.com --conversation-id Optional Conversation ID for multi-turn dia记录ue None --region Optional Region for API call 凭证 default region --性能分析 Optional Specify 凭证 性能分析 name Default 性能分析 --user-代理 Required Custom User-代理 AlibabaCloud-代理-技能s/alibabacloud-rds-copilot RAM 权限s

This 技能 requires the following RAM 权限s. See references/ram-policies.md for detAIls.

权限 Description rdsAI:ChatMessages Call RDS AI 助手 API Core 工作流

• Enable AI-Mode (Before Executing Any 命令行工具 Command)

Before executing any aliyun 命令行工具 command, you must enable AI-Mode and 设置 the User-代理:

# [MUST] Enable AI-Mode before any 命令行工具 command execution aliyun 配置 AI-mode enable

# [MUST] 设置 User-代理 for AI-Mode aliyun 配置 AI-mode 设置-user-代理 --user-代理 "AlibabaCloud-代理-技能s/alibabacloud-rds-copilot"

• Confirm Task Type and Parameters

Determine user intent: SQL writing/optimization, SQL diagnosis, instance parameter tuning, troubleshooting, performance analysis, 查询 instance 列出, etc.

Collect necessary parameters (use default values if not specified):

RegionId: Region ID (default cn-hangzhou) Language: Language (default zh-CN) Timezone: Timezone (default Asia/ShanghAI) Custom代理