ClickCat is a firendly user interface that lets you search,explore and visualize your ClickHouse Data.

Overview

image

ClickCat is a firendly user interface that lets you search,explore and visualize your ClickHouse Data.

We provides the following features,you can access http://8.135.49.240:8080/ to try directly without any installing.

Features

  • An online SQL editor which can run your SQL code without any installing.
  • You can observe all processes and mutations. For those unfinished processes, you can kill them in ui.
  • The Metrics contains Cluster Analysis,Data Analysis,Query Analysis.

The next we are developing

  • A Discover module like Kibana Discover which can quickly search and filter your data, get information about the structure of the fields.

  • A Graph Anaylsis feature enable you to model,explore,visualize connected data hided in Clickhouse.

  • Time-series Prediction use time series modeling to detect anomalies in your current data and forecast trends based on historical data in Clickhouse.

Install

git clone https://github.com/open-botech/ClickCat.git
cd ClickCat
git checkout master
yarn install
# Run on http://0.0.0.0:9000/  
yarn start
Comments
  • Docker

    Docker

    Hello!

    Is there docker image?

    I found the docker-compose.yml file at the root of the project, but when I do docker-compose up -d I get this:

    
    bral@bral:~/ClickCat$ docker-compose up -d
    [+] Running 9/10
     ⠿ grafana Pulled                                                                                                                               22.0s
       ⠿ a0d0a0d46f8b Pull complete                                                                                                                  1.1s
       ⠿ 4f1fa8aedbc9 Pull complete                                                                                                                  1.1s
       ⠿ e324af75ad14 Pull complete                                                                                                                  2.0s
       ⠿ d87e8a722712 Pull complete                                                                                                                  2.6s
       ⠿ 829bf7e67ede Pull complete                                                                                                                 17.8s
       ⠿ 4f4fb700ef54 Pull complete                                                                                                                 17.9s
       ⠿ 734c6eb74c92 Pull complete                                                                                                                 18.0s
       ⠿ 3908f3b034a4 Pull complete                                                                                                                 18.1s
     ⠿ ckvision Error                                                                                                                                2.2s
    [+] Building 2.7s (8/9)                                                                                                                               
     => [internal] load build definition from Dockerfile                                                                                             0.1s
     => => transferring dockerfile: 170B                                                                                                             0.0s
     => [internal] load .dockerignore                                                                                                                0.1s
     => => transferring context: 78B                                                                                                                 0.0s
     => [internal] load metadata for docker.io/library/node:16-slim                                                                                  0.0s
     => [internal] load build context                                                                                                                0.8s
     => => transferring context: 54.74MB                                                                                                             0.7s
     => [1/5] FROM docker.io/library/node:16-slim                                                                                                    0.3s
     => [2/5] ADD . /app                                                                                                                             1.0s
     => [3/5] WORKDIR /app                                                                                                                           0.1s
     => ERROR [4/5] RUN yarn set version 3.1.1                                                                                                       0.6s
    ------                                                                                                                                                
     > [4/5] RUN yarn set version 3.1.1:                                                                                                                  
    #0 0.588 node:internal/modules/cjs/loader:936                                                                                                         
    #0 0.588   throw err;                                                                                                                                 
    #0 0.588   ^                                                                                                                                          
    #0 0.588                                                                                                                                              
    #0 0.588 Error: Cannot find module '/app/.yarn/releases/yarn-3.1.1.cjs'
    #0 0.588     at Function.Module._resolveFilename (node:internal/modules/cjs/loader:933:15)
    #0 0.588     at Function.Module._load (node:internal/modules/cjs/loader:778:27)
    #0 0.588     at Function.executeUserEntryPoint [as runMain] (node:internal/modules/run_main:77:12)
    #0 0.588     at node:internal/main/run_main_module:17:47 {
    #0 0.588   code: 'MODULE_NOT_FOUND',
    #0 0.588   requireStack: []
    #0 0.588 }
    ------
    failed to solve: executor failed running [/bin/sh -c yarn set version 3.1.1]: exit code: 1
    bral@bral:~/ClickCat$ 
    
    opened by bralbral 4
  • Improve user experience for SQL UI

    Improve user experience for SQL UI

    The following improvements were made

    • use filtering capabilities of el-tree-v2 to allow searching for non-empty tables, searching by database, table and column name
    • add a shortcut to run SQL queries
    • provide more clear table statistics
    • make tabs which require additional backends (ML and graph) switchable

    In additionto UX imprrovements I added a Helm chart which is useful for deployment in Kubernetes.

    Finally, ClickHouse login credentials can be populated via URL parameters. This allows to build "deep links" into ClickHouse instances. In my case there's a kind of portal with many ClickHouse instances and we want to simplify the user access to those.

    opened by dgloeckner 1
  • Usability issues in SQL query tab

    Usability issues in SQL query tab

    No shortcut for run

    CTRL+R or CMD+R on MacOS are common shortcuts for a run action. It would be awesome if I would not have to switch to my mouse to click the play button. image

    Statistics unclear

    See the section marked in yellow.I assume 1178 rows refers to scanned rows in ClickHouse, not returned rows.

    clickhouse-client has a much clearer way to show all of this info. Could we try to replicate this?

    2 rows in set. Elapsed: 0.008 sec. Processed 8.19 thousand rows, 589.90 KB (1.04 million rows/s., 75.24 MB/s.)
    

    image

    Column / table searchbar is hard to use

    It's not clear what the searchbar is supposed to do. Filter tables based on column names?

    • It's very slow when a few thousand tables are in the schema ** I understand that this is a client-side implementation and network latency might be an issue.
    • There should be a way to filter tables by name to work with large schemas.

    image

    List scroll bar is almost invisible due to color scheme

    Dark grey on dark grey just doesn't do it ;)

    image

    opened by dgloeckner 4
  • Feature request: make machine learning and graph tabs switchable

    Feature request: make machine learning and graph tabs switchable

    I guess both of those tabs require a backend and at least for our use case of a standalone lightweight ClickHouse UI they don't make sense.

    It seems to be fairly easy to make those switchable, e.g. via env variables.

    I could work on a PR if there's the chance for it to get merged.

    opened by dgloeckner 1
  • Hard-coded ProxyTargetList

    Hard-coded ProxyTargetList

    Hi guys,

    I found this hard-coded ProxyTargetList.

    What's the purpose of that?

    const init: ProxyTargetList = {
      '/ml': {
        target: 'http://172.16.1.192:8080/',
        changeOrigin: true,
        rewrite: (path) => {
          return path.replace(/^\/ml/, '')
        }
      }
    }
    
    opened by dgloeckner 0
