Skip to content
kingo-pod

All guides Β· Any Β· The class database

Using CloudBeaver

How to log in to the browser SQL workbench and open the class database.

On this page

CloudBeaver (http://localhost:8978) is a database client that runs in the browser. It is the comfortable way to look at the class database and to write SQL against it.

Two different logins are involved β€” that is the one confusing thing here. First you log in to CloudBeaver itself (student / Kingo2026!), and once, on first use, you give it the database’s password (student / kingo2026). Different passwords, on purpose.

1. Log in to CloudBeaver

Open http://localhost:8978. The first page says β€œNo Connections. Use the top menu to setup connection to your database.” β€” that is normal, it just means you are not logged in yet.

  1. Click the gear icon in the top-right corner.

  2. Choose Login.

    The gear menu in the top right, with Preferences and Login

  3. User name student, password Kingo2026!, then LOGIN.

    The Authentication dialog with user name student

Your name now appears in the blue bar, and the left panel shows Shared β†’ Classroom (PostgreSQL). (The connection is pre-made for you β€” you never have to create one.)

2. Give it the database password β€” once

Click Classroom (PostgreSQL). CloudBeaver asks for the database credentials. If it does not ask, click the ≑ menu next to the connection β†’ Manage β†’ Edit Connection:

The connection menu, Manage, Edit Connection

You land on the MAIN tab. Everything except the password is already filled in β€” check that it says Database classroom (that is the class database; the server also holds the internal databases of Langflow, n8n and Metabase, which you should leave alone), then type the password:

Field Value
Host postgres
Port 5432
Database classroom
Authentication Username/password
User name student
User password kingo2026
Save credentials for all users with access tick it

The MAIN tab of the connection: host postgres, port 5432, database classroom, user student, Save credentials ticked

Then TEST (should say the connection works) and SAVE β€” both buttons sit at the top right. You only do this once: CloudBeaver remembers it from then on.

3. Look at the data

Expand Classroom (PostgreSQL) β†’ classroom β†’ Schemas β†’ public β†’ Tables. The class sample data is there: products, customers, orders. Double-click a table to see its rows.