Linking TVmaze as a source
Let AI connect your sources for you
Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

The TVmaze connector syncs the TVmaze TV show catalog – shows, people (cast and crew), and their last-updated timestamps – into PostHog.
Prerequisites
None. TVmaze exposes a free public API, so no account, API key, or other credentials are needed.
TVmaze data is licensed CC BY-SA, which requires attribution to TVmaze and share-alike distribution. Make sure your use of the data complies with the license.
Adding a data source
- In PostHog, go to the Sources tab of the data pipeline section.
- Click + New source and click Link next to this source.
- Enter your credentials (see Configuration below) and click Next.
- Select the tables you want to sync, choose a sync method and frequency, then click Import.
Once the syncs are complete, you can start querying this data in PostHog.
TVmaze needs no credentials – just select the tables you want to sync.
Sync modes
Each table can be synced in one of several modes, depending on what the source supports:
- Webhook (when available) – the source pushes changes to PostHog in real time. Fastest freshness, lowest ongoing cost, and the only mode that reliably captures updates and deletes.
- Incremental – only new or updated rows are synced on each run, using a cursor field (such as an
updated_attimestamp). Cheaper than a full refresh, but deletes aren't captured. - Append only – new rows are appended using a cursor field; existing rows are never updated. Ideal for immutable, append-only tables like event logs.
- Full refresh – the whole table is reloaded on every sync. Use it when a table has no reliable cursor or when you need deletions reflected.
See sync methods for a full explanation of how each mode works and how to choose between them.
TVmaze has no server-side change filter, so every table syncs as a full refresh. The show_updates and person_updates tables hold a last-updated timestamp per record, which you can query to see what changed between syncs.
Configuration
Supported tables
| Table | Description | Sync method | Incremental field | Primary key |
|---|---|---|---|---|
shows | Every TV show in the TVmaze database, from the paginated show index. | Full refresh | — | — |
people | Every person (cast and crew) in the TVmaze database, from the paginated person index. | Full refresh | — | — |
show_updates | Last-modified timestamp for every show, useful to detect which shows changed between syncs. | Full refresh | — | — |
person_updates | Last-modified timestamp for every person, useful to detect which people changed between syncs. | Full refresh | — | — |
seasons | Every season of every show, read from the season list of each show in the show index. | Full refresh | — | — |
episodes | Every episode of every show, specials included, read from the episode list of each show in the show index. | Full refresh | — | — |
cast | Main cast of every show: one row per person playing a character, read from the cast list of each show in the show index. | Full refresh | — | — |
The seasons, episodes, and cast tables include a show_id column to join them to shows. The episodes table includes specials. Cast rows also include person_id and character_id.
These three tables make one request per show on every full refresh, so syncing the full catalog can take a long time.
Troubleshooting
If your sync is failing or data looks wrong, see the Data warehouse troubleshooting guide. If that doesn't help, contact support – we're happy to help.





