n8n-nodes-mysql-expert

This is an n8n community node that provides an enhanced MySQL node with a prominent "Fields to Include" feature, making it easy to select only the data you need without cluttering your workflow.

Features

• Prominent Field Selection: The "Fields to Include" option is displayed at the top level (like Odoo node), not hidden in an Options dropdown
• Easy Column Selection: Choose from a dropdown list or use expressions to specify column names
• Visual Feedback: Shows column types and nullability in the selection dropdown
• All Columns Option: Quick select * (All Columns) when you need everything
• Full Query Support: Includes filtering, sorting, and limiting capabilities

Installation

Community Nodes (Recommended)

For n8n instances with community nodes enabled:

1. Go to Settings > Community Nodes
2. Select Install
3. Enter n8n-nodes-mysql-expert in the Enter npm package name field
4. Agree to the risks of using community nodes
5. Select Install

Manual Installation

To install manually, run:

cd ~/.n8n
npm install n8n-nodes-mysql-expert

Restart n8n after installation.

From Source

git clone https://github.com/manuelleon/n8n-nodes-mysql-expert.git
cd n8n-nodes-mysql-expert
pnpm install
pnpm build
pnpm link --global
cd ~/.n8n
pnpm link --global n8n-nodes-mysql-expert

Usage

1. Add the MySQL Expert node to your workflow
2. Create or select MySQL credentials (host, port, database, user, password)
3. Select a Table from the dropdown
4. Fields to Include appears prominently - select the columns you need or leave empty for all (*)
5. Optionally add Filters, Sort rules, and configure Options

Key Difference from Standard MySQL Node

| Feature | Standard MySQL Node | MySQL Expert Node | |---------|---------------------|-------------------| | Field Selection Location | Hidden in "Options" dropdown | Prominent at top level | | Field Selection Label | "Output Columns" | "Fields to Include" | | User Experience | Requires extra click to expand | Immediately visible |

Example Use Case

Instead of getting all columns and cleaning data in subsequent nodes:

// Before: Standard MySQL returns all 50+ columns
{ id: 1, name: "John", email: "[email protected]", created_at: "...", updated_at: "...", ... }

// After: MySQL Expert returns only what you need
{ id: 1, name: "John", email: "[email protected]" }

Compatibility

• Requires n8n version 1.0.0 or higher
• Tested with n8n 1.0+
• Supports MySQL 5.7+ and MySQL 8.0+
• Compatible with MariaDB 10.2+

Credentials

The node uses the same credential structure as the standard MySQL node:

• Host (default: localhost)
• Port (default: 3306)
• Database name
• Username
• Password

Development

Prerequisites

• Node.js 18+
• pnpm 9+

Build

pnpm install
pnpm build

Lint

pnpm lint
pnpm lintfix

License

MIT

Support

• Report issues on GitHub Issues
• n8n Community: https://community.n8n.io

Author

Manuel Leon - @manuelleon

Acknowledgments

• Based on the n8n MySQL node
• Inspired by the Odoo node's field selection UX
• Built for the n8n community