---
title: "Get a maintenance schedule"
method: GET
path: "/organizations/{organization}/databases/{database}/maintenance-schedules/{id}"
tags: ["MaintenanceSchedules"]
---

# Get a maintenance schedule

`GET /organizations/{organization}/databases/{database}/maintenance-schedules/{id}`

### Authorization
A service token or OAuth token must have at least one of the following access or scopes in order to use this API endpoint:

**Service Token Accesses**
 `read_database`

**OAuth Scopes**

 | Resource | Scopes |
| :------- | :---------- |
| Organization | `read_databases` |
| Database | `read_database` |

## Path parameters

- `id` string, required
- `organization` string, required
- `database` string, required

## Response `200`

Returns a maintenance schedule

- object
  - `id` string, required — The ID of the maintenance schedule
  - `name` string, required — The display name of the maintenance schedule
  - `created_at` string, required — When the maintenance schedule was created
  - `updated_at` string, required — When the maintenance schedule was last updated
  - `last_window_datetime` string, required — When the last maintenance window started
  - `next_window_datetime` string, required — When the next maintenance window is scheduled
  - `duration` integer, required — The duration of the maintenance window in hours
  - `day` integer, required — Day of the week (0 = Sunday, 6 = Saturday, 7 = every day)
  - `hour` integer, required — Hour of the day in UTC (0-23)
  - `week` integer, required — Week of the month for monthly schedules (0-3)
  - `frequency_value` integer, required — The frequency value of the maintenance schedule
  - `frequency_unit` 'day' | 'week' | 'month' | 'once', required — The frequency unit of the maintenance schedule
  - `enabled` boolean, required — Whether the maintenance schedule is enabled
  - `expires_at` string, nullable, required — When a one-time maintenance schedule expires
  - `deadline_at` string, nullable, required — The deadline for a required maintenance schedule
  - `required` boolean, required — Whether the maintenance schedule is required
  - `pending_vitess_version_update` boolean, required — Whether there is a pending Vitess version update
  - `pending_vitess_version` string, nullable, required — The pending Vitess version, if any
  - `pending_mysql_version_update` boolean, required — Whether there is a pending MySQL version update
  - `pending_mysql_version` string, nullable, required — The pending MySQL version, if any

## Other responses

- `401` — Unauthorized
- `403` — Forbidden
- `404` — Not Found
- `500` — Internal Server Error

## Changes

- **2026-06-01** `72506953f367` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/planetscale/apis/planetscale-api/changes/organizations/:organization/databases/:database/maintenance-schedules/:id/get.md)

---

[API](https://skmtc.dev/planetscale/apis/planetscale-api.md) · [All operations](https://skmtc.dev/planetscale/apis/planetscale-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/planetscale/planetscale-api/revisions/6d28c038c4fd/schema)