Owner
海博科技
山东海博科技致力于大数据,人工智能技术在平安城市运营和公安信息化建设上的创新应用,提供智慧公安解决方案和驾驶员自助体验机等产品
海博科技
Yet Another Clickhouse Client for Node.js

yacc-node - Yet Another Clickhouse Client for NodeJS Introduction yacc-node is a zero depencies Clickhouse Client written in Typescript. Installation

Antonio Vizuete 3 Nov 3, 2022
"Jira Search Helper" is a project to search more detail view and support highlight than original jira search

Jira Search Helper What is Jira Search Helper? "Jira Search Helper" is a project to search more detail view and support highlight than original jira s

null 41 Dec 23, 2022
Visualize, modify, and build your database with dbSpy! An open-source data modeling tool to facilitate relational database development.

Visualize, modify, and build your database with dbSpy! dbSpy is an open-source data modeling tool to facilitate relational database development. Key F

OSLabs 115 Dec 22, 2022
🍭 search-buddy ultra lightweight javascript plugin that can help you create instant search and/or facilitate navigation between pages.

?? search-buddy search-buddy is an open‑source ultra lightweight javascript plugin (* <1kb). It can help you create instant search and/or facilitate n

Michael 4 Jun 16, 2022
🟢 Music player app with a modern homepage, fully-fledged music player, search, lyrics, song exploration features, search, popular music around you, worldwide top charts, and much more.

