Databases

Provision managed Postgres, Redis, MongoDB, and MySQL, and browse their data.

Attach a managed database to a project — Deployzy provisions it and injects the connection string (DATABASE_URL, or REDIS_URL for Redis) as an env var. Authenticate with a deploy-scoped API key (X-API-Key: sm_live_...).

Provision a database for a project

code

POST /api/v1/projects/:id/database

json

{ "type": "postgres" }

type is one of postgres, redis, mongodb, mysql. The connection URL is injected into the project's environment; redeploy for it to take effect.

Inspect the database attached to a project

code

GET    /api/v1/projects/:id/database          # status + connection info
DELETE /api/v1/projects/:id/database          # detach + destroy

Browse & query (Postgres)

code

GET  /api/v1/projects/:id/database/tables
GET  /api/v1/projects/:id/database/tables/:table/columns
GET  /api/v1/projects/:id/database/tables/:table/rows
POST /api/v1/projects/:id/database/query      # { "sql": "select * from users limit 10" }

Redis & MongoDB consoles

code

GET/POST /api/v1/services/:serviceId/redis/keys | /value | /exec
GET/POST /api/v1/services/:serviceId/mongo/collections | /documents | /shell

List all your databases

code

GET /api/v1/databases

Your plan includes one PostgreSQL database; Redis, MongoDB, and MySQL are available on paid plans. The AI agent can also attach a database for you ("give this project a Postgres database").