---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: duckgl
excerpt: |
  DuckDB Community Extensions
  DuckDB geospatial visualization with deck.gl and MapLibre

extension:
  name: duckgl
  description: DuckDB geospatial visualization with deck.gl and MapLibre
  version: 0.1.0
  language: C++
  build: cmake
  license: MIT
  maintainers:
    - nkwork9999

repo:
  github: nkwork9999/duckgl
  ref: 45ef59e814d2fa1dac3b383d40513ffd45f1beb9

docs:
  hello_world: |
    -- Start DuckGL server
    SELECT duckgl_start('localhost', 8080);

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

    -- Stop server
    SELECT duckgl_stop();

  extended_description: |
    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.

extension_star_count: 12
extension_star_count_pretty: 12
extension_download_count: 868
extension_download_count_pretty: 868
image: '/images/community_extensions/social_preview/preview_community_extension_duckgl.png'
layout: community_extension_doc
---
### Compatibility Matrix

This table covers all DuckDB releases that have not reached [end-of-life](https://duckdb.org/release_calendar), 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.

<div class="extension_compatibility_table"></div>

| 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
```sql
INSTALL {{ page.extension.name }} FROM community;
LOAD {{ page.extension.name }};
```

{% if page.docs.hello_world %}
### Example
```sql
{{ page.docs.hello_world }}```
{% endif %}

{% if page.docs.extended_description %}
### About {{ page.extension.name }}
{{ page.docs.extended_description }}
{% endif %}
### Added Functions

<div class="extension_functions_table"></div>

| function_name | function_type | description | comment | examples |
|---------------|---------------|-------------|---------|----------|
| duckgl_start  | scalar        | NULL        | NULL    |          |
| duckgl_stop   | scalar        | NULL        | NULL    |          |

### Overloaded Functions

<div class="extension_functions_table"></div>

This extension does not add any function overloads.

### Added Types

<div class="extension_types_table"></div>

This extension does not add any types.

### Added Settings

<div class="extension_settings_table"></div>

|      name      |                       description                       | input_type | scope  | aliases | typed_value |
|----------------|---------------------------------------------------------|------------|--------|---------|-------------|
| temp_directory | Set the directory to which temporary files are written. | VARCHAR    | GLOBAL | []      | post.db.tmp |