Summary

DataStoria is an AI-native console for ClickHouse, addressing cluster diagnostics, query generation, optimization, and visualization. It targets engineers and power users, offering streamlined workflows, enhanced query performance, and simplified data exploration through intelligent AI features.

How It Works

Employs an AI-native architecture using LLMs for natural language data exploration, smart query optimization via schema analysis and evidence-based recommendations, and intelligent visualization generation. It supports a wide array of LLM providers and integrates with GitHub Copilot, offering a skill-based agent system for efficient multi-turn conversations. Browser-side rendering of visualizations ensures data privacy.

Quick Start & Requirements

• Prerequisites: Node.js v22+, pnpm.
• Build from Source: Clone repo, npm install --force, npm run dev. Access at http://localhost:3000.
• Docker: docker run -d -p 3000:3000 frankchen021/datastoria:latest. Access at http://localhost:3000. Docker image supports linux/amd64 and linux/arm64.
• Docs: Demo/Screenshots: docs.datastoria.app. User Manual, Deployment, LLM Config, Auth guides available.

Highlighted Details

• AI-driven Natural Language Data Exploration, Smart Query Optimization, and Intelligent Visualization.
• Broad LLM provider support (OpenAI, Anthropic, Google, Groq, etc.) and GitHub Copilot integration.
• Advanced SQL Editor with syntax highlighting, auto-completion, and smart error diagnostics.
• Comprehensive cluster monitoring: multi-cluster management, multi-node dashboards, system log inspection, and dependency graphing.
• Strong privacy focus: 100% local query execution, no data collection, BYO API keys, browser-side rendering.

Maintenance & Community

The provided README does not detail specific contributors, sponsorships, or community channels like Discord/Slack.

Licensing & Compatibility

Licensed under the Apache License 2.0, permitting commercial use and integration with closed-source projects.

Limitations & Caveats

The README does not explicitly list limitations, known bugs, or deprecation warnings. The npm install --force command during local build may suggest potential dependency management complexities.