Third-Party Database Tools

Warning:
Cockroach Labs will stop providing Assistance Support for this version on November 12, 2021. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, see the Release Support Policy.

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.9 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 Full
Rust postgres 0.17.3 Beta

Data access frameworks (e.g., ORMs)

Language ORM Recommended version Support level
Go GORM
upper/db
1.9.11
v4
Full
Full
Java Hibernate
jOOQ
MyBatis
5.4.19
3.13.2 (must be 3.13.0 or higher)
3.5.5 and 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.2
activerecord 6.0
activerecord-cockroachdb-adpater 6.0.0beta3
Full


Beta
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
Beekeeper Studio 1.6.10 or higher Full
DBeaver 5.2.3 or higher Full
DbVisualizer 10.0.22 or higher Beta
Navicat for PostgreSQL/Navicat Premium 12.1.25 or higher Beta
Pgweb 0.9.12 or higher Beta
Postico 1.5.8 or higher Beta
TablePlus Build 222 or higher Beta
Vault 1.3.9 or higher Beta

Integrated development environments (IDEs)

IDE Recommended version Support level
DataGrip 2021.1 or higher Full
IntelliJ IDEA 2021.1 or higher Beta

Schema migration tools

Tool Recommended version Support level
Flyway 6.4.2 or higher Full

Other tools

Tool Recommended version Support level
Flowable 6.4.2 or higher Full

See also

YesYes NoNo