The DuckDB Go driver, go-duckdb, allows using DuckDB via the database/sql interface. For examples on how to use this interface, see the official documentation and tutorial.
The
go-duckdbproject, hosted at https://github.com/marcboeker/go-duckdb, is the official DuckDB Go client.
Installation
To install the go-duckdb client, run:
go get github.com/marcboeker/go-duckdb Importing
To import the DuckDB Go package, add the following entries to your imports:
import ( "database/sql" _ "github.com/marcboeker/go-duckdb" ) Appender
The DuckDB Go client supports the DuckDB Appender API for bulk inserts. You can obtain a new Appender by supplying a DuckDB connection to NewAppenderFromConn(). For example:
connector, err := duckdb.NewConnector("test.db", nil) if err != nil { ... } conn, err := connector.Connect(context.Background()) if err != nil { ... } defer conn.Close() // Retrieve appender from connection (note that you have to create the table 'test' beforehand). appender, err := NewAppenderFromConn(conn, "", "test") if err != nil { ... } defer appender.Close() err = appender.AppendRow(...) if err != nil { ... } // Optional, if you want to access the appended rows immediately. err = appender.Flush() if err != nil { ... } Examples
Simple Example
An example for using the Go API is as follows:
package main import ( "database/sql" "errors" "fmt" "log" _ "github.com/marcboeker/go-duckdb" ) func main() { db, err := sql.Open("duckdb", "") if err != nil { log.Fatal(err) } defer db.Close() _, err = db.Exec(`CREATE TABLE people (id INTEGER, name VARCHAR)`) if err != nil { log.Fatal(err) } _, err = db.Exec(`INSERT INTO people VALUES (42, 'John')`) if err != nil { log.Fatal(err) } var ( id int name string ) row := db.QueryRow(`SELECT id, name FROM people`) err = row.Scan(&id, &name) if errors.Is(err, sql.ErrNoRows) { log.Println("no rows") } else if err != nil { log.Fatal(err) } fmt.Printf("id: %d, name: %s\n", id, name) } More Examples
For more examples, see the examples in the duckdb-go repository.
© 2025 DuckDB Foundation, Amsterdam NL