Search Shortcut cmd + k | ctrl + k
fit
Downloads 60this week
GitHub stars 0
Extension repository on GitHub
Extension descriptor (YAML)

Read Garmin .fit files using DuckDB - GPS tracks, heart rate, power metrics, and fitness device data

Maintainer(s): antoriche

Installing and Loading 

INSTALL fit FROM community;
LOAD fit;

Example 

-- Read GPS records from a FIT file
SELECT * FROM fit_records('activity.fit') LIMIT 5;

-- Get activity metadata
SELECT * FROM fit_activities('activity.fit');

About fit

This extension allows you to read Garmin .fit files directly in DuckDB.

Available table functions:

  • fit_records(filename) - Main records with GPS tracks and sensor data
  • fit_activities(filename) - Activity metadata and summaries
  • fit_sessions(filename) - Training session information
  • fit_laps(filename) - Individual lap data and splits
  • fit_devices(filename) - Device information and sensor details
  • fit_events(filename) - Activity events and markers
  • fit_users(filename) - User profile information

Added Functions

function_name function_type description comment examples
fit table NULL NULL  
fit_activities table NULL NULL  
fit_devices table NULL NULL  
fit_events table NULL NULL  
fit_laps table NULL NULL  
fit_openssl_version scalar NULL NULL  
fit_records table NULL NULL  
fit_sessions table NULL NULL  
fit_users table NULL NULL