dataease/SQLBot
SQLBot
🔥 基于大模型和 RAG 的智能问数系统，对话式数据分析神器。Text-to-SQL Generation via LLMs using RAG.
Features
- Conversational Data Exploration - Supports multi-turn dialogue for iterative query refinement, drill-down analysis, and trend prediction on database results.
- Multi-turn Interaction Managers - Maintains a conversational state machine that tracks query history and user intent across turns for iterative SQL refinement.
- Query Expansion and Refinement - Maintains multi-turn dialogue context to iteratively refine SQL queries based on user follow-ups.
- Schema Grounding Retrievers - Retrieves relevant database schema and business context from a vector store to ground LLM-generated SQL in accurate table knowledge.
- Text-to-SQL Translators - Retrieves relevant database schema and business context to ground LLM-generated SQL queries in accurate table knowledge.
- Natural Language Data Queries - Converts plain English questions into SQL queries using LLMs and RAG, returning data and visualizations.
- Natural Language Querying - Asks questions about data in plain English and gets SQL-generated answers without writing database queries.
- Natural Language to SQL - Converts plain-language questions into executable SQL using large language models and retrieval-augmented generation.
- Multi-Database Connectors - Manages connections to various database types and their table schemas for querying across heterogeneous data sources.
- LLM-Based SQL Generation - Converts natural language questions into executable SQL queries using large language models and retrieval-augmented generation.
- RAG-Enhanced Generators - Enriches query accuracy by retrieving relevant database schema and context before generating SQL with an LLM.
- Conversation State Machines - Maintains a conversational state machine that tracks query history and user intent across turns for iterative SQL refinement.
- Custom Prompt Editors - Configures custom prompts, business term glossaries, and example SQL calibrations to improve generation accuracy.
- Contextual Accuracy Improvements - Refines SQL generation through custom prompts, term libraries, and example SQL calibration to match specific business scenarios.
- Embeddable Query Interfaces - Provides an embeddable web iframe, popup, or MCP call for integrating natural language querying into external tools.
- Custom Prompt and Knowledge Integrations - Improves SQL generation accuracy by configuring custom prompts, a business term glossary, and example SQL calibrations.
- Business Context Configurations - Ships custom prompt, term library, and example SQL configuration to improve SQL generation accuracy for specific business contexts.
- Multi-Source Data Integration - Manages connections to various database types and tables so the system can query across different data sources.
- Data Visualization Dashboards - Arranges multiple query-generated charts into a single dashboard for monitoring or reporting.
- Interactive Data Exploration Tools - Drills into query results by analyzing, explaining, verifying, or predicting trends through follow-up questions.
- Query Interfaces - Exposes the query system as an embeddable iframe, popup, or MCP call for integration into external workflow tools.
- Query Result Visualizers - Transforms SQL query results into charts and dashboards automatically through a configurable rendering layer.
- Natural Language Dashboard Assemblers - Aggregates multiple query-generated visualizations into a single dashboard view for monitoring or reporting.
- Query-Sourced Dashboard Layouts - Arranges charts from multiple question-answer sessions into a unified dashboard layout for reporting or monitoring.
- Workspace Access Restrictions - Isolates data and queries within workspaces, enforcing boundaries and fine-grained permissions for secure usage.
- Data Access Permission Configurators - Isolates resources at the workspace level and enforces detailed data permissions to ensure secure and compliant usage.
- External Application Integrations - Integrates the question-answering capability into external applications via web components or MCP calls.
- Externally-Rendered UI Embeds - Embeds the natural-language query interface as externally-rendered UI in external workflow tools.
- Query-Generated Dashboard Assemblers - Arranges multiple query-generated charts into a single dashboard for monitoring or reporting purposes.
- Drill-Down Analysis Tools - Enables iterative drill-down analysis on query results, including explanation, validation, and trend prediction.
- Conversational Analytics Embedding - Embeds a conversational query interface as an iframe, popup, or MCP call into external workflow tools and platforms.
- Conversational Interface Embeds - Embeds a conversational query interface as a web component, popup, or MCP call into third-party tools.
- Embeddable Search Interfaces - Exposes the query system as an embeddable iframe, popup, or MCP call for integration into external workflow tools.
- Analytics Interfaces - Provides an embeddable web iframe, popup, or MCP call for integrating natural language querying into external workflow tools.
- Dashboard Builders - Aggregates multiple query-generated visualizations into a unified dashboard for monitoring and reporting.
