← Tools

MySQL

Workflows, steps and prerequisites from cases tagged “MySQL”.

Check official pricing and availability. Model versions must be checked in each case.

Name taken from case tags; product identity and official information await review.

Models, versions and aliases in cases

These labels share this page. Original identifiers are preserved; versions may differ in capability or availability.

Find a workflow with this tool →

Tasks covered in this library

2 tag-associated cases; tool roles have not all been reviewed. This is not the product’s full capability range.

Latest case update:2026-10-25

Workflows, prerequisites & evidence

Content & Creative

Generate SQL Queries from Schema Only — n8n AI Agent Template

Input: natural language question + local database schema file → Processing: AI Agent generates SQL based solely on schema (no data access) → Output: SQL query and execution results (or direct answer)

Read the case’s method and prerequisites

Requires an n8n instance; configure openAiApi and mySql credentials. Before first run, prepare a MySQL server and import your database (the template example uses Chinook, available on GitHub). Execute the top half of the workflow once to fetch and save the schema locally. Subsequent chat triggers read this local file instead of reconnecting to the remote database.

n8n · mysql

Associated by case tags. Verify costs, permissions and actual results in the case.

Money, Bills & Benefits

Auto-Generate Monthly Financial Reports with n8n + Gemini AI

SQL data → AI analysis → HTML report → Outlook email, automatically delivered monthly per Cost Center

Read the case’s method and prerequisites

Prerequisites: n8n instance (self-hosted or Cloud), MySQL/PostgreSQL/ERPNext database, Microsoft Outlook or Gmail account, Google Gemini API Key. Understanding of your data schema is required to adapt SQL queries. Template defaults to ERPNext schema (tabBudget Group Detail, tabGL Entry, tabProject, tabEmployee). The Filter node hardcodes 'AI DEPARTMENT' for testing; update or remove for production.

n8n · mysql · outlook

Associated by case tags. Verify costs, permissions and actual results in the case.