How do I correctly pass the MotherDuck token?

The token must be embedded directly in the connection string (e.g., md:?motherduck_token=TOKEN) rather than passed as a configuration object to prevent matching errors.

What headers are needed for DuckDB-WASM in the browser?

To use SharedArrayBuffer, you must set Cross-Origin-Opener-Policy (same-origin) and Cross-Origin-Embedder-Policy (credentialless) headers in your vercel.json or server config.

Can I query Parquet files directly from S3?

Yes, DuckDB can query remote files using 'read_parquet(url)'. This skill includes patterns for loading data from S3, Cloudflare R2, and GCS using HTTPS.

How can I handle BigInt values in my query results?

DuckDB returns BigInt for large numbers, which breaks JSON.stringify. This skill provides a recursive 'convertBigInts' helper to prepare data for API responses.

Why am I getting GLIBC errors on Vercel with DuckDB?

Standard DuckDB packages require GLIBC 2.29+, but Vercel/Lambda environments often use older versions. This skill recommends using 'duckdb-lambda-x86' as a drop-in replacement.

DuckDB & MotherDuck Analytics

Name: DuckDB & MotherDuck Analytics
Author: SecurityRonin

bySecurityRonin

0•

データサイエンスとML

Streamlines building high-performance OLAP applications using DuckDB, MotherDuck, and Parquet in Node.js and TypeScript.

This skill provides battle-tested implementation patterns for integrating DuckDB and MotherDuck into modern data-intensive applications. It specifically addresses critical serverless challenges, such as solving GLIBC compatibility issues on Vercel and AWS Lambda using specialized builds. Developers get access to optimized connection management, direct Parquet file handling from cloud storage (S3/R2/GCS), and pre-built SQL patterns for security analytics and time-series bucketing. Whether you are building browser-based WASM dashboards or server-side data pipelines, this skill provides the hard-won knowledge needed to avoid common configuration pitfalls and serialization errors.

主な機能

01Remote Parquet file loading and querying from cloud storage

02Browser-side DuckDB-WASM and MotherDuck WASM client patterns

03MotherDuck authentication and connection string optimization

04Serverless compatibility fixes for Vercel/AWS Lambda GLIBC errors

05BigInt serialization helpers for DuckDB-to-JSON workflows

060 GitHub stars

ユースケース

01Deploying serverless SQL APIs for large Parquet datasets

02Implementing embedded OLAP analytics in TypeScript applications

03Building real-time security dashboards for NetFlow and logs

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add securityronin/ronin-marketplace duckdb-motherduck-parquet

For use in Claude.ai and ChatGPT

Download Skill