CockroachDB's support of the PostgreSQL wire protocol enables support for many drivers, ORMs, and other types of third-party database tools.

Support levels

We’ve partnered with open-source projects, vendors, and individuals to offer the following levels of support with third-party tools.

  • Full support indicates that the vast majority of the tool's features should work without issue with CockroachDB. CockroachDB is regularly tested against the recommended version documented here.
  • Beta support indicates that the tool has been tried with CockroachDB, but its integration might require additional steps, lack support for all features, or exhibit unexpected behavior.

If you encounter problems, please open an issue with details to help us make progress toward better support.

Drivers

Language Driver Recommended version Support level
C libpq PostgreSQL 9.5 Beta
C++ libpqxx 7.1.1 (Windows)
4.0.1 or higher (macOS)
Beta
C# (.NET) Npgsql 4.1.3.1 Beta
Clojure java.jdbc 0.7.11 Beta
Go pgx
pq
4.6.0
1.5.2
Full
Full
Java JDBC 42.2.12 Full
Node.js pg 8.2.1 Beta
PHP php-pgsql PHP 7.4.6 Beta
Python psycopg2 2.8.6 Full
Ruby pg 1.2.3 Beta
Rust postgres 0.17.3 Beta

Object-relational mappers (ORMs)

Language ORM Recommended version Support level
Go GORM 1.9.11 Full
Java Hibernate
jOOQ
5.4
3.13.2 (must be 3.13.0 or higher)
Full
Full
Node.js Sequelize sequelize 5.21.9
sequelize-cockroachdb 1.1.0
Beta
Ruby ActiveRecord activerecord 5.2
activerecord-cockroachdb-adpater 5.2.0
Full
Python Django


peewee
PonyORM
SQLAlchemy
Django 3.0.6
django-cockroachdb 3.0.1
3.13.3
0.7.13
SQLAlchemy 1.3.17
sqlalchemy-cockroachdb 1.3.0
Full


Full
Full
Full
Typescript TypeORM 0.2.24 Full

Application frameworks

Framework Data access Recommended version Support level
Spring JDBC
JPA (Hibernate)
jOOQ
MyBatis
See individual Java ORM or driver for data access version support. See individual Java ORM or driver for data access support level.

Graphical user interfaces (GUIs)

GUI Recommended version Support level
DBeaver 5.2.3 or higher Full

Integrated development environments (IDEs)

IDE Recommended version Support level
IntelliJ IDEA 2018.1 Beta

Schema migration tools

Tool Recommended version Support level
Flyway 6.4.2 or higher Full

See also



Yes No