skills.rest
yuezhen-huang
yuezhen-huangCOMMUNITY
Explore all skills by this author →
GitHub

rds

Execute SQL queries on RDS databases via RDS-OG gateway or DataQ across regions.

Updated Apr 30, 2026
Search Tags:#sql#mysql#rds#database query#multi-region#dataq#vregion
One-click install
npx skills add https://github.com/yuezhen-huang/my-bytedance-skillhub --skill rds-yuezhen-huang
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: rds
Source: https://github.com/yuezhen-huang/my-bytedance-skillhub/tree/main/rds
Command: npx skills add https://github.com/yuezhen-huang/my-bytedance-skillhub --skill rds-yuezhen-huang

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Running SQL against RDS databases spread across many regions and environments (Singapore, US, China, BOE, TTP, NonTT) normally requires knowing different gateways, credentials, and endpoints. This Skill routes a single SQL query to the correct backend automatically. ## Core Features & Use Cases - Multi-region SQL execution: Run SELECT/SHOW queries against RDS databases in standard, BOE, TTP, and NonTT environments through one interface. - Automatic backend routing: Chooses between RDS-OG cloud gateways and DataQ based on the VRegion or VDC name provided, including direct VDC input like be2a. - Volcano RDS detection: For BOE environments, automatically detects Volcano Engine RDS and uses the asynchronous DBW execution flow. - Use Case: A developer needs to verify rows in a TTP database and a Singapore production database; they run the same command with different vregion values and get structured JSON results. ## Quick Start Ask the agent to run a SQL query such as SELECT * FROM users LIMIT 10 against your database name, optionally specifying a region like sg, cn, ttp, or a VDC like be2a.

Frequently Asked Questions about rds

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

FAQPage Schema
How do I run a SQL query on an RDS database?▼

Provide the database name and SQL statement via gdpa-cli run rds with db_name and dql parameters. The query defaults to the Singapore-Central region through the RDS-OG gateway, and results return as structured JSON rows.

How do I query an RDS database in a specific region or VDC?▼

Set the vregion parameter to a region alias like sg, us, cn, boe, or ttp, or pass a VDC name directly such as be2a or bdsgdt. The agent automatically routes to the correct gateway for that region.

Does RDS querying support TTP and NonTT environments?▼

Yes. TTP regions like US-TTP and EU-TTP2 route through DataQ, while NonTT regions and VDCs route through cloud.byteintl.net. The dbpsm parameter is ignored for DataQ queries.

Why does my RDS query fail with an invalid vregion error?▼

The vregion value must match a supported VRegion alias or VDC name from the routing tables. Check the supported list, verify spelling, and ensure you are authenticated with gdpa-cli login before retrying.

What are the limitations when querying RDS with SQL?▼

Only the run_sql action is supported, so queries should be read-oriented statements like SELECT or SHOW. Always use LIMIT to avoid excessive data, and keep queries simple since large queries may time out.

Related Skills

Explore More Software Engineering Skills→
treasure-datatreasure-data
21

aps-doc-master-segment

Extract CDP Master Segment schema data and generate Markdown documentation.

Official
Advanced
IeerIeer
1

postgresql

Query PostgreSQL with read-only SQL, parameterized queries, and row limits.

Community
Advanced
awslabsawslabs
15

observability

Design AWS observability solutions with CloudWatch metrics, logs, alarms, and X-Ray tracing.

Official
Advanced
costrict-plugins-repocostrict-plugins-repo

netlify-database

Provision and query managed Postgres on Netlify with migrations, Drizzle ORM, and deploy-preview branches.

Official
Advanced