frankchen021/datastoria repository overview

⁠DataStoria⁠

A modern, AI-powered ClickHouse management console that transforms how you interact with your data and manage your clusters.

⁠🚀 Key Features

⁠🤖 AI-Powered Intelligence

• Natural Language to SQL — Describe your data needs in plain English and receive optimized ClickHouse queries instantly.
• Smart Query Optimization — AI analyzes your queries based on evidence and provides actionable performance improvements.
• Intelligent Visualization — Generate stunning visualizations like time series, pie charts, and data tables with simple prompts.

⁠⚡ Powerful Query Experience

• Advanced SQL Editor — Enjoy syntax highlighting, auto-completion, and query formatting for a seamless coding experience.
• Smart Error Diagnostics — Pinpoint syntax errors instantly with precise line and column highlighting, and get AI-powered fix suggestions with one click.
• Query Log Inspector — Dive deep into query execution with timeline views, topology graphs, and performance analysis.
• One-Click Explain — Instantly understand query execution plans with visual AST and pipeline views.
• Dependency Graph — Visualize table relationships and trace data flows through Materialized Views, Distributed tables, and external systems.

⁠📊 Cluster Monitoring & Management

• Multi-Cluster Support — Manage multiple ClickHouse clusters effortlessly from a single interface.
• Multi-Node Dashboard — Monitor all nodes with real-time metrics, merge operations, and replication status.
• Built-in Dashboards — Access pre-configured panels for query performance, ZooKeeper status, and more.
• Schema Explorer — Navigate databases, tables, and columns with an intuitive tree view.

⁠🔒 Privacy & Security

• 100% Local Execution — All SQL queries run directly from your browser to your ClickHouse server, ensuring complete privacy.
• No Data Collection — Your credentials and query results never leave your machine.
• Bring Your Own API Key — Use your own LLM API keys for AI features, keeping your data under your control.

⁠🐳 Running with Docker

The easiest way to run DataStoria is using the pre-built Docker image:

docker run -d -p 3000:3000 frankchen021/datastoria:latest

Then open http://localhost:3000⁠ in your browser.

The Docker image supports both linux/amd64 and linux/arm64 platforms, so it runs natively on Intel/AMD machines as well as Apple Silicon Macs and ARM-based servers.