A specialized tool for provisioning ephemeral, disposable TiDB Cloud Zero databases designed for automated agent workflows and rapid testing.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install zero
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install zero using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is TiDB Cloud Zero?
TiDB Cloud Zero provides developers with a streamlined way to create temporary, high-performance SQL environments without the overhead of manual setup or persistent storage management. This skill is optimized for Openclaw Skills users who require isolated database instances for technical previews, smoke testing, or transient agent data storage. By leveraging a simple API-first approach, it allows agents to spin up MySQL-compatible environments on demand.
As part of the Openclaw Skills ecosystem, this tool eliminates the need for a browser-based UI, focusing instead on CLI and API interactions. It provides a robust foundation for building data-driven AI applications that require secure, short-lived SQL backends that automatically expire after their task is complete.
TiDB Cloud Zero Use Cases
- Creating isolated SQL sandboxes for automated agent development and testing.
- Running deterministic SQL smoke tests within CI/CD pipelines.
- Providing temporary data persistence for Openclaw Skills workflows that require relational storage.
- Demonstrating database features in technical previews without long-term resource commitment.
- Scaffolding ephemeral backends for multi-agent collaboration sessions.
How TiDB Cloud Zero Works
- The agent triggers a POST request to the TiDB Cloud Zero v1alpha1 API endpoint.
- An optional tag is provided to identify and group the specific Openclaw Skills run.
- The API returns a JSON object containing host, port, credentials, and a full MySQL connection string.
- The agent saves these sensitive credentials locally to a secure file for session persistence.
- The database instance is used via any MySQL-compatible driver for the duration of its lifecycle.
- The instance is automatically decommissioned at the specified expiration timestamp unless manually converted to a permanent database.
TiDB Cloud Zero Setup
To provision a database instance using this skill, execute the following command in your terminal:
curl -s -X POST https://zero.tidbapi.com/v1alpha1/instances \
-H "Content-Type: application/json" \
-d '{"tag":"openclaw-run"}' \
| tee tidb-zero.json
You can then extract the connection string and test the health of the instance:
jq -r '.instance.connectionString // .connectionString' tidb-zero.json
# Use the output to connect
mysql "<connectionString>" -e "SELECT 1 AS health_check;"
TiDB Cloud Zero Data Schema & Taxonomy
The skill returns a structured response containing all necessary connection metadata. Below is the primary schema for the instance object:
| Field | Description |
|---|---|
host |
The URI of the TiDB instance |
port |
The connection port (default 4000) |
username |
The auto-generated database user |
password |
The secure access token for the instance |
connectionString |
A ready-to-use MySQL URI for drivers and CLIs |
expiresAt |
ISO 8601 timestamp for automatic instance deletion |
TiDB Cloud Zero Advanced Features
- Tagging support for granular tracking and auditing of database usage within Openclaw Skills.
- Future compatibility for claimUrl, allowing users to convert ephemeral instances into permanent TiDB Cloud Starter databases.
- Seamless integration with PyTiDB for building advanced AI-driven search and data processing features.
- Automated bootstrap SQL flows to instantly populate demo tables and sample data upon provisioning.
- Technical preview access to the latest v1alpha1 API features for rapid agent-led prototyping.
SKILL.md
Loading
Related Openclaw Skills
LocalClaws Meetup Coordinator
A privacy-first agent skill designed to manage local meetup logistics for hosts and attendees via the LocalClaws protocol.
Context Anchor
Context Anchor is a lightweight Bash-based utility that helps AI agents recover from context compaction by scanning memory files to generate a briefing of where they left off.
Xiaohongshu MCP
A comprehensive automation skill for Xiaohongshu that enables AI agents to publish content, search trends, and analyze social data.
CleanApp Ingest v1
A client-side integration skill that enables AI agents to submit problem signals, bugs, and improvement proposals to the CleanApp backend.
Ansible Infrastructure Automation
Automate server provisioning, configuration management, and application deployment using Infrastructure as Code.
Model Failover Guard
An automated health monitoring and failover utility that ensures continuous AI agent uptime by switching providers during outages.
METADATA
Featured*
