NocoDB Plugin for Dify

This plugin integrates NocoDB's database management capabilities with Dify, allowing you to create, retrieve, update, and delete records in your NocoDB databases directly from your Dify applications.

Features

Retrieve Records: Query records from NocoDB tables with filtering, sorting, and pagination support
Create Records: Insert new records into tables with single or bulk operations
Update Records: Modify existing records by ID or perform bulk updates across multiple records
Delete Records: Remove records from tables with single or bulk deletion operations
Get Table Schema: Retrieve complete table structure including column definitions, data types, and constraints
Flexible Filtering: Support for NocoDB's powerful query syntax for complex data retrieval
Bulk Operations: Efficient handling of multiple records in single API calls
Authentication: Secure connection using NocoDB API tokens

Installation

Install the plugin through Dify's Plugin Marketplace.
Configure the plugin with your NocoDB credentials.

Authentication

You'll need the following credentials to use this plugin:

NocoDB URL

The base URL of your NocoDB instance (e.g., or for local installations).

NocoDB API Token

You'll need a NocoDB API Token to authenticate:

Log in to your NocoDB instance
Go to your account settings (click your profile picture in the top right)
Navigate to Account Settings > API Tokens
Click Generate Token or Create New Token
Give your token a descriptive name (e.g., "Dify Integration")
Copy the generated token immediately (it may not be shown again)
Paste the token into the NocoDB API Token field in the plugin configuration

NocoDB Base ID

The ID of the specific NocoDB base/project you want to work with:

Open your NocoDB base in the web interface
The Base ID can be found in the URL:
Copy the Base ID from the URL
Paste it into the NocoDB Base ID field in the plugin configuration

Important: Your API token grants access to your NocoDB bases according to your permissions. Keep it secure and never share it publicly.

Usage

The plugin provides the following tools that can be used in your Dify applications:

Retrieve Records

Queries records from a NocoDB table with support for filtering, sorting, and pagination.

Required parameters:

: Name of the NocoDB table to query

Optional parameters:

: ID of a specific record to retrieve
: Comma-separated list of field names to return
: Filter condition using NocoDB query syntax
: Field name to sort by (prefix with '-' for descending order)
: Maximum number of records to return (default: 25)
: Number of records to skip for pagination (default: 0)

Create Records

Creates new records in a NocoDB table with support for single or bulk operations.

Required parameters:

: Name of the NocoDB table to create records in
: JSON data containing the field values for the new record(s)

Optional parameters:

: Set to true for bulk creation of multiple records (default: false)

Data format:

Single record:
Multiple records:

Update Records

Updates existing records in a NocoDB table by ID or in bulk operations.

Required parameters:

: Name of the NocoDB table to update records in
: JSON data containing the field values to update

Optional parameters:

: ID of the specific record to update (for single record updates)
: Comma-separated list of record IDs for bulk updates

Note: Provide either for single updates or for bulk updates, not both.

Delete Records

Removes records from a NocoDB table with support for single or bulk deletion.

Required parameters:

: Name of the NocoDB table to delete records from

Optional parameters:

: ID of the specific record to delete (for single record deletion)
: Comma-separated list of record IDs for bulk deletion

Note: Provide either for single deletion or for bulk deletion, not both.

Get Table Schema

Retrieves the complete schema information for a NocoDB table, including column names, data types, and constraints.

Required parameters:

: Name of the NocoDB table to get schema information for

This tool is useful for understanding the table structure before creating or updating records.

Usage Examples

Basic Record Operations

Retrieve all records from a table:

Get a specific record:

Create a new customer:

Update a customer's information:

Delete a customer:

Advanced Operations

Filter and sort records:

Bulk operations:

Get table structure:

Error Handling

The plugin provides detailed error messages for common issues:

Authentication failures (invalid tokens)
Table not found errors
Invalid data format errors
Network connectivity issues
Record not found errors

License

This plugin is licensed under the MIT License [blocked].