northseadl/norix-skills / adb-mysql
adb-mysql
Verified阿里云 AnalyticDB (ADB) for MySQL 只读数据分析。 多维分析(计数/聚合/时间序列)、交叉验证、Schema 文档生成、多 Profile。
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 3.1 KB |
| adbexecutable | script | 1.5 KB |
| agents/openai.yaml | config | 199 B |
| scripts/adb_core.py | script | 12.3 KB |
| scripts/analyze.py | script | 4.6 KB |
| scripts/config.py | script | 4.5 KB |
| scripts/credential_store.py | script | 9.1 KB |
| scripts/query.py | script | 1.4 KB |
| scripts/schema.py | script | 7.4 KB |
#!/usr/bin/env bash
# adb — Unified CLI for ADB Analytics
# Usage: ./adb <module> <command> [options]
#
# Modules:
# config Connection profile management
# query Read-only SQL execution
# analyze Data analysis with cross-validation
# schema Schema documentation generator
set -euo pipefail
SCRIPT_DIR="$(cd "$(dirname "$0")/scripts" && pwd)"
module="${1:-help}"; shift 2>/dev/null || true
case "$module" in
config)
python3 "$SCRIPT_DIR/config.py" "$@"
;;
query)
python3 "$SCRIPT_DIR/query.py" "$@"
;;
analyze)
python3 "$SCRIPT_DIR/analyze.py" "$@"
;;
schema)
python3 "$SCRIPT_DIR/schema.py" "$@"
;;
help|--help|-h)
echo "ADB Analytics — AnalyticDB for MySQL 数据分析技能"
echo ""
echo "用法: ./adb <module> [command] [options]"
echo ""
echo "模块:"
echo " config 连接配置管理 (add|list|use|test|remove|clean)"
echo " query SQL 查询 (只读,自动限制 200 条)"
echo " analyze 数据分析 (计数|聚合|时间序列 + 交叉验证)"
echo " schema Schema 文档生成"
echo ""
echo "快速开始:"
echo " pip install pymysql"
echo " ./adb config add prod --host xxx.dms.aliyuncs.com --user id --password secret --database mydb --test"
echo " ./adb query \"SELECT * FROM users LIMIT 10\""
echo " ./adb analyze -t orders -c"
echo " ./adb schema mydb"
;;
*)
echo "未知模块: $module"
echo "运行 ./adb help 查看可用模块"
exit 1
;;
esac
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |