Introduction to DataStoria

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

What is DataStoria?

DataStoria is a comprehensive web-based interface for ClickHouse that combines powerful query capabilities with artificial intelligence to make database management more intuitive, efficient, and accessible.

Core Philosophy

DataStoria is built on three fundamental principles:

1. Privacy First — All SQL queries execute directly from your browser to your ClickHouse server. Your credentials and query results never leave your machine.

2. AI-Enhanced Intelligence — Leverage cutting-edge AI to convert natural language into optimized SQL queries, get intelligent query suggestions, and generate visualizations automatically.

3. Complete Control — Manage multiple ClickHouse clusters, monitor performance, and explore schemas—all from a single, unified interface.

Key Features

🤖 AI-Powered Intelligence

• Natural Language Data Exploration — 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.

📊 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.

Who is DataStoria For?

DataStoria is designed for:

• Data Engineers who need efficient tools to query and analyze ClickHouse data
• Database Administrators managing multiple ClickHouse clusters from a single UI
• Analysts who want to explore data using natural language
• Developers building applications on top of ClickHouse

What's Next?

Ready to get started? Follow these steps:

1. Installation & Setup — Learn how to install and configure DataStoria
2. First Connection — Connect to your ClickHouse instance and start exploring

Or, if you prefer to try it online first, visit dataStoria.app to experience all features without installation.

---

DataStoria — where data meets intelligence.