DataBot – AI Assistant for Data Analytics

• With DataBot, you can ask analytical questions, create visualizations, generate reports and produce forecasts, all using natural language
• It's self-hosted and free for personal use.
• It can be easily embedded in websites or apps (e.g. Salesforce)
• DataBot combines rich features, strong security, and affordability in one solution.

Running DataBot

Trying out DataBot is very easy and takes just a few minutes. Follow the instructions here.

Features

• 🔍 Data exploration
• 📊 Data visualization
• 📝 Report generation
• 📈 Forecasting
• 🔗 Integration with BI tools (currently Metabase)
• 🌐 Multi-language support
• 🎤 Voice transcription
• 🗄️ Supporting major SQL and NoSQL databases
• 🧩 JSON columns support
• 💬 Query explanation
• 💻 Easy embedding in your website or app
• 📦 Portable mode and containerized deployment
• 🛡️ Fine-grained access control
• 🙈 Data obfuscation (using dynamic data masking)
• 👥 Role-based access control (RBAC)
• 🔐 Row-level security (RLS)
• 🔑 Single sign-On (SSO)
• 🏢 Multi-tenant support
• 🎨 White-labelling
• 🎯 Semantic/metadata layer grounding questions in defined metrics and business logic
• 🧪 Text-to-SQL test suite to verify expected behavior before rollout
• ✅ SQL validation (validates the generated SQL before execution)
• 🔄 Self-correction loop (if SQL fails, the error is sent back to the LLM for auto-correction)
• 🛡️ Safety guardrails (SELECT-only queries, row limits, injection prevention)

Data Sources

• 🗄️Major SQL and NoSQL Databases
• 📊 Dashboards from BI Tools (currently Metabase is supported)
• 🌐Web Search

We are also exploring adding the following data sources. Let us know if any of them would be helpful for your use case.

• 📄Unstructured files (PDF, Word, TXT, ...)
• 🧾Structured files (CSV, Excel, ...)
• 🔌Custom Connectors (Google Sheets, AWS CloudWatch Logs, ...)

Watch DataBot in Action