01
Problem
Business users need to query changing database schemas and export results without writing SQL, while long-running generation and delivery tasks must remain safe and responsive.
02
Role
Backend engineer for the LLM workflow, microservice integration, export pipeline and streaming user experience.
03
Architecture
- 01
Spring Cloud Alibaba microservices - 02
Schema-aware NL2SQL prompt construction - 03
Redis locking for idempotent export tasks - 04
SSE delivery for progressive status and results
04
Key contributions
- Generated model context from live MySQL schema metadata for grounded SQL.
- Built Excel export with EasyExcel, POI and Pinyin4j plus tool-triggered email attachments.
- Protected distributed tasks with Redis locks and exposed progress over SSE.
05
Evaluation
- Functional scenarios cover schema inspection, SQL generation, export concurrency and streamed delivery; no unsupported accuracy claim is published.
06
Technology
07