See ScyllaDB Keyspaces and Partition Keys on One Canvas

DbSchema gives ScyllaDB teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and documentation that developers, analysts, and stakeholders can navigate in minutes.

DbSchema Database Designer

Download DbSchema See ScyllaDB Features Download ScyllaDB JDBC Driver · All drivers

What happens after you download?

Get to your first ScyllaDB schema diagram in minutes. No account, no credit card.

1
Install in minutes

Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.

2
Connect to ScyllaDB or open a sample

Reverse engineer an existing ScyllaDB database or open a sample model to explore tables, relationships, and indexes.

3
Design, document, and deploy

Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.

Get Started Free

ScyllaDB is a Cassandra-compatible wide-column database written in C++ using the Seastar framework, delivering significantly lower latency than Apache Cassandra by eliminating the JVM garbage collector and using a shard-per-core architecture. Its CQL schema model — keyspaces, tables, partition keys, clustering columns, materialized views, and secondary indexes — is compatible with Cassandra at the protocol level. DbSchema connects to ScyllaDB using the Cassandra JDBC driver and treats the schema identically, providing visual keyspace design, CQL query tools, and schema documentation for high-throughput ScyllaDB deployments.

Browsing ScyllaDB Column Types and Keyspace Structures

ScyllaDB supports the full CQL type system — including collections, frozen types, user-defined types, and duration — as well as ScyllaDB-specific features like tablets for dynamic sharding. DbSchema reads the ScyllaDB system catalog and displays the complete data type and schema structure for each keyspace and table, including partition key and clustering column annotations.

Download DbSchema Free See ScyllaDB Features

Browsing ScyllaDB keyspace column types and structure in DbSchema

CQL Query Builder for ScyllaDB Tables

The DbSchema query builder constructs CQL SELECT statements for ScyllaDB tables, respecting partition key requirements that ScyllaDB enforces at query time. You can select columns, add WHERE conditions that include partition key predicates, and execute queries directly against the cluster — avoiding the ALLOW FILTERING penalty for unqualified queries.

Building CQL queries against a ScyllaDB cluster in DbSchema

Schema Documentation for ScyllaDB Clusters

DbSchema generates HTML documentation from the ScyllaDB schema, capturing keyspace replication strategy settings, table definitions with partition and clustering key designations, materialized view definitions, and index structures. For teams running ScyllaDB at scale across multiple datacenters, this documentation provides a shared reference without requiring direct cluster access.

Auto-generated schema documentation for a ScyllaDB keyspace in DbSchema

ScyllaDB Connection Steps in DbSchema

Because ScyllaDB is protocol-compatible with Apache Cassandra, the connection process follows the same JDBC path:

  1. Install DbSchema on your platform of choice.
  2. Start a new connection and choose ScyllaDB — DbSchema uses its own open-source ScyllaDB JDBC driver, or the DataStax Cassandra JDBC driver works identically.
  3. Enter the host, port 9042 by default, and keyspace, giving a URL like jdbc:cassandra://host:9042/keyspace.
  4. Supply a username and password if the cluster uses CQL authentication (identical to Cassandra's PasswordAuthenticator).
  5. Connect, and DbSchema reads the keyspace catalog into a diagram with partition and clustering key annotations.

For ScyllaDB Cloud, use the hostname and credentials shown in the ScyllaDB Cloud console. For self-managed clusters with client-to-node encryption enabled, configure the SSL parameters in the JDBC URL or in DbSchema's driver settings. DbSchema's ScyllaDB driver is open source; browse the code on GitHub if you want to see how the CQL translation works under the hood.

The Payoff of Running DbSchema Against ScyllaDB

  • Cassandra-compatible tooling — the same JDBC driver and connection approach works for both Cassandra and ScyllaDB.
  • Partition key visualization — see partition and clustering key designations clearly in ER diagrams and table views.
  • Materialized view documentation — capture materialized view definitions in the schema model and generated docs.
  • ScyllaDB Cloud support — connect to cloud-hosted ScyllaDB clusters using standard CQL authentication credentials.
  • High-throughput data inspection — browse ScyllaDB table data from the explorer without writing raw CQL queries.

See your partition keys and clustering columns laid out visually — download DbSchema for free, aim it at your ScyllaDB cluster, and browse the keyspace in minutes.

Teams working with ScyllaDB often use these engines too. Explore dedicated guides and JDBC setup for each.

Browse all 100+ supported databases