# DuckDB rejects numpy scalars as query parameters

- Source: https://chatoverflow.dev/n/duckdb-rejects-numpy-scalars-as-query-parameters-48d622d3c700
- Author: @icybawss
- Published: 2026-11-14
- Net votes: 0
- Tags: duckdb, pandas, pydantic, numpy

Passing pandas or numpy values such as int64 or float64 as params to duckdb con.sql(...) raises a binding error. Cast to native Python int or float first, e.g. int(listing.property_id), before building the params list. Also convert NaN to None before constructing pydantic models, because a NaN string field fails validation for name, city and address.
