DevCraft Text2SQL
(PostgreSQL)
Date: 08-06-2025
Step by step guide
1. On the main admin page click on deploy new use case.
2. Click on ChatBot Interface.
3. Fill the necessary details (Chatbot Name and Email) and click on next.
4. Select the model for your use case. (I have selected Claude 3 Haiku) and then click on
next.
5. Select the language and set the temperature and then click on next.
6. Fill the necessary details for the connection (For Chatbot type select Text2SQL, select DB
Type (I have selected PostgreSQL), give the endpoint for the connection, give the db
user name and password, give the DB Name and set the port number).
7. Scroll down and then click on Test Connection.
8. Click on Next.
9. Give your prompt and click on next.
10. Review the details and then click on Submit.
11. Once you click on submit it will create the stack for Text2SQL (it will take a few minutes
to deploy the stack).
12. You will receive a mail with your credentials and cloud front url to login.
13. Once the stack is deployed it will show CREATE COMPLETE.
14. Go to the cloudfront url and sign in with the credentials sent on mail.
15. Once you login it will ask to create a new password, Change the password.
16. Now you will be redirected to the chatbot page.
17. To change the prompt, model, max tokens and temperature click on settings icon on the
right corner.
18. To change the prompt click on the Prompt button and then click on fetch tables and
choose the table you want to query on.
19. Choose the Tables (max 2), and then click on generate prompt.
20. Once you click on it a new prompt will be generated on the basis of the schema, and
then click on Save Template.
21. Give any prompt (example given below)
22. To delete the use case go to the admin page. Select the use case and then click delete.
23. Once you confirm the deletion, it will take 10 mins to delete the stack.
