duckgl

870 downloads this week 12 stars Extension descriptor

DuckDB geospatial visualization with deck.gl and MapLibre

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 duckgl FROM community;
LOAD duckgl;

Example

-- Start DuckGL server
SELECT duckgl_start('localhost', 8080);

-- Open http://localhost:8080 in browser

-- Stop server
SELECT duckgl_stop();

About duckgl

DuckGL provides a web-based geospatial visualization interface for DuckDB.

Features

• Interactive map visualization using deck.gl and MapLibre
• GeoJSON layer rendering from spatial tables
• SQL query execution from browser UI

HTML and PDF reports: Export HTML downloads an offline snapshot containing the last successful SQL query, all returned rows, and a north-up SVG geometry overview without base-map tiles. Export PDF opens that report in the browser print dialog; choose Save as PDF. Saved HTML contains no scripts and does not execute SQL.

Map analysis and additional exports: Inspect table columns, choose a geometry column, specify the source CRS for WGS84 conversion, map a spatial SELECT query, and click features to inspect their attributes. Download query results as CSV or JSON, and map data as GeoJSON, SVG, PNG, or interactive HTML. Interactive HTML embeds the data and runs without the DuckGL server, but needs internet access for map libraries and base-map tiles. SVG and PNG are north-up geometry overviews without tiles. Attached database selection and large integer identifiers retain their exact identity.

Added Functions

Overloaded Functions

This extension does not add any function overloads.

Added Types

This extension does not add any types.

Added Settings