---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: livetennis
excerpt: |
  DuckDB Community Extensions
  Query the Live Tennis API from SQL - live matches, upcoming fixtures and player search as table functions

extension:
  name: livetennis
  description: Query the Live Tennis API from SQL - live matches, upcoming fixtures and player search as table functions
  version: 0.1.0
  language: C++
  build: cmake
  license: MIT
  excluded_platforms: "windows_amd64_rtools;windows_amd64_mingw;wasm_mvp;wasm_eh;wasm_threads"
  maintainers:
    - bensynapse

repo:
  github: livetennisapi/duckdb-livetennis
  ref: v0.1.0

docs:
  hello_world: |
    LOAD livetennis;

    -- A free API key (no card) is self-serve at https://livetennisapi.com/subscribe/free
    CREATE SECRET (TYPE livetennis, API_KEY 'ltk_...');

    -- Matches on court right now, with the latest score
    SELECT tournament, p1_name, p2_name, sets, games, points
    FROM live_tennis_matches();

    -- Upcoming ATP fixtures (also: wta, challenger, itf, juniors; omit for all tours)
    SELECT start_time, tournament, round, player1_name, player2_name
    FROM live_tennis_fixtures('atp')
    WHERE start_time IS NOT NULL
    ORDER BY start_time;

    -- Player search
    SELECT player_id, name, tour, country, ranking
    FROM live_tennis_players('alcaraz');
  extended_description: |
    This extension exposes the [Live Tennis API](https://livetennisapi.com) as DuckDB
    table functions: `live_tennis_matches()` (matches currently in play),
    `live_tennis_fixtures([tour])` (upcoming scheduled fixtures) and
    `live_tennis_players(search)` (player search). Coverage spans ATP, WTA,
    Challenger, ITF and junior Grand Slam draws.

    An API key is required; the free tier (30 requests/minute, 100/day, no card)
    covers everything the extension exposes. The key can be provided with
    `CREATE SECRET (TYPE livetennis, API_KEY '...')`, the `livetennis_api_key`
    setting, or the `LIVE_TENNIS_API_KEY` environment variable.

    This extension is maintained by the Live Tennis API team.

extension_star_count: 1
extension_star_count_pretty: 1
extension_download_count: 848
extension_download_count_pretty: 848
image: '/images/community_extensions/social_preview/preview_community_extension_livetennis.png'
layout: community_extension_doc
---
### Compatibility Matrix

This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), including LTS releases, and shows the 2 most recent patch releases of each. Older patch releases are not listed, but the extension may be available for them as well.

<div class="extension_compatibility_table"></div>

| Platform | 1.4.4 | 1.4.5 | 1.5.5 | 1.5.6 | 2.0.0 |
| :--- | :---: | :---: | :---: | :---: | :---: |
| Linux AMD64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| Linux ARM64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| macOS AMD64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| macOS ARM64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| Windows AMD64 | ❌ | ❌ | ✅ | ✅ | ❌ |
| Windows ARM64 | ❌ | ❌ | ❌ | ❌ | ❌ |
| WebAssembly | ❌ | ❌ | ❌ | ❌ | ❌ |

### Installing and Loading
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions

<div class="extension_functions_table"></div>

|    function_name     | function_type | description | comment | examples |
|----------------------|---------------|-------------|---------|----------|
| live_tennis_fixtures | table         | NULL        | NULL    |          |
| live_tennis_matches  | table         | NULL        | NULL    |          |
| live_tennis_players  | table         | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

|        name         |                                         description                                         | input_type | scope  | aliases |
|---------------------|---------------------------------------------------------------------------------------------|------------|--------|---------|
| livetennis_api_key  | API key for the Live Tennis API (https://livetennisapi.com)                                 | VARCHAR    | GLOBAL | []      |
| livetennis_base_url | Override the Live Tennis API base URL (default https://api.livetennisapi.com/api/public/v1) | VARCHAR    | GLOBAL | []      |