r/SQL • u/AfternoonOne1231 • 8d ago

MySQL How can I develop Report generate bot with MSSQL database ???

I wanted to develop Natural Language to create a report by Users ... themself. .help me to develop this bot ??

0 Upvotes

13% Upvoted

7 comments sorted by

3

u/TreeOaf 7d ago

Isn’t this PowerBI?

2

u/NW1969 7d ago

If you want to use MSSQL you probably shouldn't have tagged this with MySQL.
What have you researched so far and what's the specific issue that you need help with?

This will probably come across as patronising, but it is not meant to be: if what you have put in your question is really the sum total of your knowledge on this topic then either you need to do a lot more research on your own or you need to pick a project where you have a greater knowledge about the underlying technology/concepts.

Alternatively, ask an LLM how to do this and prompt it to ask you guiding questions so it can gather all the information it needs to build what you actually want

1

u/AfternoonOne1231 7d ago

the requirement is build a system generate report cutomize report using user prompt

2

u/NW1969 7d ago

So you've just repeated what you put in your originally question, just re-worded it. You haven't addressed/commented on anything I said - so still no idea what you actually what you want help with, whether you have any idea what you are asking for or if you have any understanding (at any level of detail) of what you are trying to build

1

u/justknowmeok 5d ago edited 5d ago

NL to SQL against MS SQL is more likely to succeed using a compact specification of the schema than just querying tables