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

Data Science & ML

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

About

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.

Key Features

Remote Parquet file loading and querying from cloud storage
Browser-side DuckDB-WASM and MotherDuck WASM client patterns
MotherDuck authentication and connection string optimization
Serverless compatibility fixes for Vercel/AWS Lambda GLIBC errors
BigInt serialization helpers for DuckDB-to-JSON workflows
0 GitHub stars

Use Cases

Deploying serverless SQL APIs for large Parquet datasets
Implementing embedded OLAP analytics in TypeScript applications
Building real-time security dashboards for NetFlow and logs

About

Key Features

Remote Parquet file loading and querying from cloud storage
Browser-side DuckDB-WASM and MotherDuck WASM client patterns
MotherDuck authentication and connection string optimization
Serverless compatibility fixes for Vercel/AWS Lambda GLIBC errors
BigInt serialization helpers for DuckDB-to-JSON workflows
0 GitHub stars

Use Cases

Deploying serverless SQL APIs for large Parquet datasets
Implementing embedded OLAP analytics in TypeScript applications
Building real-time security dashboards for NetFlow and logs