dosubot[bot]
commented
2 weeks ago The error "Missing value for input query" indicates that the input object passed to the FewShotPromptTemplate is missing the required query property. To resolve this, ensure that the input object includes all the necessary properties defined in the inputVariables of the FewShotPromptTemplate.
Here's how you can structure your input object correctly:
-
Ensure
inputObject Contains Required Properties:- The
inputobject should includeinput,top_k, andtable_infoproperties as defined in yourFewShotPromptTemplate.
- The
-
Update the
invokeCall:- When invoking the chain, make sure to pass the correct properties.
Here's an updated version of your main function:
import "reflect-metadata";
import { MemoryVectorStore } from "langchain/vectorstores/memory";
import { SemanticSimilarityExampleSelector } from "@langchain/core/example_selectors";
import { FewShotPromptTemplate, PromptTemplate } from "@langchain/core/prompts";
import { createSqlQueryChain } from "langchain/chains/sql_db";
import { db } from "./db.js";
import { GoogleGenerativeAIEmbeddings } from "@langchain/google-genai";
import { TaskType } from "@google/generative-ai";
import { ChatGoogleGenerativeAI } from "@langchain/google-genai";
import { HarmBlockThreshold, HarmCategory } from "@google/generative-ai";
import few_shots from "./fewShorts.js";
async function main() {
try {
// Initialize example selector
const embeddings = new GoogleGenerativeAIEmbeddings({
apiKey: "apikey",
model: "embedding-001",
taskType: TaskType.RETRIEVAL_QUERY,
});
const exampleSelector =
await SemanticSimilarityExampleSelector.fromExamples(
few_shots,
embeddings,
MemoryVectorStore,
{ k: 5, inputKeys: ["input"] }
);
// Ensure `exampleSelector` correctly selects examples
const selectedExamples = await exampleSelector.selectExamples({
input: "how many employees are there?",
});
console.log("Selected examples:", selectedExamples);
// Define example prompt template
const examplePrompt = PromptTemplate.fromTemplate(
`User input: {input}\nSQL Query: {query}`
);
// Define FewShotPromptTemplate
const prompt = new FewShotPromptTemplate({
exampleSelector,
examplePrompt,
prefix: `You are a MySQL expert. Given an input question, create a syntactically correct MySQL query to run.
Unless otherwise specified, do not return more than {top_k} rows.
Here is the relevant table info: {table_info}
Below are a number of examples of questions and their corresponding SQL queries.`,
suffix: "User input: {input}\nSQL query: ",
inputVariables: ["input", "top_k", "table_info"],
});
// Initialize the LLM (Large Language Model)
const llm = new ChatGoogleGenerativeAI({
apiKey: "apikey",
model: "gemini-pro",
maxOutputTokens: 2048,
safetySettings: [
{
category: HarmCategory.HARM_CATEGORY_HARASSMENT,
threshold: HarmBlockThreshold.BLOCK_LOW_AND_ABOVE,
},
],
});
// Create the SQL query chain
const chain = await createSqlQueryChain({
db,
llm,
prompt,
dialect: "mysql",
});
// Invoke the chain with the question
const result = await chain.invoke({
input: "how many employees are there?",
top_k: 3,
table_info: "foo",
});
console.log("SQL Query result:", result);
} catch (error) {
console.error("Error occurred:", error);
}
}
main();Ensure that the input object passed to the invoke method includes input, top_k, and table_info properties. This should resolve the "Missing value for input query" error [1][2][3].
To continue talking to Dosu, mention @dosu.
psathish10
Checked other resources
Example Code
Database config import mysql from "mysql2/promise"; import { SqlDatabase } from "langchain/sql_db";
// Update with your actual database configuration const dbConfig = { host: "localhost", user: "root", password: "", database: "test", };
let db;
const setupDatabase = async () => { try { const connection = await mysql.createConnection(dbConfig); console.log("Database connected successfully.");
} catch (error) { console.error("Unable to connect to the database:", error); throw error; // re-throw the error to notify the caller } };
setupDatabase(); // Call the setup function to connect to the database
// Export the db instance for use in other modules export { db };
Main Function: import "reflect-metadata"; import { MemoryVectorStore } from "langchain/vectorstores/memory"; import { SemanticSimilarityExampleSelector } from "@langchain/core/example_selectors"; import { FewShotPromptTemplate, PromptTemplate } from "@langchain/core/prompts"; import { createSqlQueryChain } from "langchain/chains/sql_db"; import { db } from "./db.js"; import { GoogleGenerativeAIEmbeddings } from "@langchain/google-genai"; import { TaskType } from "@google/generative-ai"; import { ChatGoogleGenerativeAI } from "@langchain/google-genai"; import { HarmBlockThreshold, HarmCategory } from "@google/generative-ai"; import few_shots from "./fewShorts.js";
async function main() { try { // Initialize example selector const embeddings = new GoogleGenerativeAIEmbeddings({ apiKey: "apikey", model: "embedding-001", taskType: TaskType.RETRIEVAL_QUERY, });
Unless otherwise specified, do not return more than {top_k} rows.
Here is the relevant table info: {table_info}
Below are a number of examples of questions and their corresponding SQL queries.`, suffix: "User input: {input}\nSQL query: ", inputVariables: ["input", "top_k", "table_info"], });
} catch (error) { console.error("Error occurred:", error); } }
main();
Error Message and Stack Trace (if applicable)
Error occurred: Error: (f-string) Missing value for input query
Description
{ "name": "ask_with_ai", "version": "1.0.0", "description": "", "main": "index.js", "type": "module", "scripts": { "test": "echo \"Error: no test specified\" && exit 1" }, "keywords": [], "author": "", "license": "ISC", "dependencies": { "@langchain/community": "^0.2.10", "@langchain/core": "^0.2.6", "@langchain/google-genai": "^0.0.17", "@langchain/openai": "^0.1.3", "@prisma/client": "^5.15.0", "chromadb": "^1.8.1", "config": "^3.3.11", "cors": "^2.8.5", "express": "^4.19.2", "mysql": "^2.18.1", "mysql2": "^3.10.1", "sequelize": "^6.37.3", "typeorm": "^0.3.20", "winston": "^3.13.0", "zod": "^3.23.8" } }
System Info
lateste version of langchian