Alibabacloud Adb Mysql Mcp Server

database MCP Server

AnalyticDB for MySQL MCP Server

7 views31 stars20 forksApache-2.0

Why This Matters

Discovered via unknown and last synced 3mo ago.

Source
unknown
Stars
31
Last synced
3mo ago
Install
Check source

Install

Install instructions not detected yet

Check the source repository for the latest setup steps.

View source instructions
46
Tools
0
Resources
0
Prompts
Standard I/O
Transport

Available Tools (46)

ALIBABA_CLOUD_ACCESS_KEY_ID

Yes (OpenAPI tools)

ADB_API_CONNECT_TIMEOUT

No

describe_accounts

List database accounts in a cluster

describe_sql_patterns

Query SQL pattern list

describe_worker_detection

Storage node diagnostics

ALIBABA_CLOUD_ACCESS_KEY_SECRET

Yes (OpenAPI tools)

ADB_API_READ_TIMEOUT

No

describe_cluster_net_info

Get cluster network connection info

describe_table_statistics

Query table-level statistics

describe_controller_detection

Access node diagnostics

execute_sql

Execute SQL on an ADB MySQL cluster

ALIBABA_CLOUD_SECURITY_TOKEN

No

SERVER_TRANSPORT

No

get_current_time

Get current server time

describe_available_advices

Get optimization advices

get_query_plan

Get EXPLAIN execution plan

ADB_MYSQL_HOST

No

SERVER_PORT

No

create_account

Create a database account

kill_process

Kill a running query process

get_execution_plan

Get EXPLAIN ANALYZE actual execution plan

ADB_MYSQL_PORT

No

Tool

Description

describe_db_cluster_performance

Query cluster performance metrics (CPU, memory, QPS, etc.)

modify_db_cluster_description

Modify cluster description

describe_db_resource_group

Get resource group configuration

ADB_MYSQL_USER

No

describe_db_clusters

List ADB MySQL clusters in a region

describe_db_cluster_health_status

Query cluster health status

describe_db_cluster_space_summary

Get cluster storage space summary

describe_excessive_primary_keys

Detect tables with excessive primary keys

ADB_MYSQL_PASSWORD

No

describe_db_cluster_attribute

Get detailed cluster attributes

describe_diagnosis_records

Query SQL diagnosis summary records

describe_audit_log_records

Query SQL audit log records

describe_oversize_non_partition_table_infos

Detect oversized non-partition tables

ADB_MYSQL_DATABASE

No

describe_cluster_access_whitelist

Get cluster IP whitelist

describe_diagnosis_sql_info

Get SQL execution details (plan, runtime info)

describe_table_partition_diagnose

Diagnose table partitioning issues

Variable

Required

ADB_MYSQL_CONNECT_TIMEOUT

No

modify_cluster_access_whitelist

Modify cluster IP whitelist

describe_bad_sql_detection

Detect bad SQL impacting cluster stability

describe_executor_detection

Compute node diagnostics

describe_inclined_tables

Detect data-skewed tables

Works Well With - Skills