Hostingsurge Databases API
The Databases API from Hostingsurge — 24 operation(s) for databases.
Operations 35
POST
/databases/{databaseId}/attach
Attach a database to a project: writes its internal connection string as a…
#
POST
/databases/{databaseId}/public-access
Toggle public exposure of a database (a fresh public port is assigned when…
#
POST
/databases/{databaseId}/resources
Change a database's CPU/memory limits within the plan and the organization's…
#
PUT
/databases/{databaseId}/backups
Create or update the native scheduled-backup configuration; each backup is also…
#
DELETE
/databases/{databaseId}/backups
Remove the scheduled-backup configuration (the engine deletes its backups and…
#
POST
/databases/{databaseId}/backups/run
Trigger an immediate backup using the existing schedule (a schedule must exist…
#
GET
/databases/{databaseId}/backups/executions
Recent scheduled/on-demand backups (newest first), each with its copy in backup…
#
POST
/databases/{databaseId}/backups/download
A 15-minute download link (presigned URL) for one backup, after checking the…
#
POST
/databases/{databaseId}/backups/restore
Restore a checked backup into a new database of the same engine (default), or…
#
POST
/databases/{databaseId}/restore
Replay one of this database's own backup files (server path) into it: exact…
#
GET
/databases/{databaseId}/restore/{importId}
Poll the status of a restore started with restoreDatabase
#
POST
/projects/{projectId}/databases/external
Connect a database that stays where it is (Neon, Supabase, PlanetScale…
#
GET
/databases/{databaseId}/extensions
PostgreSQL extensions you can enable (pgvector, pg_trgm, uuid-ossp, citext…
#
POST
/databases/{databaseId}/extensions
Enable (CREATE EXTENSION … CASCADE) or disable (DROP EXTENSION, refused while…
#
GET
/databases/{databaseId}/pooler
PgBouncer connection pooler: status, mode, pooled and direct connection URLs
#
PUT
/databases/{databaseId}/pooler
Turn the connection pooler on (transaction mode by default) or change its…
#
GET
/databases/{databaseId}/insights
Size, open connections, version and engine figures (cached for a minute…
#
POST
/databases/{databaseId}/clone
Create a new database of the same engine with a copy of this one's data (runs…
#
GET
/databases/{databaseId}/rest
REST API (Upstash-compatible) of a Redis database: on or off, its address, live…
#
POST
/databases/{databaseId}/rest
Turn the REST API on (or change public access): apps using @vercel/kv…
#
DELETE
/databases/{databaseId}/rest
Turn the REST API off: its tokens stop working within 30 seconds
#
POST
/databases/{databaseId}/rest/rotate
Replace the REST tokens (both by default); the old ones stop working within 30…
#
GET
/databases/{databaseId}/metrics
Metrics history: size, connections, operations per second, cache hit ratio and…
#
POST
/databases/{databaseId}/console
Open a read-only database console (dashboard session only; databases:reveal).
#
PATCH
/databases/{databaseId}/console/{sessionId}
Switch a console between read-only and write mode (write needs databases:write…
#
POST
/databases/{databaseId}/console/{sessionId}/run
Run a statement (SQL, a MongoDB command document or Redis commands) or browse…
#
Specifications
Schemas & Data
JSONSchema
https://artifacts.apis.io/hostingsurge-com/json-schema/hostingsurge-com-builder-visual-op-schema.json
JSONSchema
https://artifacts.apis.io/hostingsurge-com/json-schema/hostingsurge-com-policy-templates-input-body-schema.json
JSONSchema
https://artifacts.apis.io/hostingsurge-com/json-schema/hostingsurge-com-pending-changes-input-body-schema.json
JSONSchema
https://artifacts.apis.io/hostingsurge-com/json-schema/hostingsurge-com-confirm-prices-input-body-schema.json
JSONSchema
https://artifacts.apis.io/hostingsurge-com/json-schema/hostingsurge-com-collection-input-body-schema.json
JSONSchema
https://artifacts.apis.io/hostingsurge-com/json-schema/hostingsurge-com-create-shop-input-body-schema.json