Search Shortcut cmd + k | ctrl + k
fit
Downloads 319this week
GitHub stars 1
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  

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings

This extension does not add any settings.