Connect / Drivers¶
CrateDB connectivity options at a glance.
Choose from a variety of options to connect to CrateDB, and to integrate it with off-the-shelf, third-party, open-source, and proprietary applications, drivers, and frameworks.
Get started
To get started, please learn about typical connection URI formats for CrateDB and its default client applications.
Database URI and connection properties for different drivers.
Use CLI programs or database IDEs to connect to CrateDB.
Learn how to do software testing with CrateDB.
Drivers by language
CrateDB drivers and adapters for supported programming languages, frameworks, and environments.
Protocol Support
CrateDB supports both the HTTP protocol and the PostgreSQL wire protocol, which ensures that many clients that work with PostgreSQL, will also work with CrateDB.
Through corresponding drivers, CrateDB is compatible with ODBC, JDBC, and other database API specifications. By supporting SQL, CrateDB is compatible with many standard database environments out of the box.
The HTTP protocol can be used to connect from environments where PostgreSQL-based communication is not applicable.
Note
While it is generally recommended to use the PostgreSQL interface (PG) for maximum compatibility in PostgreSQL environments, the HTTP interface supports CrateDB bulk operations and BLOBs, which are not supported by the PostgreSQL protocol.
See also