Third-Party Tools Supported by Cockroach Labs

CockroachDB's support of the PostgreSQL wire protocol makes most PostgreSQL drivers, ORM frameworks, and other types of third-party database tools designed for PostgreSQL compatible with CockroachDB. Cockroach Labs guarantees official support for a set of popular PostgreSQL tools, which we list on this page.

Support levels

Cockroach Labs has partnered with open-source projects, vendors, and individuals to offer the following levels of support with third-party tools:

  • Full support indicates that Cockroach Labs is committed to maintaining compatibility with the vast majority of the tool's features. CockroachDB is regularly tested against the recommended version documented here.
  • Beta support indicates that Cockroach Labs is working towards full support for the tool. The primary features of the tool are compatible with CockroachDB (e.g., connecting and basic database operations), but full integration may 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.

For a list of tools supported by the CockroachDB community, see Third-Party Tools Supported by the Community.

Drivers

Language Driver Recommended version Support level
C libpq PostgreSQL 13 Beta
C# (.NET) Npgsql 4.1.3.1 Beta
Go pgx
pq
4.6.0
1.5.2
Full
Full
Java JDBC 42.2.9 Full
JavaScript pg 8.2.1 Beta
Python psycopg2 2.8.6 Full
Ruby pg 1.2.3 Full

Data access frameworks (e.g., ORMs)

Language Framework Recommended version Support level
Go GORM
upper/db
1.9.11
v4
Full
Full
Java Hibernate
(including Hibernate Spatial)
jOOQ
MyBatis
5.4.30 (must be 5.4.19 and higher)


3.13.2 (must be 3.13.0 or higher)
3.5.5 and higher
Full


Full
Full
JavaScript/TypeScript Sequelize


TypeORM
sequelize 5.21.9
sequelize-cockroachdb 1.1.0
0.2.24
Beta


Full
Ruby ActiveRecord
RGeo/RGeo-ActiveRecord
activerecord 5.2
activerecord-cockroachdb-adpater 5.2.2
activerecord 6.0
activerecord-cockroachdb-adpater 6.0.0beta3
Full


Beta
Python Django
(including GeoDjango)
peewee
PonyORM
SQLAlchemy
Django 3.1.3
django-cockroachdb 3.1.3
3.13.3
0.7.13
SQLAlchemy 1.3.17
sqlalchemy-cockroachdb 1.3.0
Full


Full
Full
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
DataGrip 2021.1 or higher Full
IntelliJ IDEA 2021.1 or higher Full

Schema migration tools

Tool Recommended version Support level
Flyway 7.1.0 or higher Full
Liquibase 4.2.0 or higher Full

Other tools

Tool Recommended version Support level
Flowable 6.4.2 or higher Full

See also

YesYes NoNo