# alibabacloud-polardb-ai-assistant

alibabacloud-polardb-ai-assistant — a skill for analyzing and managing Alibaba Cloud PolarDB clusters. Diagnose performance issues, review parameters, parse logs, and plan upgrades without switching to the console.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 216 installs · ★ 300 repo stars
- Author: aliyun
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/aliyun/alibabacloud-aiops-skills/tree/HEAD/skills/database/polardb/alibabacloud-polardb-ai-assistant/SKILL.md
- Updated: 2026-10-23
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/alibabacloud-polardb-ai-assistant

## What it does

This skill connects to the Yaochi Agent v2 backend through the Aliyun CLI and lets you query PolarDB cluster status, inspect resources (CPU, memory, storage), examine active sessions, and detect locking issues. It explains database parameters, assesses the impact of changing them, analyzes error and slow-query logs, and provides guidance on backups, security, and disaster recovery.

Setup requires Aliyun CLI version 3.3.3 or later, the `aliyun-cli-das` plugin, and `jq` for parsing JSON responses. The skill handles both MySQL and PostgreSQL flavors of PolarDB. This is a PolarDB-specific tool—use it only for PolarDB workloads, not other Alibaba Cloud databases.

## Requirements
- Works with: PostgreSQL

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-polardb-ai-assistant -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/alibabacloud-polardb-ai-assistant/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/alibabacloud-polardb-ai-assistant/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-polardb-ai-assistant -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/alibabacloud-polardb-ai-assistant/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-polardb-ai-assistant -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/alibabacloud-polardb-ai-assistant/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install aliyun/alibabacloud-aiops-skills skills/database/polardb/alibabacloud-polardb-ai-assistant
```

2. **Manually: put the files in place**
- File: `.github/skills/alibabacloud-polardb-ai-assistant/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-polardb-ai-assistant -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/aliyun/alibabacloud-aiops-skills --path skills/database/polardb/alibabacloud-polardb-ai-assistant
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/alibabacloud-polardb-ai-assistant/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add aliyun/alibabacloud-aiops-skills --skill alibabacloud-polardb-ai-assistant -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/aliyun/alibabacloud-aiops-skills/tree/HEAD/skills/database/polardb/alibabacloud-polardb-ai-assistant/SKILL.md

## When to use it
- check node health and PolarDB cluster status
- identify slow queries and performance bottlenecks
- understand what a database parameter controls and whether it is safe to modify
- investigate why a cluster switched from primary to standby
- evaluate kernel or proxy upgrade readiness based on fixed issues

## Example prompts
- What is the status of cluster pc-abc123xyz and are there any node problems?
- Show me the top slow queries in my database over the last hour
- What does the `max_connections` parameter do and how do I change it safely?

## Similar
- [creating-amazon-aurora-db-cluster-with-instances](https://affpapa.org/en/nevibecode/skills/creating-amazon-aurora-db-cluster-with-instances.md) — skill · 6800 installs
- [amazon-aurora-postgresql](https://affpapa.org/en/nevibecode/skills/amazon-aurora-postgresql.md) — skill · 6500 installs
- [huawei-cloud-dws-io-diag](https://affpapa.org/en/nevibecode/skills/huawei-cloud-dws-io-diag.md) — skill · 180 installs
- [render-postgres](https://affpapa.org/en/nevibecode/skills/render-postgres.md) — skill · 455 installs
- [bigquery-migration-metadata-extractor](https://affpapa.org/en/nevibecode/skills/bigquery-migration-metadata-extractor.md) — skill · ★ 24522 repo stars
- [relational-database-mcp-cloudbase](https://affpapa.org/en/nevibecode/skills/relational-database-mcp-cloudbase.md) — skill · 962 installs

From the same set: [aliyun/alibabacloud-aiops-skills](https://affpapa.org/en/nevibecode/by/aliyun/alibabacloud-aiops-skills.md) — 66 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
