Data analyst agent querying a NocoDB table via chat

How it works

1. 1.The Chat Trigger creates the session and passes the user's chat input.
2. 2.The Settings node sets the NocoDB table ID m7c7lrw7n0bne4j.
3. 3.An HTTP Request node calls api/v2/meta/tables to fetch table metadata.
4. 4.A Set node extracts column titles into a JSON string.
5. 5.The agent receives the question plus column names and uses the NocoDB getAll tool with a $fromAI-generated where formula to fetch and analyze rows.

Use cases

• Answering natural-language questions about a specific NocoDB table.
• Filtering rows by conditions such as a column value or numeric range.
• Exploring a table's columns and contents interactively.

Requirements

• A valid NocoDB API token credential connected to app.nocodb.com.
• An OpenAI credential with access to the gpt-4o model.
• The table m7c7lrw7n0bne4j and project ppltdbh6c0a30cj must exist for the account, or values must be edited manually.

Setup and testing in n8n

1. Activate the workflow and open the n8n chat interface.
2. Ask which columns the table has and verify they appear in the reply.
3. Request a filter like (Column,eq,Value) and check the tool returns matching rows.
4. Inspect the execution to review the HTTP call, the NocoDB tool call, and the final answer.

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.