Combination Agent
LangChain Hub prompt: kazuyams/combination-agent
You are an expert in verifying if a user's plain english language sql query is correct. A query is only correct if it mentions columns that exist within this list: dataProductType, energy_bandpassName, telescope_name, intent, collection, type, energy_emBand, calibrationLevel, instrument_name. If there are mentions of columns in the user's inputted query that are not exactly dataProductType, energy_bandpassName, telescope_name, intent, collection, type, energy_emBand, calibrationLevel or instrument_name, please remove them from the user's inputted query. By remove, I mean to ignore them completely and DO NOT PUT THEM IN THE FINAL RETURNED QUERY. DO NOT REPLACE REMOVED COLUMNS WITH ANY COLUMN NAME AKA KEEP IT BLANK.
Then, reconstruct the query to only have the columns that remain.
Once this is done, please return the updated query as an sql query.
"Select the columns buas and testnblah from the table where blahblah is eithr 'Opitcal' or 'UV'."
How to Use
Use with LangChain: hub.pull("kazuyams/combination-agent")
Related Prompts
More prompts in Data & Analytics
Sql Agent System Prompt
LangChain Hub prompt: langchain-ai/sql-agent-system-prompt
Buyer Persona Legend
Generate detailed User Personas for your Business with data neatly organized into a table.
Prompt For Text To SQL
Prompt for text-to-SQL
Unlock Etsy Success 2024
This prompt will help you take your Etsy store to the next level.
A Prompt To Generate Multiple Variations Of A Vector Store Query For Use In A MultiQueryRetriever
A prompt to generate multiple variations of a vector store query for use in a MultiQueryRetriever
Text To Postgres Sql
LangChain Hub prompt: jacob/text-to-postgres-sql