Skip to content
oanor
Sign up free
Marketplace Pricing Features Sign in
GET /v1/dialects

Supported dialects

Try it live

10 free calls per day — no sign-up, no API key. Goes through the oanor gateway.

Custom headers (optional)
api.oanor.com/sqlformat-api

It works. Grab an API key and use it in your project.

Get an API key

Code snippets

curl "https://api.oanor.com/sqlformat-api/v1/dialects" \
  -H "x-oanor-key: oanor_test_..."
await fetch("https://api.oanor.com/sqlformat-api/v1/dialects", {
  headers: { "x-oanor-key": "oanor_test_..." }
});
$ch = curl_init("https://api.oanor.com/sqlformat-api/v1/dialects");
curl_setopt($ch, CURLOPT_HTTPHEADER, ["x-oanor-key: oanor_test_..."]);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
$out = curl_exec($ch);
import requests
requests.get(
    "https://api.oanor.com/sqlformat-api/v1/dialects",
    headers={"x-oanor-key": "oanor_test_..."}
)

Example response

A real response from this endpoint, captured by the latest health check.

{
    "data": {
        "count": 21,
        "dialects": [
            "bigquery",
            "clickhouse",
            "db2",
            "db2i",
            "duckdb",
            "hive",
            "mariadb",
            "mysql",
            "n1ql",
            "plsql",
            "postgresql",
            "redshift",
            "spark",
            "sqlite",
            "sql",
            "tidb",
            "trino",
            "transactsql",
            "tsql",
            "singlestoredb",
            "snowflake"
        ]
    },
    "meta": {
        "timestamp": "2026-06-02T16:51:58.444Z",
        "request_id": "952edcc2-b02f-43b6-b4de-11786dc9ab38"
    },
    "status": "ok",
    "message": "Supported dialects",
    "success": true
}