AccuSaga Core Features

1. Natural Language to SQL

Convert natural language questions into optimized SQL queries with AI

• Intent classification (TEXT_TO_SQL, GENERAL, USER_GUIDE)
• SQL reasoning pipeline for complex queries
• Automatic SQL generation & validation
• SQL correction & error diagnosis
• Follow-up SQL generation
• Explainable SQL with step-by-step reasoning

2. Conversational Analytics

Real-time Q&A with context-aware conversations

• Instant answers (under 10 seconds)
• Context-aware with history tracking
• Question rephrasing for clarity
• Multi-turn conversations
• Natural language interface

3. Automatic Chart Generation

Generate visualizations from natural language descriptions

• Auto-generate Vega-Lite visualizations
• Bar, Line, Area, Pie charts
• Grouped & Stacked bar charts
• Multi-line charts
• Chart adjustment via natural language
• Interactive visualizations

4. AI-Powered Insights

Intelligent recommendations and insights generation

• SQL answer generation (natural language)
• Question recommendations (4 categories)
• Descriptive, Segmentation questions
• Comparative, Data quality questions
• Relationship recommendations
• Semantics descriptions

5. Semantic Layer (MDL)

Unified business context and definitions

• Model Definition Language (MDL)
• Model definitions (tables)
• Calculated fields with expressions
• Relationships (ONE_TO_ONE, MANY_TO_MANY)
• Metrics with dimensions & measures
• Time grain support
• Custom SQL views
• Hidden columns for sensitive data

6. Knowledge Base

Centralized repository of all insights and queries

• Centralized repository of insights
• AI-powered semantic search
• Historical question indexing
• SQL pairs indexing (question-SQL examples)
• Table description indexing
• User instruction indexing
• Document retrieval

7. Multi-Database Support

Connect to 10+ databases and data warehouses

8. Security & Governance

Enterprise-grade security for sensitive data

• Row-level access control
• Column-level access control
• Role-based access control (RBAC)
• Detailed audit logs
• Multi-tenant support
• Air-gapped deployment support
• Data policy enforcement across UI and APIs

9. Multi-Agent AI System

Orchestrated AI agents for complex analytics workflows

• Specialized agents for different tasks
• Agent coordination and communication
• Workflow automation
• Distributed processing

10. LLM Provider Integration

Support for 10+ LLM providers and embedding models

• OpenAI embeddings (text-embedding-3)
• Azure OpenAI embeddings
• Ollama embeddings (local)

11. Agentic-RAG System

Intelligent retrieval-augmented generation for accurate insights

• Semantic search across knowledge base
• Context-aware retrieval
• Hybrid search (vector + keyword)
• Re-ranking for relevance
• Source attribution

12. Dashboard & Visualization

Real-time dashboards with interactive visualizations

• Real-time dashboards
• Auto-generated visualizations
• Vega-Lite specifications
• Interactive charts
• Customizable layouts
• Drag-and-drop interface

13. Automated Reporting

Schedule and automate report generation and delivery

• Scheduled reports
• Recurring reporting automation
• Multi-format exports (PDF, Excel, PPT)
• Custom report templates
• Email delivery
• Slack/Teams integration

14. MCP Support

Model Context Protocol for enhanced AI capabilities

• Enhanced context management
• Improved AI reasoning
• Better prompt engineering
• Context-aware responses

15. Monitoring & Observability

Comprehensive monitoring for system performance

• Performance metrics tracking
• Query performance monitoring
• System health checks
• Alerting and notifications
• Usage analytics
• Audit trail visualization