Generate SQL from a business description
Generate complex SQL queries from business requirements
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
Generate the SQL queries to implement these features in a [DATABASE_ENGINE] database: [describe the features]. Include: SELECT queries with JOINs and aggregations, INSERT/UPDATE queries with conflict handling (ON CONFLICT), appropriate indexes, transactions for multi-table operations, and explanations for performance choices.
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Use Cases
Learn more
Check the full skill on Prompt Guide to master this technique from A to Z.
View on Prompt Guide📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Similar Prompts
Generate Mocks and Fixtures for Your Automated Tests
A prompt to automatically generate realistic mocks, stubs and data fixtures adapted to your test framework and use cases.
REST API for ML Model
Exposing a model via an API
Automatically Generate Unit Tests with AI
Automatically generate an exhaustive unit test suite covering nominal cases, edge cases, and error cases for any source code.
Analyze and Optimize Algorithmic Complexity
Analyze the Big O complexity of your algorithms and optimize them with appropriate data structures and more efficient algorithms.