Back to Details

planetscale

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

PlanetScale Skill

PlanetScale Skill

Overview

概述

Enables Claude to access PlanetScale to view and manage serverless MySQL databases, database branches, deploy requests, and monitor query performance and usage.
让Claude能够访问PlanetScale，查看并管理无服务器MySQL数据库、数据库分支、部署请求，以及监控查询性能和使用情况。

Quick Install

快速安装

bash
curl -sSL https://canifi.com/skills/planetscale/install.sh | bash
Or manually:
bash
cp -r skills/planetscale ~/.canifi/skills/
bash
curl -sSL https://canifi.com/skills/planetscale/install.sh | bash
或者手动安装：
bash
cp -r skills/planetscale ~/.canifi/skills/

Setup

设置

Configure via canifi-env:
bash
undefined
通过canifi-env进行配置：
bash
undefined

First, ensure canifi-env is installed:

首先，请确保已安装canifi-env：

curl -sSL https://canifi.com/install.sh | bash

curl -sSL https://canifi.com/install.sh | bash

canifi-env set PLANETSCALE_EMAIL "your-email@example.com"
undefined
canifi-env set PLANETSCALE_EMAIL "your-email@example.com"
undefined

Privacy & Authentication

隐私与认证

Your credentials, your choice. Canifi LifeOS respects your privacy.
您的凭证，由您掌控。 Canifi LifeOS尊重您的隐私。

Option 1: Manual Browser Login (Recommended)

选项1：手动浏览器登录（推荐）

If you prefer not to share credentials with Claude Code:
  1. Complete the Browser Automation Setup using CDP mode
  2. Login to the service manually in the Playwright-controlled Chrome window
  3. Claude will use your authenticated session without ever seeing your password
如果您不想与Claude Code共享凭证：
  1. 使用CDP模式完成浏览器自动化设置
  2. 在Playwright控制的Chrome窗口中手动登录服务
  3. Claude将使用您的已认证会话，全程不会获取您的密码

Option 2: Environment Variables

选项2：环境变量

If you're comfortable sharing credentials, you can store them locally:
bash
canifi-env set SERVICE_EMAIL "your-email"
canifi-env set SERVICE_PASSWORD "your-password"
Note: Credentials stored in canifi-env are only accessible locally on your machine and are never transmitted.
如果您愿意共享凭证，可以将其存储在本地：
bash
canifi-env set SERVICE_EMAIL "your-email"
canifi-env set SERVICE_PASSWORD "your-password"
注意：存储在canifi-env中的凭证仅能在您的本地机器上访问，绝不会被传输至其他地方。

Capabilities

功能

  • View database status
  • Check branch topology
  • Monitor query insights
  • View deploy requests
  • Check connection strings
  • View billing and usage
  • 查看数据库状态
  • 检查分支拓扑结构
  • 监控查询洞察
  • 查看部署请求
  • 检查连接字符串
  • 查看账单与使用情况

Usage Examples

使用示例

Example 1: Check Databases

示例1：检查数据库

User: "How are my PlanetScale databases?"
Claude: I'll check your PlanetScale dashboard.
- Opens app.planetscale.com via Playwright MCP
- Logs into account
- Databases:
  - prod-db: Scaler Pro, 8GB storage
    - Branches: main, staging
    - Region: us-east-1
  - analytics-db: Scaler, 2GB storage
    - Branches: main
- All databases healthy
- No connection issues
用户：“我的PlanetScale数据库状态如何？”
Claude：我将查看您的PlanetScale仪表盘。
- 通过Playwright MCP打开app.planetscale.com
- 登录账户
- 数据库信息：
  - prod-db：Scaler Pro版，8GB存储空间
    - 分支：main, staging
    - 区域：us-east-1
  - analytics-db：Scaler版，2GB存储空间
    - 分支：main
- 所有数据库状态正常
- 无连接问题

Example 2: Check Branch Status

示例2：检查分支状态

User: "What branches do I have?"
Claude: I'll check database branches.
- Views prod-db detail
- Branches:
  - main (production): 8GB, 45k queries/day
  - staging: 500MB, 2k queries/day
  - feature-auth: 100MB, dev branch
- Deploy requests:
  - None pending
  - Last deploy: 2 days ago
- Schema: 24 tables
用户：“我有哪些数据库分支？”
Claude：我将检查数据库分支情况。
- 查看prod-db详情
- 分支信息：
  - main（生产环境）：8GB，每日45k次查询
  - staging：500MB，每日2k次查询
  - feature-auth：100MB，开发分支
- 部署请求：
  - 无待处理请求
  - 上次部署：2天前
- 架构：24张表

Example 3: View Insights

示例3：查看洞察信息

User: "Show me query performance"
Claude: I'll check Query Insights.
- Views Insights section
- Top queries (last 24h):
  - SELECT users: 12k calls, 2ms avg
  - SELECT orders: 8k calls, 5ms avg
  - INSERT events: 5k calls, 3ms avg
- Slow queries: 2 flagged
- Rows read: 2.4M
- Rows written: 45k
用户：“展示我的查询性能”
Claude：我将查看Query Insights（查询洞察）。
- 进入Insights板块
- 热门查询（过去24小时）：
  - SELECT users：12k次调用，平均2ms
  - SELECT orders：8k次调用，平均5ms
  - INSERT events：5k次调用，平均3ms
- 慢查询：2条被标记
- 读取行数：2.4M
- 写入行数：45k

Authentication Flow

认证流程

  1. Navigate to app.planetscale.com via Playwright MCP
  2. Enter email or use GitHub OAuth
  3. Enter password if email login
  4. Handle 2FA if enabled
  5. Select organization if multiple
  6. Maintain session for dashboard access
  1. 通过Playwright MCP导航至app.planetscale.com
  2. 输入邮箱或使用GitHub OAuth登录
  3. 若使用邮箱登录则输入密码
  4. 若启用2FA则完成验证
  5. 若有多个组织则选择对应组织
  6. 维持会话以访问仪表盘

Error Handling

错误处理

  • Login Failed: Retry credentials
  • 2FA Required: Complete verification
  • Connection Issue: Check credentials
  • Session Expired: Re-authenticate
  • Branch Conflict: Resolve deploy request
  • Quota Exceeded: Check plan limits
  • 登录失败：重试凭证
  • 需要2FA：完成验证
  • 连接问题：检查凭证
  • 会话过期：重新认证
  • 分支冲突：解决部署请求
  • 配额超限：查看套餐限制

Self-Improvement Instructions

自我改进说明

After each interaction:
  • Track query patterns
  • Note branch usage
  • Log storage growth
  • Document UI changes
Suggest updates when:
  • PlanetScale updates dashboard
  • New features added
  • Pricing changes
  • Query insights expand
每次交互后：
  • 追踪查询模式
  • 记录分支使用情况
  • 记录存储增长
  • 记录UI变更
在以下情况时建议更新：
  • PlanetScale更新仪表盘
  • 添加新功能
  • 定价变更
  • 查询洞察功能扩展

Notes

说明

  • Serverless MySQL
  • Git-like branching
  • Non-blocking schema changes
  • Vitess-powered
  • Automatic scaling
  • Connection pooling
  • MySQL compatible
  • 无服务器MySQL
  • 类Git分支机制
  • 无阻塞式架构变更
  • Vitess驱动
  • 自动扩容
  • 连接池
  • 兼容MySQL