Tidbcloud Skills Tidb Zero

TiDB Zero (Temporary / Playground Database)

Goal

Create a temporary/playground TiDB database via one HTTP API.

Setup (env + tools)

Required env:

• TIDBZERO_HOST: API host (no auth)

Optional env:

• TIDBZERO_BASE_PATH (default /v1alpha1)
• TIDB0_NAME_PREFIX (optional)
• TIDB0_DB_PASSWORD (optional)

Timeout env:

• TIDB0_CURL_CONNECT_TIMEOUT (default 10)
• TIDB0_CURL_MAX_TIME (default 60)

Prereqs:

• HTTP: curl (and optionally jq for pretty-print)
• SQL: mysqlsh (preferred) or mysql

API: Create a temporary database (playground-like)

Base URL:

BASE="https://${TIDBZERO_HOST}${TIDBZERO_BASE_PATH:-/v1alpha1}"

Request body (optional: namePrefix, password):

body='{"namePrefix":"'"${TIDB0_NAME_PREFIX:-}"'"}'

If you want to set a password (optional):

body='{"namePrefix":"'"${TIDB0_NAME_PREFIX:-}"'","password":"'"${TIDB0_DB_PASSWORD}"'"}'

Call (current spec uses POST /instances):

curl -sS -X POST \
  -H 'content-type: application/json' \
  --connect-timeout "${TIDB0_CURL_CONNECT_TIMEOUT:-10}" \
  --max-time "${TIDB0_CURL_MAX_TIME:-60}" \
  --data-binary "$body" \
  "${BASE}/instances"

If you want pretty JSON (optional jq):

curl -sS -X POST \
  -H 'content-type: application/json' \
  --connect-timeout "${TIDB0_CURL_CONNECT_TIMEOUT:-10}" \
  --max-time "${TIDB0_CURL_MAX_TIME:-60}" \
  --data-binary "$body" \
  "${BASE}/instances" | jq .

On success, ALWAYS explicitly print these fields to the user (in addition to the full JSON response):

• id, name, expiresAt, remainingDatabaseQuota
• connection.host, connection.port, connection.username, connection.password

Follow-up: Run SQL on the created database

Use returned connection.

mysqlsh (preferred; password via stdin). In sandboxed environments, set MYSQLSH_USER_CONFIG_HOME to a writable directory:

mkdir -p /tmp/mysqlsh-codex
printf '%s' '<connection.password>' | MYSQLSH_USER_CONFIG_HOME=/tmp/mysqlsh-codex mysqlsh --sql \
  --host '<connection.host>' --port '<connection.port>' --user '<connection.username>' \
  --passwords-from-stdin \
  --execute "SELECT 1;"

mysql fallback:

MYSQL_PWD='<connection.password>' mysql \
  -h '<connection.host>' -P '<connection.port>' -u '<connection.username>' \
  -e "SELECT 1;"

Converted and distributed by TomeVault — claim your Tome and manage your conversions.