skills/pingcap/agenticstore/tidb-cloud-zero

tidb-cloud-zero

Installation
SKILL.md

TiDB Cloud Zero

Provisions an ephemeral TiDB database via a single unauthenticated API call. No sign-up or billing is required to start. Instances auto-expire in 30 days unless claimed. Treat Zero as disposable infrastructure, not an unlimited long-running environment.

TiDB is MySQL-compatible and also supports vector search (VECTOR type + vector indexes), full-text search, and horizontal scaling. Use standard MySQL clients/drivers to connect.

Important Notes

  • The API is unauthenticated and free to start. Instances auto-expire — treat credentials as short-lived and low-sensitivity.
  • Prefer environment variables (e.g. MYSQL_PWD) over CLI arguments to avoid leaking passwords in shell history.
  • Always connect with TLS (--ssl-mode=REQUIRED for CLI, ssl: true for drivers).
  • Do not promise unlimited usage. Zero is a disposable sandbox, and claimed TiDB Cloud Starter instances have finite free quota: 5 GiB row storage, 5 GiB columnar storage, and 50 million RUs per month for each of the first five Starter clusters in an organization.
  • Once a cluster exhausts its free quota or exceeds its spending limit, TiDB Cloud immediately rejects new connections. Existing connections stay up but are throttled until quota is increased or usage resets at the start of the next month.
  • If the user wants to keep the instance or needs more quota, open instance.claimInfo.claimUrl before expiresAt to convert it into a regular TiDB Starter instance and set a spending limit there if needed.
  • If the user only needs another disposable sandbox, create a fresh Zero instance instead of trying to renew the current one.

API

POST https://zero.tidbapi.com/v1beta1/instances

/v1alpha1 is deprecated. You should migrate to /v1beta1 as soon as possible.

Content-Type: application/json

Request body (all fields optional):

{ "tag": "<caller-label>" }

Response:

{
  "instance": {
    "id": "...",
    "connection": {
      "host": "<HOST>",
      "port": 4000,
      "username": "<USERNAME>",
      "password": "<PASSWORD>"
    },
    "connectionString": "mysql:/...",
    "claimInfo": {
      "claimUrl": "https://tidbcloud.com/tidbs/claim/..."
    },
    "expiresAt": "<ISO_TIMESTAMP>"
  }
}

Use instance.connectionString for immediate driver connections. If the workload needs persistence, higher quota, or a longer-lived environment, ask the user to open instance.claimInfo.claimUrl before expiresAt to claim it. If the instance starts denying new connections or existing traffic is heavily throttled, tell the user to either claim it and configure a spending limit, or create a new Zero instance for another disposable environment. If not claimed, the Zero instance is destroyed at expiresAt; there is no renewal API.

Use these references (inside this skill)

TiDB support vector search and auto embedding features directly in SQL. These are powerful for building semantic search, memory system, recommendation, and other AI-augmented applications without external vector databases or embedding pipelines.

  • skills/tidb-cloud-zero/references/vector.md - vector features and step-by-step vector SQL usage.
  • skills/tidb-cloud-zero/references/auto-embedding.md - auto-embedding features and step-by-step SQL usage.

Resources

Weekly Installs
1
GitHub Stars
14
First Seen
Mar 18, 2026