clickhouser.app

ClickHouse query runner

Clickhouser is a tool inspired on the ClickHouse built-in web client.

It aims to provide some features:

Rich SQL editor.
Interface to give query parameters.
Useful UI.
Download the retreived data on multiple formats (JSON, CSV, TSV, etc)

Disclaimer

The disclaimer document is DISCLAIMER.md

Caveats

Query parameters, null values

Since the query parameters are passed as URL parameters, null values are not supported. If you need to pass a null value, you can use null then the param will be received by the server as an empty string. You can use nullif to transform the empty string to null.

{
  "param1": null
}

SELECT nullif({param1:String}, '') AS param1

Allow "Insecure content"

Due to ClickHouse being accessible through a secure connection (HTTPS), you may encounter an error if you attempt to perform a query on an insecure server (HTTP). There are several workaround options, but only one that depends on you, which is to allow "Insecure Content".

Click on the lock icon in the URL bar, then click "Site settings".

There you will see a list of site permissions. Set "Insecure content".

Now your HTTPS site can access HTTP endpoint.

Contributions

Contributions are what make the Open Source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

If you have a suggestion that would make this better, please fork the repo and create a Pull Request. You can also open an issue with the tag enhancement.

Don't forget to give the project a star ⭐!

Fork the project
Clone the repository
Create your feature branch
Push to your branch
Open a Pull Request

Many thanks!!