Databases

Manage MySQL/MariaDB databases. Base: /api/v1/databases · Auth: Authorization: Bearer wsp_…

Error envelope: { "success": false, "code": "VALIDATION_ERROR", "error": "database name is required", "message": "…", "status": 400 }

List — GET /api/v1/databases/

No body. Response 200 (verified live): [], or items:

[ { "name": "admin_shop", "db_user": "admin_shop", "owner": "admin",
    "size_kb": 0, "remote_access": false, "remote_host": "",
    "created_at": "2026-05-18T17:44:35+07:00",
    "updated_at": "2026-05-18T17:44:35+07:00" } ]

Create — POST /api/v1/databases/

Only name required; db_user = <owner>_<name>, password auto-generated if omitted.

Request: { "name": "shop" }

Response 201 (verified live — note db_password shown once):

{ "name": "admin_shop", "db_user": "admin_shop",
  "db_password": "361ebac88cac9451393a1153f6eda52e",
  "created_at": "2026-05-18T17:44:35+07:00" }

Response 400 (verified live): { "success": false, "code": "VALIDATION_ERROR", "error": "database name is required", "message": "database name is required", "status": 400 }

Get / delete

GET /api/v1/databases/:name → same shape as a list item. DELETE /api/v1/databases/:name → 200 (verified live):

{ "message": "Database deleted successfully" }

PUT /databases/:name Request: { "remote_access": true, "remote_host": "%" }. POST /databases/:name/reset-password → { "db_password": "…" }. POST /databases/:name/phpmyadmin → { "url": "https://…" } (one-time).

Conventions → Authentication, Error Handling.