It depends which database you want to use.
Here’s a tutorial: http://go-database-sql.org/
There’s also this tutorial : https://go.dev/doc/tutorial/database-access
Both tutorials use this mysql-driver: https://github.com/go-sql-driver/mysql
You could also play with sqlite.
Then you need this driver: https://github.com/mattn/go-sqlite3 but it has the problem that it depends on a C-compiler (cgo) so it doesn’t always compile on every system (Linux probably works but macOS or Windows is a bit harder).
Another popular database is postgresql, then I would recommend this driver: https://github.com/jackc/pgx which is also usable with the standard import "database/sql".
That library also provides lower-level access to pg-databases which makes it a bit faster and supports more features specific to postgresql but then you aren’t using database/sql.
In case you want sqlite but don’t want the dependency on a C-compiler (cgo), you can use https://pkg.go.dev/modernc.org/sqlite which uses modernc to convert the original sqlite to something completely running in Go-only.
You could also use libraries specifically for sqlite, that support all (or most of) sqlite’s features but then you are again outside of Go’s standard database/sql-package. There’s https://github.com/crawshaw/sqlite but that depends on cgo again and there is https://pkg.go.dev/zombiezen.com/go/sqlite which is inspired by crawshaw but also uses modernc so no need for cgo.
edit: make links use URL