Firebird

Get, add and update data in Firebird database

Actions3

Overview

This node provides integration with a Firebird database, allowing users to perform common database operations such as executing arbitrary SQL queries, inserting new records, and updating existing records. It is useful in scenarios where you need to interact programmatically with Firebird databases within an n8n workflow, for example:

Running custom SELECT queries to retrieve data.
Inserting new rows into specific tables based on input data.
Updating existing rows identified by a key column.

Typical use cases include automating data synchronization, reporting, or database maintenance tasks involving Firebird.

Properties

Name	Meaning
Timeout	Timeout for the operation (in seconds). Controls how long the node waits for the database response before aborting.

Note: The node also supports other parameters depending on the chosen operation (e.g., query string, table name, columns), but only "Timeout" was provided in the input properties.

Output

The node outputs JSON data representing the results of the database operation:

For executeQuery operation: An array of objects representing rows returned by the SQL query.
For insert operation: An array containing the result metadata from the insert operation.
For update operation: An array containing the result metadata from the update operation.
In case of errors (if "Continue On Fail" is enabled), the output contains an object with an error property describing the issue.

The node does not output binary data.

Dependencies

Requires a Firebird database connection configured via credentials that include host, port, user, password, database path, and optionally charset and role.
Uses the node-firebird npm package internally to connect and execute queries.
Requires the user to provide valid SQL queries or table/column information depending on the operation.
The node expects a timeout value to be set, which it applies to the database connection options.

Troubleshooting

No credentials got returned!
This error occurs if the node cannot find or access the required Firebird API credentials. Ensure credentials are properly configured in n8n.
The parameter "X" is unknown!
When executing parameterized queries, this error indicates that a named parameter used in the query is not included in the list of parameters. Verify that all parameters referenced in the query are correctly specified.
The operation "X" is not supported!
This error means the selected operation is not implemented by the node. Choose one of the supported operations: executeQuery, insert, or update.
Database connection or query errors
Errors during connection or query execution will be thrown unless "Continue On Fail" is enabled, in which case they appear in the output's error field. Check database availability, credentials, query syntax, and permissions.