Skip to main content

Documentation Index

Fetch the complete documentation index at: https://mintlify.com/dataease/SQLBot/llms.txt

Use this file to discover all available pages before exploring further.

SQLBot is an intelligent conversational data analysis platform built by the DataEase team. It connects to your databases and lets users ask questions in plain language, automatically generating SQL queries and returning results as data tables or charts — no SQL expertise required.

Quick Start

Deploy SQLBot and run your first query in minutes

How It Works

Understand the LLM + RAG pipeline behind SQLBot

Connect Datasources

Connect MySQL, PostgreSQL, ClickHouse, and more

MCP Integration

Use SQLBot as an MCP server in AI agents

Why SQLBot?

SQLBot bridges the gap between your data and the people who need it. Instead of writing SQL by hand, users ask questions conversationally and get instant answers backed by your actual database.

Out of the box

Configure a database and an LLM — that’s all you need to start analyzing data

12+ LLM providers

Works with OpenAI, DeepSeek, Gemini, Qianfan, Kimi, and any OpenAI-compatible endpoint

Secure workspaces

Workspace-level data isolation with fine-grained permission controls

Easy to embed

Embed SQLBot as a chat widget in any web app or connect via MCP

Get started in 3 steps

1

Deploy SQLBot

Run SQLBot with Docker on any Linux server. The single-container image includes everything — the backend API, frontend UI, and PostgreSQL database.
docker run -d \
  --name sqlbot \
  --restart unless-stopped \
  -p 8000:8000 \
  -p 8001:8001 \
  -v ./data/sqlbot/excel:/opt/sqlbot/data/excel \
  -v ./data/sqlbot/file:/opt/sqlbot/data/file \
  -v ./data/sqlbot/images:/opt/sqlbot/images \
  -v ./data/sqlbot/logs:/opt/sqlbot/app/logs \
  -v ./data/postgresql:/var/lib/postgresql/data \
  --privileged=true \
  dataease/sqlbot
2

Configure an LLM and datasource

Log in at http://your-server:8000 with admin / SQLBot@123456. Go to System Settings → AI Models to add your LLM, then add a database in Datasources.
3

Start asking questions

Open a new chat, select your datasource, and type a question like “Show me total sales by region for last month.” SQLBot generates the SQL, runs it, and displays the results.

Supported databases

SQLBot connects to all major relational and analytical databases:
DatabaseType
MySQL / MariaDBRelational
PostgreSQLRelational
Microsoft SQL ServerRelational
OracleRelational
ClickHouseAnalytical
ElasticsearchSearch / Analytics
Amazon RedshiftCloud Data Warehouse
Apache HiveBig Data
DM (达梦)Relational
Excel / CSVFile Upload
SQLBot also supports custom database connections through its extensible driver architecture. See the Datasources page for the full list.

Build docs developers (and LLMs) love