Show HN: AGX – Open-Source Data Exploration for ClickHouse (The New Standard?) | Hacker News Reader

Show HN: AGX – Open-Source Data Exploration for ClickHouse (The New Standard?)

github.com

48 pointsdidierfranc3 comments

Hey HN,

We are excited to announce that we’ve open-sourced AGX, a fast and lightweight data explorer for ClickHouse. It is designed for developers and analysts who want to leverage SQL-native querying in an IDE-like environment.

Here’s what makes AGX stand out:

- Built on ClickHouse (accessible via embedded chdb or remote instance).

- IDE-like user interface: features tabs, a Monaco editor, and a fast keyboard workflow.

- Zero setup required: no infrastructure or complex dashboards to manage.

- Ideal for exploring live blockchain data, while also flexible enough for general ClickHouse usage

Think of it as a snappier, developer-oriented alternative to Tabix or Datagrip. You can try out a live instance at https://agx.app!

Open articleView on HN

A bunch of questions.

What shortfalls in Tabix/datagrip were you trying to fix?

What’s the prime use case were you trying to improve on. What did users do before, how is that better with agx?

What do you mean by data explorer? A Table browser? Exploratory data analysis like - ydata-profiling?

How does this connect to clickhouse? Does user data go through your server?

What table library are you using?

Shortfalls in Tabix/DataGrip: While Tabix and DataGrip are powerful, they can be overly complex for quick, intuitive data exploration. AGX simplifies this by providing a more straightforward interface, making querying and visualizing data faster and easier.

Prime Use Case: AGX offers a faster, more flexible alternative to traditional tools. Before AGX, users had to deal with complex setups or configurations. AGX streamlines the experience with an intuitive interface that accelerates data exploration.

Data Explorer: AGX’s data explorer enables efficient querying and interaction with datasets, focusing on ease of use and speed. Unlike tools like YData Profiling, AGX is built for fast data exploration with quick queries and visualizations.

Connection to ClickHouse: AGX connects directly to your ClickHouse instance. No data passes through our servers—you can link your own instance, and we provide a Docker Compose setup in the repository for easy configuration.

Table Library: AGX features a custom-built table component optimized for performance and flexibility. For visualizations, we integrate Plot, enabling users to create real-time, intuitive charts from their queried data.

Initial Goal: Our initial goal was to provide a fully native experience, allowing users to query large datasets locally and access their filesystem directly. However, we expanded AGX to support remote ClickHouse instances, offering more flexibility and enabling deployment for community or customer use.

Love the use of chdb for this!

Reply on news.ycombinator.com