Exploring Clockhouse's /play User Interface

  

ClickHouse offers a user interface accessible via the /play endpoint, which allows you to interact directly with the ClickHouse server.

 

To access it, open your browser and navigate to http://127.0.0.1:8123/play. You’ll be presented with an interface similar to the one shown below.

 

        

Type the following statement, and click on Run button to execute.

 

SHOW DATABASES

 

Upon successful execution of the statement, you will see all the available databases.

 

In the top-left corner, you'll see an icon with four vertical lines. Click on it to expand and view all the databases available on the ClickHouse server.

 

 

Click on any database, it list all the tables available in that database.

 

 

Previous                                                    Next                                                    Home