curl --request GET \
  --url https://api.planetscale.com/v1/organizations/{organization}/databases/{database}/schema-recommendations \
  --header 'Authorization: Bearer <token>'

{
  "current_page": 123,
  "next_page": 123,
  "next_page_url": "<string>",
  "prev_page": 123,
  "prev_page_url": "<string>",
  "data": [
    {
      "id": "<string>",
      "html_url": "<string>",
      "title": "<string>",
      "table_name": "<string>",
      "keyspace": "<string>",
      "ddl_statement": "<string>",
      "number": 123,
      "state": "open",
      "recommendation_type": "unused_table",
      "created_at": "<string>",
      "updated_at": "<string>",
      "applied_at": "<string>",
      "dismissed_at": "<string>",
      "closed_by_deploy_request": {
        "id": "<string>",
        "branch_id": "<string>",
        "number": 123
      },
      "dismissed_by": {
        "id": "<string>",
        "display_name": "<string>",
        "avatar_url": "<string>"
      }
    }
  ]
}