Check database status

Check if a database is running, suspended, or starting up. Poll this endpoint to determine when a serverless database is ready.

Status Values:

• running - Database is active and accepting connections
• suspended - Database is suspended (scale-to-zero). It wakes on POST /databases/{asset_id}/wake or on the first SQL request. When reason is ComputeUnschedulable, no node could host its compute size: waking it only restarts the same wait
• starting - Database is waking up, or its compute is being recreated
• creating - Database is being created; it has no compute yet
• failed - Database failed to start, or its creation failed (message says which)
• unknown - Status could not be determined (the control plane did not answer); retry

A database suspends (scales to zero) after suspend_timeout_seconds without activity; GET/PATCH /databases/{asset_id}/settings read and set that window, and 0 keeps it running. Reading the compute status or the settings never wakes a suspended database. Two things do: POST /databases/{asset_id}/wake, which answers at once while the compute starts, or any request that runs SQL on it, such as POST /databases/{asset_id}/sql, which waits for the compute up to 120 seconds; if the compute is still starting then, the answer is 503 with Retry-After and the statement did not run. A cold start usually takes 30 seconds to 2 minutes.