adb-mysql

Name: adb-mysql
Availability: InStock
Author: Northseadl

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

6|1|Updated Feb 26, 2026

Search Tags:#data-analysis #mysql #read-only #analyticdb #schema-docs #multi-profile

Ready to run

npx skills add https://github.com/northseadl/norix-skills --skill adb-mysql

💬 Prompt for ChatGPT / Claude Chat▼

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.