Third-Party Database Tools

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.
• Partial 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 SQLAlchemy	Django 3.0.6 django-cockroachdb 3.0.1 3.13.3 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

• Build an App with CockroachDB
• Install a Postgres Client