DB-GPT
DB-GPT is a app in the osFoundry community catalog. AI native data app development framework focused on databases — talk to your SQL/NoSQL data in plain English, generate SQL with context, build text-to-SQL workflows, embed data analysis copilots into your apps. Multi-LLM with built-in support for OpenAI / Claude / Gemini / DeepSeek / Qwen / local. SQLite default for the app's own state; connect any number of upstream Postgres/MySQL/MongoDB databases for the AI to introspect + query. The most mature open data-AI assistant.
Details
- Workspace: osfoundry
- Category: AI
- Pricing: Free
- Access: Community
Features
- Text-to-SQL across Postgres / MySQL / SQLite / MongoDB / Elasticsearch / DuckDB / ClickHouse
- Chat with CSVs + Excel — upload files, ask questions in plain English
- App Center with pre-built data-AI apps (SQL Generator, Data Analysis, RAG over docs)
- Multi-LLM: OpenAI / Claude / Gemini / DeepSeek / Qwen / Ollama / vLLM / custom OpenAI-compatible
- No-code workflow builder for custom data-AI apps
- SQLite default for the app's own state — connected databases stay where they are
Documentation
# DB-GPT
## First-boot
No default password — first user to register becomes admin. Configure auth from the Settings menu.
## Connect a database
**Database → Add Connection** — supports:
- Postgres / MySQL / SQLite / DuckDB / ClickHouse
- MongoDB / Elasticsearch / OceanBase
- File: CSV / Excel
Paste the connection string. DB-GPT introspects the schema and makes it available as context for AI chats.
## Text-to-SQL chat
**Chat → New → pick the connected DB**. Ask questions in plain English:
- 'How many users signed up last month, by referrer?'
- 'Top 10 customers by lifetime value'
- 'Show me orders with shipping anomalies'
DB-GPT generates the SQL, runs it, and presents the result table + a natural-language summary.
## Apps
**App Center** — pre-built data-AI apps:
- **SQL Generator** — NL → SQL with multi-table joins
- **Data Analysis** — chart generation from queries
- **RAG over docs** — add markdown / PDF / web context
- **Custom apps** via no-code workflow builder
## Storage
SQLite at `/data/pilot/` for DB-GPT's own state. The connected databases stay where they are; DB-GPT only stores connection configs + chat history.
How to use DB-GPT in osFoundry
Install DB-GPT into your workspace in one click, then fork it in osStudio to customise the prompts, tools, or configuration for your stack. Anyone in your workspace can pick up where you left off.
Other apps from the community
- CRM — Customer relationship management with contacts, deals, and pipeline tracking.
- Kanban Board — Drag-and-drop task board with swimlanes, labels, and team assignments.
- Helpdesk — Ticket triage and customer support inbox with SLA tracking.
- Page Builder — Block-based page editor with publishing to public URLs.
- Website Builder — Multi-page site builder with CMS, templates, and custom domains.
- Storefront — E-commerce storefront with product catalog, cart, and checkout.