n8n-nodes-banco-firebird

A Firebird database node for n8n.

n8n is a fair-code licensed workflow automation platform.

Installation

Follow the installation guide in the n8n community nodes documentation.

Usage

This node allows you to interact with Firebird databases in n8n workflows.

Operations

• Test Connection: Test database connectivity
• Execute Query: Run SQL queries against the database
• Insert: Insert data into tables
• Update: Update existing records

Connection Parameters

You can configure Firebird connection parameters in two ways:

Option 1: Using Node Parameters (Recommended for Dynamic Database Switching)

All connection parameters are available directly in the node configuration:

• Host: Database server address (default: 127.0.0.1)
• Database: Database file path or alias (default: database.fdb)
• User: Username for authentication (default: SYSDBA)
• Password: Password for authentication (default: masterkey)
• Port: Server port (default: 3050)
• Client Library Path: Path to FBCLIENT.DLL (default: C:\Windows\SysWOW64\FBCLIENT.DLL)
• Wire Crypt: Encryption level (default: Disabled for compatibility)
• Auth Plugin: Authentication plugin (default: Legacy_Auth for compatibility)
• Role: Connection role (optional)
• Page Size: Database page size (default: 4096)
• Lowercase Keys: Convert keys to lowercase (default: false)
• Reconnect Interval: Reconnection interval in milliseconds (default: 1000)

This approach allows you to switch between different databases dynamically within your workflow.

Option 2: Using Credentials (Legacy)

You can still use the traditional credentials approach by configuring:

• Host
• Database path
• Username
• Password
• Port (default: 3050)
• Wire Crypt (set to Disabled for compatibility)
• Auth Plugin (set to Legacy_Auth for compatibility)
• Client Library Path (optional)

Firebird 5.0 Configuration

For Firebird 5.0, you need to configure the server to allow connections without wire encryption. Add these lines to your firebird.conf file:

# ===========================
# Configurações para compatibilidade com n8n
# ===========================

# Desabilitar criptografia de rede (OBRIGATÓRIO)
WireCrypt = Disabled

# Configurar plugins de autenticação do servidor
AuthServer = Legacy_Auth, Srp256, Srp

# Configurar plugins de autenticação do cliente (Windows)
AuthClient = Legacy_Auth, Srp256, Srp, Win_Sspi

# Configurar gerenciador de usuários
UserManager = Srp

# Compatibilidade de tipos de dados
DataTypeCompatibility = 3.0

# Acesso remoto habilitado
RemoteAccess = true

After making these changes, restart the Firebird service:

# Windows
net stop FirebirdGuardianDefaultInstance
net start FirebirdGuardianDefaultInstance

Troubleshooting

Common Issues

1. "Incompatible wire encryption levels": Configure WireCrypt = Disabled in firebird.conf
2. "No matching plugins on server": Configure AuthServer and AuthClient plugins
3. Connection timeout: Check if Firebird service is running and port is accessible

Test Connection

Use the "Test Connection" operation to verify your setup before running queries.

Example: Dynamic Database Switching

With the new node parameters, you can easily switch between different databases in your workflow:

1. Configure multiple Firebird nodes with different database parameters
2. Use workflow variables to dynamically set database connections
3. Switch between environments (development, staging, production) using the same workflow

Example workflow setup:

• Node 1: Connect to development database (host: dev-server, database: dev_db.fdb)
• Node 2: Connect to production database (host: prod-server, database: prod_db.fdb)
• Use conditional logic to choose which database to use based on workflow context

Resources

• n8n community nodes documentation
• Firebird Documentation

Version history

0.1.2

• NEW: Added dynamic database connection parameters
• NEW: All connection settings are now available as node parameters
• NEW: Support for switching between multiple databases dynamically
• IMPROVED: Better flexibility for multi-environment workflows
• IMPROVED: No longer requires credentials for basic operations

0.1.1

• Added Test Connection operation
• Improved Firebird 5.0 compatibility
• Fixed wire encryption issues

0.0.3

• Initial release

Author

Mateus Borges

• GitHub: @mateusborges

License

MIT