Drivers

CrateDB drivers are broken down into 3 groups:

• Fully supported drivers: maintained by the CrateDB team

• Community drivers: developed and maintained by the CrateDB developer community

• Experimental drivers: developped as part of a project and shared for further development by the community

---

Fully supported drivers

Python

CrateDB Python driver

SQLAlchemy dialect : for connecting to CrateDB from Python, using SQLAlchemy.

Localhost --> crate://crate@localhost:4200/?schema=doc
CrateDB Cloud --> crate://<user>:<password>@<cluster>.cratedb.net:4200/?schema=doc&ssl=true

---

Community drivers

Java

PostgreSQL JDBC: The official PostgreSQL JDBC Driver. For connecting to CrateDB from any environment that supports it.

Node.js

node-postgres: A collection of Node.js modules for interfacing with a PostgreSQL database using JavaScript or TypeScript.

Has support for callbacks, promises, async/await, connection pooling, prepared statements, cursors, streaming results, C/C++ bindings, rich type parsing, and more.

.NET

Npgsql: An open source ADO.NET Data Provider for PostgreSQL, for program written in C#, Visual Basic, and F#.

Golang

pgx: A pure Go driver and toolkit for PostgreSQL.

---

Experimental drivers

MicroPython

micropython-cratedb: A MicroPython library connecting to the CrateDB HTTP API.