Add Context to Prompts for Better SQL Query Generation · Nalanda Prompts

Add Context to Prompts for Better SQL Query Generation

Asked 6 days agoModified yesterdayViewed 8 timesWorks with: Claude 3.5 Sonnet

Guides you on enriching LLM prompts with database schemas, sample data, and table relationships to improve generated SQL quality. Use this when Claude is producing inaccurate or incomplete queries against your database.

<data_sample>
Sample data for employees table:
id | name         | age | department_id | salary  | hire_date
1  | John Doe     | 35  | 2             | 75000.0 | 2020-01-15
2  | Jane Smith   | 28  | 3             | 65000.0 | 2021-03-01
</data_sample>

Source: https://github.com/anthropics/anthropic-cookbook/blob/main/capabilities/text_to_sql/guide.ipynb

few-shot chain-of-thought data-extraction code-generation analysisClaude 3.5 Sonnet

History

Prompt Curator

120rep · asked 6 days ago

0 Responses

Want to respond? Log in.