Downloads 42this week

GitHub stars 1

Extension repository on GitHub

Extension descriptor (YAML)

WHATWG URLPattern API for matching and extracting components from URLs using pattern syntax

Installing and Loading

INSTALL urlpattern FROM community;
LOAD urlpattern;

Example

-- Test if a URL matches a pattern
SELECT urlpattern_test('https://example.com/users/:id', 'https://example.com/users/123');
-- true

-- Extract a named group from a URL
SELECT urlpattern_extract('https://example.com/users/:id', 'https://example.com/users/123', 'id');
-- '123'

-- Get full match results with all components
SELECT urlpattern_exec('/posts/:slug', '/posts/hello-world');
-- {matched: true, pathname: '/posts/hello-world', groups: {slug: 'hello-world'}, ...}

-- Use the URLPATTERN type for validated patterns
SELECT urlpattern_test(urlpattern('/api/:version/*'), '/api/v2/users/list');
-- true

About urlpattern

The URLPattern extension implements the WHATWG URLPattern API for DuckDB, enabling powerful URL matching and component extraction using a standard pattern syntax.

Features

• Custom URLPATTERN type with validation and implicit casting from VARCHAR
• Pattern matching with named groups (:name), wildcards (*), and regex groups
• Component extraction for protocol, hostname, port, pathname, search, and hash
• Pattern caching for improved performance on repeated patterns

Functions

Pattern Syntax

URLPattern uses a syntax similar to Express.js routes:

• :name - Named parameter (matches any segment)
• * - Wildcard (matches everything)
• :name(regex) - Named parameter with regex constraint
• {optionalGroup} - Optional group

For full pattern syntax, see the URLPattern specification.

Added Functions

Added Types