---
title: "Retrieve the SQL Modes for a MySQL Cluster"
method: GET
path: "/v2/databases/{database_cluster_uuid}/sql_mode"
tags: ["DigitalOcean-public.v2-new_Databases"]
---

# Retrieve the SQL Modes for a MySQL Cluster

`GET /v2/databases/{database_cluster_uuid}/sql_mode`

To retrieve the configured SQL modes for an existing MySQL cluster, send a GET request to `/v2/databases/$DATABASE_ID/sql_mode`.
The response will be a JSON object with a `sql_mode` key. This will be set to a string representing the configured SQL modes.

## Path parameters

- `database_cluster_uuid` string, uuid, required

## Response `200`

A JSON string with a key of `sql_mode`.

- SqlMode
  - `sql_mode` string, required — A string specifying the configured SQL modes for the MySQL cluster.

## Other responses

- `401` — Authentication failed due to invalid credentials.
- `404` — The resource was not found.
- `429` — The API rate limit has been exceeded.
- `500` — There was a server error.
- `default` — There was an unexpected error.

## Changes

- **2025-10-16** `cb3bf9b21459` — 2 info
  - api tag `DigitalOcean-public.v2-new_Databases` added
  - api tag `Databases` removed
- **2025-07-18** `f8e8c290636c` — 1 info
  - endpoint added
- **2025-07-17** `5fc9af728e82` — 1 breaking
  - api path removed without deprecation
- **2025-07-17** `f8e8c290636c` — 1 info
  - endpoint added

[Change history](https://skmtc.dev/digitalocean/apis/digitalocean-api/changes/v2/databases/:database_cluster_uuid/sql_mode/get.md)

---

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