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, ...)
