Tidb Cloud

TiDB Cloud is the managed offering of TiDB — a distributed SQL database that handles both OLTP (transactions) and OLAP (analytics) on the same data without ETL. MySQL-compatible: any MySQL client, ORM, or framework works without changes. TiDB Serverless provides scale-to-zero with per-RU billing for dev/test and lightweight production workloads. For agents: the REST Data API enables SQL execution over HTTPS without a database driver — strong for serverless environments. Standard MySQL protocol for connection-pool-based workloads. Automatic horizontal scaling for traffic spikes. HTAP eliminates the need for a separate analytics database for most workloads. Confidence is docs-derived.

Two surfaces: (1) REST Data API at <cluster_id>.us-east-1.aws.tidbcloud.com/v1beta/sql — POST with {cluster_id, database, sql, params}. Returns column names + rows as JSON. No database driver required; works from any HTTP client. (2) MySQL wire protocol: standard host:port connection using mysql2, MySQLConnector, etc. TiDB Cloud Management API at api.tidbcloud.com/api/v1beta for cluster lifecycle (create, delete, scale, backup). GET /clusters lists clusters. POST /projects/{id}/clusters creates a cluster. Cluster events, backup/restore via Management API. SQL: fully MySQL 8.0 compatible — standard DDL, DML, stored procedures, JSON, and window functions.

Data API: API key pairs (public + private key) generated from TiDB Cloud console. Authorization: digest auth with public/private key. HTTPS enforced. MySQL wire protocol: database username + password (TLS required). TiDB Cloud Serverless: each project gets a default database user; additional users manageable via SQL (CREATE USER, GRANT). Management API: API key with scope (read/write cluster management). IAM-based access controls for team members in TiDB Cloud console. VPC peering available for private connectivity.

Data API: standard HTTP status codes with JSON error responses. SQL errors returned in response body ({code, message}). MySQL protocol: standard MySQL error codes. Serverless tier: scale-to-zero cold start is fast (sub-second for TiDB Serverless). Row-level locks, MVCC for transaction isolation. Distributed transactions: 2-phase commit with strong consistency guarantees. TiDB Cloud SLA: 99.99% for Dedicated clusters. Serverless tier: no published SLA. Status at status.tidbcloud.com. Automatic failover: cluster survives AZ failure. Backup: daily automated backups (configurable retention).

docs.pingcap.com/tidbcloud is comprehensive — cluster management guide, Data API reference, MySQL compatibility notes, HTAP usage guide (TiFlash for analytics), and SDK examples. Getting started: TiDB Serverless is free (no credit card); first cluster in under 2 minutes, first Data API query in under 5 minutes. Native integrations with Vercel, Netlify, and serverless frameworks. Active community via TiDB community forum, Slack, and GitHub (pingcap/tidb, 37k+ stars). PingCAP engineering team is highly responsive in community channels.