LightHouse is a lightweight GUI interface for ClickHouse. Do not confuse it with LightHouse from Google (https://github.com/GoogleChrome/lighthouse). Interface is inspired by Sequel Pro (https://www.sequelpro.com/).
Just clone this repository and use index.html in your browser. If you need to specify username (e.g. XXX), then add "/?user=XXX" to your URL, e.g. "http://127.0.0.1:8123/?user=XXX". If you want to force basic auth instead of URL-based (basic auth does not work with CORS, be careful), then add "/?basic_user=XXX" instead.
You can do the following using LightHouse:
- See tables list, filter it
- See table size on disk and estimated number of rows
- See table contents with filters and sorting
- Execute read-only queries in SQL editor
That's it! It is not meant to be a full-fledged replacement for tabix, for example.
MIT License. Based on:
- AG Grid https://www.ag-grid.com/
- ACE editor https://ace.c9.io/
- jQuery https://jquery.org/
- Tabix patches for ACE Editor https://github.com/tabixio/tabix