There are situations where a Supabase database becomes unresponsive or needs a restart, but the developer is away from their device or unable to access the dashboard at that moment. Currently, there is no programmatic way to trigger a database restart remotely via an API call.
This is a real pain point: if your database goes down at an inconvenient time, you either have to rush to your computer to log into the dashboard and restart it manually, or wait and let your users experience downtime.
Introduce a secure, authenticated Management API endpoint that allows project owners to:
POST /v1/projects/{ref}/database/restart)The user requests a secure, authenticated API endpoint to remotely restart or toggle a Supabase database on and off. This feature would help manage unresponsive databases without accessing the dashboard, improving uptime and convenience for developers. The proposal includes strong authentication, rate limiting, and logging for security.
This feature would be especially valuable combined with a webhook or notification when the auto-restart fires, so developers stay informed. Many cloud providers (e.g., Railway, Render) offer similar restart/redeploy APIs and they are widely used for self-healing infrastructure.
Thank you for considering this — it would be a huge quality-of-life improvement for the Supabase community!