On this page 
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
Was this helpful?
