🛢️

# 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.

2

### Choose the Cassandra Driver

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

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

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.