SQLDrivers

SQL database drivers

The database/sql and database/sql/driver packages are designed for using databases from Go and implementing database drivers, respectively.

See the design goals doc:

http://golang.org/src/pkg/database/sql/doc.txt

Drivers

Drivers for Go's sql package include:

• Apache H2: https://github.com/jmrobles/h2go
• Apache Ignite/GridGain: https://github.com/amsokol/ignite-go-client
• Apache Impala: https://github.com/bippio/go-impala
• Apache Avatica/Phoenix: https://github.com/apache/calcite-avatica-go
• Amazon AWS Athena: https://github.com/uber/athenadriver
• AWS Athena: https://github.com/segmentio/go-athena
• Azure Cosmos DB: https://github.com/btnguyen2k/gocosmos
• ClickHouse (uses native TCP interface): https://github.com/ClickHouse/clickhouse-go
• ClickHouse (uses HTTP API): https://github.com/mailru/go-clickhouse
• CockroachDB: Use any PostgreSQL driver
• Couchbase N1QL: https://github.com/couchbase/go_n1ql
• DB2 LUW and DB2/Z with DB2-Connect: https://bitbucket.org/phiggins/db2cli (Last updated 2015-08)
• DB2 LUW (uses cgo): https://github.com/asifjalil/cli
• DB2 LUW, z/OS, iSeries and Informix: https://github.com/ibmdb/go_ibm_db
• Exasol: (pure Go): https://github.com/exasol/exasol-driver-go
• Firebird SQL: https://github.com/nakagami/firebirdsql
• Genji (pure go): https://github.com/genjidb/genji
• Google Cloud BigQuery: https://github.com/solcates/go-sql-bigquery
• Google Cloud Spanner: https://github.com/rakyll/go-sql-driver-spanner
• MS ADODB: https://github.com/mattn/go-adodb
• MS SQL Server (pure go): https://github.com/denisenkom/go-mssqldb
• MS SQL Server (uses cgo): https://github.com/minus5/gofreetds
• MySQL: https://github.com/go-sql-driver/mysql/ [*]
• MySQL: https://github.com/siddontang/go-mysql/ [**] (also handles replication)
• MySQL: https://github.com/ziutek/mymysql [*]
• ODBC: https://bitbucket.org/miquella/mgodbc (Last updated 2016-02)
• ODBC: https://github.com/alexbrainman/odbc
• Oracle (uses cgo): https://github.com/mattn/go-oci8
• Oracle (uses cgo): https://gopkg.in/rana/ora.v4
• Oracle (uses cgo): https://github.com/godror/godror
• Oracle (pure go): https://github.com/sijms/go-ora
• QL: https://pkg.go.dev/github.com/cznic/ql/driver
• Postgres (pure Go): https://github.com/lib/pq [*]
• Postgres (uses cgo): https://github.com/jbarham/gopgsqldriver
• Postgres (pure Go): https://github.com/jackc/pgx [*]
• Presto: https://github.com/prestodb/presto-go-client
• SAP HANA (uses cgo): https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.03/en-US/0ffbe86c9d9f44338441829c6bee15e6.html
• SAP HANA (pure go): https://github.com/SAP/go-hdb
• SAP ASE (pure go): https://github.com/SAP/go-ase
• SAP ASE (uses cgo): https://github.com/SAP/cgo-ase
• SingleStore: Use any MySQL driver
• Snowflake (pure Go): https://github.com/snowflakedb/gosnowflake
• SQLite (uses cgo): https://github.com/mattn/go-sqlite3 [*]
• SQLite (uses cgo): https://github.com/gwenn/gosqlite - Supports SQLite dynamic data typing
• SQLite (uses cgo): https://github.com/mxk/go-sqlite
• SQLite: (uses cgo): https://github.com/rsc/sqlite
• SQLite: (pure go): https://modernc.org/sqlite
• SQL over REST: https://github.com/adaptant-labs/go-sql-rest-driver
• Sybase SQL Anywhere: https://github.com/a-palchikov/sqlago
• Sybase ASE (pure go): https://github.com/thda/tds
• TiDB: Use any MySQL driver
• Vertica: https://github.com/vertica/vertica-sql-go
• Vitess: https://pkg.go.dev/vitess.io/vitess/go/vt/vitessdriver
• YQL (Yahoo! Query Language): https://github.com/mattn/go-yql
• Apache Hive: https://github.com/sql-machine-learning/gohive
• MaxCompute: https://github.com/sql-machine-learning/gomaxcompute

Drivers marked with [*] are both included in and pass the compatibility test suite at https://github.com/bradfitz/go-sql-test. Drivers marked with [**] pass the compatibility test suite but are not currently included in it.