Documentation

nLink Data Tables

A simple, built-in database for your workflows. Save and manage your data instantly without setting up external databases.

Overview

nLink Data Tables is designed specifically for your workflows. Instead of spending time connecting to external databases like MySQL or PostgreSQL for simple tasks, you can use Data Tables to save, update, and manage your data right inside nLink. Enjoy sub-millisecond read/write operations as data never traverses the public internet.

Security First: Your data is isolated and safely stored inside your Workspace. Only authorized workflows can access it.

Auto-Schema (Semi-schema-less)

Unlike rigid relational databases, nLink Tables automatically adapt to your data. When you insert a completely new JSON field that the table has never seen before, the system will organically register the new field into the schema gracefully.

This enables highly agile workflow development where the database shapes itself around your logic, not the other way around.

Key Operations

  • Insert Row
    Append new data gracefully. Map dynamic variables like {{ $json.email }} to table fields. Ideal for saving webhook form submissions permanently.
  • Update Row
    Provide the explicit rowId and a new payload. The engine will merge and update only the specified fields, preserving the rest of the record intact.
  • Delete Row
    Permanently eradicate a row based on its unique identifier.

Advanced Querying (Get Many)

Perform complex queries to extract an array of records using the Get Many operation. nLink provides a powerful dynamic JSON querying engine.

Query Capabilities
  • Filters: Apply nested conditions (e.g. Status == Active AND Age != 18).
  • Sorting: Enforce sorting on any JSON field (Ascending or Descending).
  • Pagination: Set Limit (max 1000) and Offset to manage tables with millions of records without overflowing memory.

Event-Driven Architecture

The BaaS Tables Trigger acts as the central nervous system for your built-in database tables. It allows nLink to function exactly like Supabase or Firebase by triggering serverless functions instantly on data mutations.

Synergy with Triggers: Any Insert, Update, or Delete operation performed by the Data Tables node will automatically broadcast a systemic event. The Trigger node will instantly fire and inject the complete changed data payload directly into your downstream workflow.

Limits & Quotas

To ensure high availability and sub-millisecond latency for all workspaces, the following quotas are strictly enforced at the database level:

  • Maximum Rows: 50,000 rows per Workspace.
  • Maximum Row Size: 512KB per JSON payload.