This template starts when you send a question to a webhook. MySQL reads table and column names from information_schema.
ChatGPT writes a SQL query from that schema and your question. MySQL runs the query, and JavaScript formats the rows. Connect MySQL. ChatGPT is a Latenode AI step. Put database credentials on the MySQL connection.
Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.
Full pricing — how CPU seconds work →Workflow preview
The scenario starts when you POST a natural-language question to the Latenode webhook URL.
MySQL lists tables and columns. JavaScript turns that into a short schema prompt.
ChatGPT returns one SQL statement from the schema and your question.
MySQL executes that SQL. JavaScript formats the rows for the response.
Add a webhook trigger. POST the question you want turned into SQL.
Add a MySQL connection with a user that can read information_schema and the tables you query. Put host, database, and user on that connection.
Send schema plus question to ChatGPT, run the returned SQL in MySQL, and format rows in JavaScript. ChatGPT is a Latenode AI step. Prefer a read-only database user.
FAQ
More templates
This template runs on a schedule, opens each URL in a headless browser, and compares visible text to the last snapshot in Latenode Database. When the change crosses your threshold, JavaScript builds RSS XML and Google Drive saves the feed file. Connect Google Drive. Keep snapshots in Latenode Database keyed by URL.
This template receives Cognito Forms submissions on a Latenode webhook, maps the payload, then creates or updates the contact in ActiveCampaign and applies a tag. Paste the webhook URL into Cognito Forms. Connect ActiveCampaign and put the API URL and key on that connection. Map email so matches update the same person.
This template watches a Discord channel for new messages, translates the text with Google Cloud Translate, and posts the translation back to Discord. Connect a Discord bot and Google Cloud Translate. Put the Translate API key on the Google Cloud Translate connection. Point the trigger at the channel you want to translate and pick the target language.
