Query and create LeRobot v3 datasets, including frame data, images, and video observation windows.
Compatibility Matrix
This table covers all DuckDB releases that have not reached end-of-life, 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.
| 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
INSTALL lerobot FROM community;
LOAD lerobot;
Example
LOAD lerobot;
COPY (
SELECT 0::BIGINT AS episode_index,
'pick up a block' AS task,
i::FLOAT AS action
FROM range(10) AS frames(i)
ORDER BY i
) TO 'lerobot_example' (
FORMAT lerobot,
FPS 10,
FEATURES '{"action": {"dtype": "float32", "shape": [1]}}'
);
SELECT episode_index, frame_index, timestamp, action
FROM lerobot_scan('lerobot_example')
ORDER BY frame_index;
About lerobot
Read LeRobot v3 metadata and frame data, create datasets with COPY, decode RGB video frames, and select temporal observation windows with SQL. TorchCodec integration is available through a separate optional Python package.
The extension source is Apache-2.0. Native binaries statically link LGPL FFmpeg, libaom, dav1d, and zlib with their respective licenses. GPL codecs are excluded from the default build. Corresponding source and rebuilding instructions are described in REDISTRIBUTION.md.
Added Functions
| function_name | function_type | description | comment | examples |
|---|---|---|---|---|
| lerobot_cache_info | table | NULL | NULL | |
| lerobot_decode_image | scalar | NULL | NULL | |
| lerobot_episodes | table | NULL | NULL | |
| lerobot_info | table | NULL | NULL | |
| lerobot_scan | table | NULL | NULL | |
| lerobot_stats | table | NULL | NULL | |
| lerobot_tasks | table | NULL | NULL | |
| lerobot_temporal_targets | table | NULL | NULL | |
| lerobot_video_frames | table | NULL | NULL | |
| lerobot_video_routes | table | NULL | NULL | |
| lerobot_video_targets | table | NULL | NULL | |
| lerobot_video_windows | 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.