DuckDB.NET.Data 1.5.0

dotnet add package DuckDB.NET.Data --version 1.5.0
                    
NuGet\Install-Package DuckDB.NET.Data -Version 1.5.0
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="DuckDB.NET.Data" Version="1.5.0" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="DuckDB.NET.Data" Version="1.5.0" />
                    
Directory.Packages.props
<PackageReference Include="DuckDB.NET.Data" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add DuckDB.NET.Data --version 1.5.0
                    
#r "nuget: DuckDB.NET.Data, 1.5.0"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package DuckDB.NET.Data@1.5.0
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=DuckDB.NET.Data&version=1.5.0
                    
Install as a Cake Addin
#tool nuget:?package=DuckDB.NET.Data&version=1.5.0
                    
Install as a Cake Tool

DuckDB.NET

DuckDB bindings for C#

GitHub Workflow Status Coveralls License Ko-Fi Discord

NuGet DuckDB.NET.Data NuGet DuckDB.NET.Bindings

NuGet DuckDB.NET.Data.Full NuGet DuckDB.NET.Bindings.Full

Project Icon

Usage

dotnet add package DuckDB.NET.Data.Full
using (var duckDBConnection = new DuckDBConnection("Data Source=file.db"))
{
  duckDBConnection.Open();

  using var command = duckDBConnection.CreateCommand();

  command.CommandText = "CREATE TABLE integers(foo INTEGER, bar INTEGER);";
  var executeNonQuery = command.ExecuteNonQuery();

  command.CommandText = "INSERT INTO integers VALUES (3, 4), (5, 6), (7, 8);";
  executeNonQuery = command.ExecuteNonQuery();

  command.CommandText = "Select count(*) from integers";
  var executeScalar = command.ExecuteScalar();

  command.CommandText = "SELECT foo, bar FROM integers";
  var reader = command.ExecuteReader();

  PrintQueryResults(reader);
}

private static void PrintQueryResults(DbDataReader queryResult)
{
  for (var index = 0; index < queryResult.FieldCount; index++)
  {
    var column = queryResult.GetName(index);
    Console.Write($"{column} ");
  }

  Console.WriteLine();

  while (queryResult.Read())
  {
    for (int ordinal = 0; ordinal < queryResult.FieldCount; ordinal++)
    {
      var val = queryResult.GetInt32(ordinal);
      Console.Write(val);
      Console.Write(" ");
    }

    Console.WriteLine();
  }
}

MotherDuck

To connect to MotherDuck:

using var duckDBConnection = new DuckDBConnection("DataSource=md:{your_database}?motherduck_token=ey...");

DuckDB Extensions (C#)

If you want to build DuckDB extensions with C#, see Giorgi/DuckDB.ExtensionKit.

Known Issues

When debugging your project that uses DuckDB.NET library, you may get the following error: System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. The error happens due to debugger interaction with the native memory. For a workaround check out Debugger Options mess up debugging session during Marshalling

Documentation

Documentation is available at https://duckdb.net

Support

If you encounter a bug with the library Create an Issue. Join the DuckDB dotnet channel for DuckDB.NET-related topics.

Contributors

Contributors

Sponsors

A big thanks to DuckDB Labs and AWS Open Source Software Fund for sponsoring the project!

DuckDB Labs

AWS

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (8)

Showing the top 5 NuGet packages that depend on DuckDB.NET.Data:

Package Downloads
Microsoft.SemanticKernel.Connectors.DuckDB

DuckDB connector for Semantic Kernel plugins and semantic memory

DuckDB.InteractiveExtension

DuckDB support for Polyglot Notebooks

NetEvolve.HealthChecks.DuckDB

Contains HealthChecks for DuckDB, based on the nuget package `DuckDB.NET.Data`.

Mostlylucid.LucidRAG.DataSummarizer

Core data file processing pipeline for CSV, JSON, Excel, Parquet, and SQLite database ingestion with relationship detection

Microsoft.DotNet.Interactive.DuckDB

Microsoft.DotNet.Interactive.Kernel implementation for DuckDB

GitHub repositories (3)

Showing the top 3 popular GitHub repositories that depend on DuckDB.NET.Data:

Repository Stars
dotnet/interactive
.NET Interactive combines the power of .NET with many other languages to create notebooks, REPLs, and embedded coding experiences. Share code, explore data, write, and learn across your apps in ways you couldn't before.
Hitmasu/OpenCNPJ
API pública de busca e consulta de CNPJs do Brasil
erikdarlingdata/PerformanceMonitor
Free, open-source SQL Server performance monitoring. All the important stuff. Built-in MCP server for AI integration.
Version Downloads Last Updated
1.5.0 255 3/10/2026
1.4.4 8,518 2/3/2026
1.4.4-alpha.2 445 12/19/2025
1.4.3 16,722 12/11/2025
1.4.1 21,684 10/13/2025
1.3.2 17,203 7/8/2025
1.3.0 5,517 6/3/2025
1.2.1 4,749 3/5/2025
1.2.1-alpha.8 164 2/19/2025
1.2.0 6,522 2/6/2025
1.1.3 79,274 11/7/2024
1.1.2.1 39,084 10/21/2024
1.1.2-alpha.5 158 10/10/2024
1.1.1 12,554 9/24/2024
1.1.0.1 5,495 9/9/2024
1.0.2 13,552 7/22/2024
1.0.1 51,488 6/22/2024
1.0.0 5,944 6/3/2024
Loading failed

- Updated to DuckDB v1.5.0
- Dropped netstandard2.0 and net6.0 (now targets net8.0+)

New features:
- High-level scalar function API
- High-level table function API
- Named parameters for table functions via [Named] attribute
- NULL handling for scalar functions inferred from nullable parameter types (int?, string?)
- Appender Clear() method to discard in-progress rows

Performance:
- Reuse vector readers across chunks instead of recreating per chunk
- Migrated from DllImport to LibraryImport with source-generated P/Invoke
- Cache enum dictionary lookups in EnumVectorDataReader
- Expression tree-based nullable GetValue<T> to avoid boxing
- SuppressGCTransition on trivial native calls
- AggressiveInlining on hot-path methods
- Appender value writes split by struct/class to avoid boxing