🛢️

DBeaver Setup for ScyllaDB

Connect to your ScyllaDB database using the universal database tool

📖 Overview

This guide walks you through installing and configuring DBeaver (a free, universal database tool) to connect to your ScyllaDB database. Whether you're running ScyllaDB locally, on a VPS, or a container, DBeaver helps you browse tables, run queries, and manage your data more easily.

Requirements

A running ScyllaDB instance with accessible CQL interface (default port 9042)

1️⃣ Install DBeaver

1

Download DBeaver

Visit the official DBeaver website and download the version for your operating system (Windows, Mac, Linux).

2

Install DBeaver

Follow the standard installation procedure for your OS. Once installed, launch DBeaver.

2️⃣ Prepare Your ScyllaDB Connection Information

Before configuring DBeaver, gather the following details (adjust as needed for your environment):

📍 Host/IP Address

The IP or domain where ScyllaDB is running
127.0.0.1 or scylla.mydomain.com

🔌 Port

Default ScyllaDB CQL interface port
9042 (or custom port)

👤 Username

ScyllaDB user credentials
cassandra (default) or custom

🔑 Password

User's password
cassandra (default) or custom

Note: If you changed the api_port in scylla.yaml, ensure you use the correct CQL port for DBeaver connections.

3️⃣ Create a New ScyllaDB Connection in DBeaver

1

Open DBeaver > Database > New Connection

In the top menu, click Database > New Connection, or use the New Connection button in the main window.

DBeaver new connection menu
2

Choose the Cassandra Driver

ScyllaDB is Cassandra-compatible at the CQL level. In DBeaver, select Scylla.

Selecting Scylla driver in DBeaver
3

Connection Settings

📍 Host

Your ScyllaDB host/IP

🔌 Port

Default is 9042 (unless changed)

👤 Username

ScyllaDB user (e.g., cassandra)

🔑 Password

The user's password

🗂️ Keyspace (Optional)

Specific keyspace to connect to, or leave blank to see all

DBeaver connection settings for ScyllaDB
4

Driver Properties & Test Connection

If DBeaver prompts to download missing files, allow it to download the Cassandra driver libraries.

Click Test Connection to verify. If successful, DBeaver displays a success message. Otherwise, check your ScyllaDB logs or firewall settings and try again.

4️⃣ Explore Your ScyllaDB Schema

After a successful connection, you'll see a new database entry in DBeaver's Database Navigator pane. Expand the entry to view your Keyspaces, Tables, and Columns.

🗂️ Keyspaces

Each keyspace is like a schema in other SQL systems.

📊 Tables

Within each keyspace, you'll find your data tables. Right-click a table > View Data to see rows.

⚡ CQL Queries

Double-click your connected database or keyspace, then click SQL Editor to run queries like SELECT * FROM keyspace.table;.

🎯 Final Thoughts

Success!

By configuring a Scylla connection in DBeaver, you can seamlessly browse, query, and manage your ScyllaDB keyspaces and tables. This environment simplifies day-to-day database operations, allowing you to execute CQL queries, manipulate data, and explore schemas from a friendly UI.