I'm facing blocker for generate sql based on the text

Hey , I just need to generate sql, based on the text, the issue is my database was huge like 80+ tables. I can’t give the huge schema into the prompt, it throw limit error. then how can i use all schema to generate any sql based on given schema