Chat
DB-GPT provides multiple chat modes through its Web UI â each tailored for a different use case.
Chat modesâ
| Mode | Description | Requirements |
|---|---|---|
| Chat Normal | General conversation with the LLM | LLM configured |
| Chat Data | Natural language queries on SQL databases (Text2SQL) | Database connected |
| Chat Excel | Upload and query Excel/CSV files | LLM configured |
| Chat Knowledge | RAG conversations over documents | Knowledge base created |
Starting a chatâ
- Open the Web UI at http://localhost:5670
- Click Chat in the sidebar
- Select a chat mode from the dropdown or create a new conversation
- Type your message and press Enter
Quick test
Start with Chat Normal to verify your LLM is working correctly, then try other modes.
Chat Normalâ
The default mode â a direct conversation with the configured LLM.
Features:
- Multi-turn conversation with context retention
- Markdown rendering for formatted responses
- Code syntax highlighting
- Streaming responses
Chat Data (Text2SQL)â
Query your connected databases using natural language. DB-GPT converts your question into SQL, executes it, and presents the results.
How to use:
- First, connect a database in the Database section of the sidebar
- Start a new Chat Data conversation
- Select the target database from the dropdown
- Ask your question in natural language
Example:
User: Show me the top 10 customers by total order amount
DB-GPT: [generates SQL, executes, and displays results in a table]
Supported databases
MySQL, PostgreSQL, SQLite, ClickHouse, DuckDB, MSSQL, Oracle, and more. See Data Sources for the full list.
Chat Excelâ
Upload an Excel or CSV file and query it with natural language.
How to use:
- Start a new Chat Excel conversation
- Upload your file (
.xlsx,.xls, or.csv) - Ask questions about the data
Example:
User: What is the average sales amount per region?
DB-GPT: [analyzes the file and presents results]
Chat Knowledgeâ
Conversational RAG â ask questions and get answers grounded in your uploaded documents.
How to use:
- First, create a knowledge base and upload documents (see Knowledge Base)
- Start a new Chat Knowledge conversation
- Select the knowledge base from the dropdown
- Ask your questions
Features:
- Answers cite source documents
- Supports multiple file formats (PDF, Word, Markdown, TXT, etc.)
- Combines vector search with LLM generation
Conversation managementâ
- History â Previous conversations are saved in the sidebar
- Delete â Right-click a conversation to delete it
- Export â Copy conversation content from the chat window
Next stepsâ
| Topic | Link |
|---|---|
| Set up knowledge base for Chat Knowledge | Knowledge Base |
| Connect databases for Chat Data | Data Sources |
| Build custom chat workflows | AWEL Flow |