Music-player-app see the project here. 1. Key Features 2. Technologies I've used Key Features: ?? Fully responsive clean UI. ?? Entirely mobile respo

suraj ✨ 3 Nov 16, 2022
This project is built with JavaScript, Webpack, HTML & CSS, Leaderboard api. When user clicks on Refresh button it hits the api and responds with the data, The user can also post data to the api

leaderboad Description the project. this project is about the leaderboad i did during Microverse to build a website for adding Data to the API and fet

Emmanuel Moombe 4 May 30, 2022
Instant spotlight like search and actions in your browser with Sugu Search.

Sugu Search Instant spotlight like search and actions in your browser with Sugu Search. Developed by Drew Hutton Grab it today for Firefox and Chrome

Drew Hutton (Yoroshi) 9 Oct 12, 2022
💻 Countries Web is a web application that lets you view data for all the countries in the world and filter them by country name and continent.

?? Countries Web View Demo This is the Countries Web, a web application that lets you view data for all the countries in the world and filter them by

João Gabriel 5 Jun 23, 2022
The Trino datasource allows to query and visualize Trino data from within Grafana.

Trino Grafana Data Source Plugin The Trino datasource allows to query and visualize Trino data from within Grafana. Getting started Drop this into Gra

Starburst 13 Nov 3, 2022
A to-do list Web application that lets the user add, remove and reorder to do lists and checks a task when completed with a button to delete all completed task

TO DO LISTS A Web application that lets the user add, remove and reorder to do lists Built With Html,JS,CSS Webpack and other dependencies Git, Github

Promise Okechukwu 14 Nov 1, 2022
Explore units, stats and more

AoE 4 Explorer An useful visualization and UI to explore units, their stats and abilities and all possible upgrades and technologies for Age Of Empire

AoE4 World 20 Dec 8, 2022
Explore Alveus Sanctuary with an interactive map and find out more about the different buildings on the property.

Alveus Sanctuary Interactive Map Explore Alveus Sanctuary with an interactive map and find out more about the different buildings on the property. htt

Matt Cowley 3 Aug 16, 2022
Explore very large trees in the browser

Taxodium Taxodium is a client-side Javascript tool for exploring extremely large trees. It is currently used for Cov2Tree, a display of the global SAR

Theo Sanderson 63 Dec 18, 2022
Explore movies, tv shows. Built with Next.js, Tailwind CSS, Redux, Firebase, TypeScript, TMDB v3 API.

This is a Next.js project bootstrapped with create-next-app. Getting Started First, run the development server: npm run dev # or yarn dev Open http://

Sinan Bekar 11 Dec 4, 2022
Explore a webpage effortless.

Page Explorer A browser extension to explore webpages with ease. Available on Firefox now! https://addons.mozilla.org/en-US/firefox/addon/page-explore

null 51 Jul 6, 2022
🦀 A browser extension to explore rust cargo dependencies on GitHub repos

cratehub On every GitHub repository or folder with a Cargo.toml file, scroll to the bottom of the page to see a list of its npm dependencies and their

一块木头 23 Aug 10, 2022
a toy project to explore Stable Diffusion locally through a nodeJS server.

SD-explorer foreword this is a toy project to run the Stable Diffusion model locally. if you're after something more solid, I'd suggest you use WebUI

nicolas barradeau 18 Dec 18, 2022
A lightweight application to explore the mystery of the ISS.

3D ISS Tracker About Web application developed for the challenge of NASA International Space Apps Challenge 2022 Website Screenshot: Feature Show grou

RenHao 7 Dec 9, 2022