Download Cassandra JDBC Driver

Download the Cassandra JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

Connect Cassandra in DbSchema Install the driver, open a connection, reverse engineer your schema, and sync changes visually.

Cassandra guide Free Download

About the Cassandra JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Cassandra. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Cassandra driver uses its own syntax — see the connection details below.

The Cassandra JDBC driver

Apache Cassandra is a highly scalable, distributed NoSQL database designed for high availability with no single point of failure. It uses a wide-column data model and is ideal for write-intensive workloads, time-series data, and globally distributed applications.

For connecting to Cassandra we wrote our own open-source JDBC driver, available on GitHub.

The Apache Cassandra JDBC URL

Required File(s): cassandra-driver.jar
Java Driver Class: com.dbschema.Cassandra.JdbcDriver
JDBC URL: jdbc:cassandra://host1[:port1][,host2[:port2],...[,hostN[:portN]]][/[keyspace];dataCenter[&options]]
Website: DbSchema.com

The driver is written on top of the native Cassandra Java Driver. For connecting to multiple hosts you can pass an URL like: jdbc:cassandra://host1[:port1][,host2[:port2],...[,hostN[:portN]]][/[keyspace];dataCenter[&options]]

Find the DataCenter using nodetool status or nodetool -h ::FFFF:127.0.0.1 status

Connecting to Cassandra with SSL

Connecting using SSL is possible setting the parameters: javax.net.ssl.trustStore=/path/to/client.truststore&javax.net.ssl.trustStorePassword=password123& javax.net.ssl.keyStore=/path/to/client.keystore&javax.net.ssl.keyStorePassword=password123
These parameters can be also set in DbSchema.vmoptions file in the installation folder or ./DbSchema.app/Contents/vmoptions.txt on Mac OS, and add:

    -Djavax.net.ssl.trustStore=/path/to/client.truststore
    -Djavax.net.ssl.trustStorePassword=password123
    # If you're using client authentication:
    -Djavax.net.ssl.keyStore=/path/to/client.keystore
    -Djavax.net.ssl.keyStorePassword=password123

Downloading the Cassandra JDBC Driver

Download Cassandra JDBC Driver

The driver archive is a zip file. Unzip the downloaded archive to get the driver files. The driver source code can be found on GitHub repository. Check the GitHub link for details on how to use the driver and configure SSL.

The driver is written on top of the standard DataStax Java driver.

DbSchema and Apache Cassandra

DbSchema's open-source Cassandra JDBC driver maps keyspaces and tables into a visual schema explorer. Use DbSchema to browse partition keys, clustering columns, and secondary indexes, and to run CQL queries through the SQL editor interface.