---
warning: DO NOT CHANGE THIS MANUALLY, THIS IS GENERATED BY https://github.com/duckdb/community-extensions repository, check README there
title: webmacro
excerpt: |
  DuckDB Community Extensions
  Load DuckDB Macros from the web

docs:
  extended_description: For more information regarding usage, see the [documentation](https://query.farm/products/extensions/webmacro/).
  hello_world: "-- Create a DuckDB Scalar or Table macro statement and save it to\
    \ a gist;\n\n-- Load your remote macro onto your system using the gist url\n\n\
    D SELECT load_macro_from_url('https://gist.githubusercontent.com/lmangani/518215a68e674ac662537d518799b893/raw/5f305480fdd7468f4ecda3686011bab8e8e711bf/bsky.sql')\
    \ as res;\n\u250C\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2510\n\u2502                   res                 \
    \  \u2502\n\u2502                 varchar                 \u2502\n\u251C\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2524\n\u2502 Successfully loaded macro: search_posts \u2502\n\u2514\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2518\n\n-- Use your new macro and have fun:\nD SELECT * FROM search_posts('qxip.bsky.social',\
    \ text := 'quack');\n\u250C\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252C\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252C\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252C\u2500\u2500\u2500\u252C\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252C\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u252C\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u252C\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502  author_handle\
    \   \u2502 display_name \u2502      post_text       \u2502 \u2026 \u2502 replies\
    \ \u2502 reposts \u2502 likes \u2502 quotes \u2502\n\u2502     varchar      \u2502\
    \   varchar    \u2502       varchar        \u2502   \u2502  int64  \u2502  int64\
    \  \u2502 int64 \u2502 int64  \u2502\n\u251C\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253C\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u253C\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253C\u2500\
    \u2500\u2500\u253C\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253C\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253C\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u253C\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2524\n\u2502 qxip.bsky.social \u2502 qxip         \u2502 This is super cool\u2026\
    \  \u2502 \u2026 \u2502       1 \u2502       0 \u2502     1 \u2502      0 \u2502\
    \n\u2502 qxip.bsky.social \u2502 qxip         \u2502 github.com/quacksc\u2026\
    \  \u2502 \u2026 \u2502       0 \u2502       1 \u2502     2 \u2502      0 \u2502\
    \n\u2502 qxip.bsky.social \u2502 qxip         \u2502 #DuckDB works grea\u2026\
    \  \u2502 \u2026 \u2502       2 \u2502       3 \u2502    24 \u2502      0 \u2502\
    \n\u2502 qxip.bsky.social \u2502 qxip         \u2502 github.com/quacksc\u2026\
    \  \u2502 \u2026 \u2502       1 \u2502       0 \u2502     0 \u2502      0 \u2502\
    \n\u2502 qxip.bsky.social \u2502 qxip         \u2502 The latest #Quackp\u2026\
    \  \u2502 \u2026 \u2502       0 \u2502       0 \u2502     2 \u2502      0 \u2502\
    \n\u2502 qxip.bsky.social \u2502 qxip         \u2502 The #DuckDB Ecosys\u2026\
    \  \u2502 \u2026 \u2502       0 \u2502       0 \u2502     5 \u2502      0 \u2502\
    \n\u2502 qxip.bsky.social \u2502 qxip         \u2502 Ladies and Gents, \u2026\
    \  \u2502 \u2026 \u2502       1 \u2502       0 \u2502     4 \u2502      0 \u2502\
    \n\u251C\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2534\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n\u2502 7 rows              \
    \                                                        9 columns (7 shown) \u2502\
    \n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\
    \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n"
extension:
  build: cmake
  description: Load DuckDB Macros from the web
  language: C++
  license: MIT
  maintainers:
  - lmangani
  - rustyconover
  name: webmacro
  version: '2025120401'
repo:
  andium: 43a4ba8fcc13219be487d0ac12d68d66ac1d8268
  github: quackscience/duckdb-extension-webmacro
  ref: a9694a967c289aa62f2fadf4e3c82d9d2391dca9
  variegata: 2d725bd8f730f1556dc230e3cf984fec4c17a95d

extension_star_count: 16
extension_star_count_pretty: 16
extension_download_count: 22821
extension_download_count_pretty: 22.8k
image: '/images/community_extensions/social_preview/preview_community_extension_webmacro.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>

This extension does not add any functions.

### 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>

This extension does not add any settings.