Open API

Free public whisky database

As DramLog users log bottles, the database grows. All whisky data is freely queryable — no account, no API key, no rate limits (fair use applies).

Base URLhttps://nzopuawtbskeanljyonb.supabase.co/functions/v1/public-apiTry it ↗

GET/whiskies

Returns a paginated list of whiskies.

q — Search name or distillery
country — Filter by country
region — Filter by region
page — Page number, default 1
limit — Max 100, default 20

// GET https://nzopuawtbskeanljyonb.supabase.co/functions/v1/public-api/whiskies?q=lagavulin&limit=2

{
  "data": [
    {
      "id": "a1b2c3d4-...",
      "name": "16 Year Old",
      "distillery": "Lagavulin",
      "region": "Islay",
      "country": "Scotland",
      "age": 16,
      "abv": 43.0,
      "image_url": "https://...",
      "slug": "lagavulin-16-year-old"
    }
  ],
  "meta": { "page": 1, "limit": 2, "total": 1, "pages": 1 }
}

GET/whiskies/:id

Returns a single whisky by UUID. Returns 404 if not found.

// GET https://nzopuawtbskeanljyonb.supabase.co/functions/v1/public-api/whiskies/:id

{
  "id": "a1b2c3d4-e5f6-...",
  "name": "16 Year Old",
  "distillery": "Lagavulin",
  "region": "Islay",
  "country": "Scotland",
  "age": 16,
  "abv": 43.0,
  "image_url": "https://...",
  "slug": "lagavulin-16-year-old"
}

Response fields

idUUID — stable identifier

nameExpression name

distilleryDistillery name

regionWhisky region — may be null

countryCountry of origin — may be null

ageAge in years as integer, null for NAS

abvAlcohol by volume as float — may be null

bottle_sizeVolume in ml — may be null

image_urlBottle photo, background removed — may be null

slugURL-safe identifier

created_atISO 8601 timestamp