adb-mysql

Query AnalyticDB MySQL read-only across tables and generate schema documentation.

6|1|Updated Feb 26, 2026
One-click install
npx skills add https://github.com/northseadl/norix-skills --skill adb-mysql
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: adb-mysql
Source: https://github.com/northseadl/norix-skills/tree/main/adb-mysql
Command: npx skills add https://github.com/northseadl/norix-skills --skill adb-mysql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pymysql, and includes scripts (resource) components.

What problem does it solve?

ADB 数据分析技能提供对 AnalyticDB (ADB) for MySQL 的只读数据分析能力,帮助从多维数据中快速获取计数、聚合与时间序列信息,并自动生成表结构文档与多 Profile 配置支持。

Core Features & Use Cases

  • 只读分析:安全地执行 SELECT 查询并限制返回行数,避免对生产环境造成影响。
  • 分析与文档生成:支持跨表统计、时间序列分析,以及基于 information_schema 的 Schema 文档生成。
  • 多 Profile 支持与自动化工作流:通过本地配置文件管理多连接,并提供快速测试和清理能力。

Quick Start

Run a sample query against your AnalyticDB instance to verify the setup.

Frequently Asked Questions about adb-mysql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run read-only analytics on AnalyticDB MySQL?

Read-only analytics on AnalyticDB MySQL securely executes SELECT queries with enforced row limits. It validates results across multiple tables and enforces credential handling to prevent production impact.

Can I generate schema documentation automatically from AnalyticDB MySQL?

Yes, automatic schema documentation is generated by querying information_schema. It extracts table structures across databases to build comprehensive multi-profile schema docs for cross-table analysis.

Does this Skill support managing multiple AnalyticDB MySQL connections?

Yes, multiple AnalyticDB MySQL connections are supported through multi-profile configuration. It manages multiple local connection profiles to enable cross-database analysis and quick testing workflows.

What are the limitations of using pymysql for AnalyticDB read-only queries?

Using pymysql for AnalyticDB read-only queries limits operations strictly to SELECT statements with enforced row limits. It restricts write operations and requires careful credential handling for secure access.