Downloads 2this week

GitHub stars 0

Extension descriptor (YAML)

Query Universal Scene Description (USD) files with SQL

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.

Installing and Loading

INSTALL usd FROM community;
LOAD usd;

Example

-- Prims of a USD stage
SELECT prim_path, prim_type, kind FROM usd_prims('scene.usda') LIMIT 10;

-- World-space positions
SELECT prim_path, x, y, z FROM usd_xforms('scene.usda') WHERE prim_path LIKE '/World/%';

-- Typed property values
SELECT prim_path, property_name, value FROM usd_properties('scene.usda', authored_only := true);

About usd

The usd extension reads Universal Scene Description (USD) stages - the scene format created by Pixar and used across 3D content, simulation and digital twin pipelines - and exposes their contents as tables:

• usd_prims: the prims of a stage, with type, kind, activation, instancing, payloads, applied schemas, custom data and asset info
• usd_properties: attributes and relationships, with typed values (VARIANT)
• usd_relationships: relationship targets, for graph analysis
• usd_xforms: world-space positions, rotations, scales and matrices
• usd_bounds: world-space bounding boxes
• usd_variants, usd_layers, usd_stage_metadata and usd_composition_errors: variant sets, the layers a stage uses, stage metadata such as units and up axis, and broken references
• usd_composition_arcs: the references, payloads, inherits and variant selections of each prim, i.e. which assets a scene uses, where and how often
• usd_material_bindings: the material each prim is bound to, and the binding that decides it
• usd_time_samples: the values recorded over time - animation, sensor readings, simulation results

Every function accepts a path, a glob or a list of paths, and options to restrict the scan to a subtree, descend into instances or skip payloads; values, transforms and bounds can be read at one or several time codes. Scans are parallel and only compute the columns a query uses, so scenes with millions of prims spread over hundreds of layers can be queried directly.

OpenUSD 26.05 is linked into the extension, with its schemas for geometry, shading, lights, skeletons, physics, semantic labels, volumes, audio, render settings, procedurals and UI. See the function reference and cookbook.

Added Functions

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings