ScratchDB is a wrapper around Clickhouse that allows users to input arbitrary JSON and perform analytical queries on it. What sets ScratchDB apart is that it automatically creates tables and columns when new data is added. To get started, users need to clone the repo and start the Clickhouse and localstack servers. Then, they can insert JSON data using a CURL command. To query the data, users can either view it in JSON format or in an HTML table. All queries should be accompanied by an X-Api-Key for authentication. This tool simplifies data analysis by providing a seamless way to work with JSON data in Clickhouse.
https://github.com/scratchdata/ScratchDB