MySQL Product Search for Insurance
detail.loadingPreview
Searches for insurance products in a MySQL database based on user-provided criteria.
🚀Ready to Deploy This Workflow?
About This Workflow
Overview
This workflow node allows you to query a MySQL database to find suitable insurance products. It dynamically constructs a SQL query based on input parameters extracted from an AI or other sources, such as city, state, number of lives, and age of the policyholder. The results are ordered by price and creation date, and limited to the top 3 matches.
Key Features
- Dynamically generates SQL queries based on provided parameters.
- Filters products by city, state, modality, and removal status.
- Calculates eligibility based on the number of lives (holder + dependents).
- Determines product price based on the age of the holder.
- Orders results by price and creation date.
- Limits the output to the top 3 matching products.
How To Use
- Connect the
MySQL Toolnode to a preceding node that provides the necessary input parameters (e.g., city, state, holderAge, dependentsCount, etc.). These parameters should be accessible via expressions like{{ $fromAI("cityName") }}. - Configure the
MySQL Toolnode with your MySQL database credentials. - Ensure the
tableNameandqueryparameters are correctly set up to match your database schema and search logic.
Apps Used
Workflow JSON
{
"id": "395322c1-cbf2-4301-8e6c-d078cf811729",
"name": "MySQL Product Search for Insurance",
"nodes": 0,
"category": "Database Operations",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: 395322c1-cbf2...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Verification Info
Related Workflows
Discover more workflows you might like
Execute Microsoft SQL Query
Execute custom SQL queries against a Microsoft SQL database.
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
Automate Competitor Tracking with Crunchbase & ClickUp
Streamline competitor analysis by automatically fetching data from Crunchbase and creating review tasks in ClickUp. Stay informed about market changes without manual effort.
Automate Shipment Tracking with Telegram and n8n
Streamline your logistics operations by automating shipment tracking with Telegram and n8n. This workflow allows drivers to easily share updates, and ensures timely notifications to your team.
Telegram Profanity & Toxicity Filter
This n8n workflow automatically monitors incoming Telegram messages for profanity and toxic language. It leverages Google's Perspective API to analyze message content, and if a message is deemed inappropriate, the workflow sends an automated warning response back to the sender.
Automate File & Folder Organization: Move, Copy, and Restructure with Ease
Streamline your file management processes with this n8n workflow. Automate the relocation and restructuring of files and folders, ensuring your data is always organized and accessible.