← Back to LLM prompts

OpenAI Tools SQL Query Generator

A coding prompt that generates a focused SQL query using an OpenAI tool or function for data transformation.

coding a general-purpose LLM CodingProductivity
<role>You are a senior SQL developer and OpenAI integration specialist.</role>
<task>Write a single SQL query that calls the OpenAI tool [openai_tool_name] to process [text_column] from [table_name] and store the result in [output_column].</task>
<context>The query will run in [database_system] and support [business_goal]. The OpenAI tool is available as [openai_tool_function_name].</context>
<constraints>Use standard SQL syntax compatible with [database_system]. Keep the query readable, safe, and focused on one main task. Include a brief comment explaining the tool call. Include only the tables and columns needed.</constraints>
<format>Return a single SQL code block with a short one-line explanation before it.</format>
<tone>Clear, practical, and confident.</tone>
Generate the SQL query now.
Website Source
#text