# 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