HFSQL to n8n MCP Server

A Model Context Protocol (MCP) server that enables communication between HFSQL databases (used in WinDev) and n8n workflow automation platform.

Features

• Connect to HFSQL databases via ODBC
• List tables in HFSQL databases
• Describe table structures
• Query data from HFSQL tables
• Migrate data to n8n workflows
• Export query results to JSON

Installation

# Install globally
npm install -g hfsql-n8n-mcp-server

# Or use with npx
npx hfsql-n8n-mcp-server

Prerequisites

• Node.js 14 or higher
• ODBC drivers for HFSQL installed on your system
• n8n instance (if using migration features)

Usage

As an MCP Server for Claude

1. Install the package globally:

   npm install -g hfsql-n8n-mcp-server

2. Add the server to your Claude MCP configuration:

{
  "mcpServers": {
    "hfsql-n8n": {
      "command": "hfsql-n8n-mcp",
      "args": [],
      "env": {}
    }
  }
}

3. Restart Claude to load the MCP server

Available Tools

The MCP server provides the following tools:

connect_hfsql

Connect to an HFSQL database using an ODBC connection string.

{
  "name": "Connection Name",
  "connectionString": "DSN=MyHFSQLDatabase;UID=username;PWD=password"
}

disconnect_hfsql

Disconnect from a previously connected HFSQL database.

{
  "connectionId": "conn_1234567890"
}

list_tables

List all tables in a connected HFSQL database.

{
  "connectionId": "conn_1234567890"
}

describe_table

Get the structure of a table in a connected HFSQL database.

{
  "connectionId": "conn_1234567890",
  "tableName": "Customers"
}

query_table

Execute a SQL query on a connected HFSQL database.

{
  "connectionId": "conn_1234567890",
  "query": "SELECT * FROM Customers WHERE Country = 'France'",
  "limit": 100
}

migrate_to_n8n

Send query results to an n8n webhook for further processing.

{
  "queryId": "query_1234567890",
  "n8nUrl": "https://n8n.example.com/webhook/123456",
  "n8nApiKey": "optional-api-key"
}

export_to_json

Export query results as JSON.

{
  "queryId": "query_1234567890"
}

Example Workflow

1. Connect to an HFSQL database
2. List available tables
3. Describe a table structure
4. Query data from the table
5. Migrate the data to n8n for further processing

License

MIT