Connect to your ScyllaDB database using the universal database tool
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.
A running ScyllaDB instance with accessible CQL interface (default port 9042)
Visit the official DBeaver website and download the version for your operating system (Windows, Mac, Linux).
Follow the standard installation procedure for your OS. Once installed, launch DBeaver.
Before configuring DBeaver, gather the following details (adjust as needed for your environment):
The IP or domain where ScyllaDB is running
127.0.0.1 or scylla.mydomain.com
Default ScyllaDB CQL interface port
9042 (or custom port)
ScyllaDB user credentials
cassandra (default) or custom
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.
In the top menu, click Database > New Connection, or use the New Connection button in the main window.
ScyllaDB is Cassandra-compatible at the CQL level. In DBeaver, select Scylla.
📍 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
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.
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.
Each keyspace is like a schema in other SQL systems.
Within each keyspace, you'll find your data tables. Right-click a table > View Data to see rows.
Double-click your connected database or keyspace, then click SQL Editor to run queries like SELECT * FROM keyspace.table;.
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.