Only giving sql query

[theRMH]

I tried this, but I'm only getting mysql query as output

for eg. after connection I asked

Q: how many users are in table?

A: The SQL query to get the number of users in the table is:

SELECT COUNT(*) FROM users;

Q: in the sale details table, how many entries are there for the date 2024-07-10?

A: I am Sorry. It looks like I made some mistake while trying to form logic or execute the correct logic. Please Try Again. I will try my best

Tip: Either Check the Prompt or Try to Improve it.

Q: in the sale details table, how many entries are there for the date 2024-07-10?
is this prompt ok?

A: Yes, the prompt is ok. The SQL query to get the number of entries in the sale details table for the date 2024-07-10 is:

SELECT COUNT(*) FROM sale_details WHERE date = '2024-07-10';

Q: can you get the count for me?

A: I am Sorry. It looks like I made some mistake while trying to form logic or execute the correct logic. Please Try Again. I will try my best

Tip: Either Check the Prompt or Try to Improve it.

Q: can you get the count for me? for the entries for the date 2024-07-10?

A: I am Sorry. It looks like I made some mistake while trying to form logic or execute the correct logic. Please Try Again. I will try my best

Tip: Either Check the Prompt or Try to Improve it.

[Gaurav-Van]

Thank you for trying this out. From my tests on the local machine, the app works fine, so the issue might be with the Gemini Model [the way it is treating the system prompt] or the database schema. Try re-running the app and ask simpler, direct questions to see if that helps.

If the problem persists, could you provide the Database schema and screenshots or a short video of the app’s execution? This will help diagnose the issue more effectively. This project isn't perfect or ideal; it was just a simple experimental app I made with Gemini. I apologize for any issues you may encounter