Home
Softono
DataBot

DataBot

Open source JavaScript
16
Stars
3
Forks
9
Issues
3
Watchers
2 months
Last Commit

About DataBot

Self-Hosted AI Assistant for Data Analytics. Designed with Data Security as a Top Priority

Platforms

Web Self-hosted

Languages

JavaScript

Latest Release Docker Pulls Docs

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

Watch the video