NocoDB MCP connector

1. Install the SDK

   Node.js

   npm install @scalekit-sdk/node

   Python

   pip install scalekit

   Full SDK reference: Node.js | Python

2. Set your credentials

   Add your Scalekit credentials to your .env file. Find values in app.scalekit.com > Developers > API Credentials.

   .env

   SCALEKIT_ENVIRONMENT_URL=<your-environment-url>
   SCALEKIT_CLIENT_ID=<your-client-id>
   SCALEKIT_CLIENT_SECRET=<your-client-secret>

3. Authorize and make your first call

   Node.js

   quickstart.ts

   import { ScalekitClient } from '@scalekit-sdk/node'
   import 'dotenv/config'
   
   const scalekit = new ScalekitClient(
     process.env.SCALEKIT_ENV_URL,
     process.env.SCALEKIT_CLIENT_ID,
     process.env.SCALEKIT_CLIENT_SECRET,
   )
   const actions = scalekit.actions
   
   const connector = 'nocodbmcp'
   const identifier = 'user_123'
   
   // Generate an authorization link for the user
   const { link } = await actions.getAuthorizationLink({ connectionName: connector, identifier })
   console.log('Authorize NocoDB MCP:', link)
   process.stdout.write('Press Enter after authorizing...')
   await new Promise(r => process.stdin.once('data', r))
   
   // Make your first call
   const result = await actions.executeTool({
     connector,
     identifier,
     toolName: 'nocodbmcp_getbaseinfo',
     toolInput: {},
   })
   console.log(result)

   Python

   quickstart.py

   import os
   from scalekit.client import ScalekitClient
   from dotenv import load_dotenv
   load_dotenv()
   
   scalekit_client = ScalekitClient(
       env_url=os.getenv("SCALEKIT_ENV_URL"),
       client_id=os.getenv("SCALEKIT_CLIENT_ID"),
       client_secret=os.getenv("SCALEKIT_CLIENT_SECRET"),
   )
   actions = scalekit_client.actions
   
   connection_name = "nocodbmcp"
   identifier = "user_123"
   
   # Generate an authorization link for the user
   link_response = actions.get_authorization_link(
       connection_name=connection_name,
       identifier=identifier,
   )
   print("Authorize NocoDB MCP:", link_response.link)
   input("Press Enter after authorizing...")
   
   # Make your first call
   result = actions.execute_tool(
       tool_input={},
       tool_name="nocodbmcp_getbaseinfo",
       connection_name=connection_name,
       identifier=identifier,
   )
   print(result)

What you can do

Connect this agent connector to let your agent:

• Updaterecords records — Update records in a table
• Readattachment records — Read attachments in a record
• Queryrecords records — Query Records from a Table
• Gettableslist records — List tables accessible by user
• Gettableschema records — Get the table schema including fields and views information
• Getrecord records — Fetch a record by ID

Tool list

Use the exact tool names from the Tool list below when you call execute_tool. If you’re not sure which name to use, list the tools available for the current user first.

nocodbmcp_aggregate # Perform aggregations (sum, count, avg, etc.) on table data with filtering and grouping 4 params ▾

Perform aggregations (sum, count, avg, etc.) on table data with filtering and grouping

Name Type Required Description

aggregations array required List of aggregation operations to perform on the table fields.

filterGroups array required List of filter groups; each group produces a separate set of aggregation results.

tableId string required The unique ID of the NocoDB table to aggregate data from.

viewId string optional Optional view ID to scope the aggregation to a specific view's configuration.

nocodbmcp_countrecords # Count Records in a Table 2 params ▾

Count Records in a Table

Name Type Required Description

tableId string required The unique ID of the NocoDB table to count records in.

where string optional Filter expression to limit which records are counted. Uses NocoDB query syntax: (field,operator,value). Combine conditions with ~and / ~or.

nocodbmcp_createrecords # Create records in a table 2 params ▾

Create records in a table

Name Type Required Description

records array required List of records to create. Each record is an object with a 'fields' key containing field name-value pairs.

tableId string required The unique ID of the NocoDB table to insert records into.

nocodbmcp_deleterecords # Delete records in a table 2 params ▾

Delete records in a table

Name Type Required Description

records array required List of records to delete. Each entry must include the record ID.

tableId string required The unique ID of the NocoDB table to delete records from.

nocodbmcp_getbaseinfo # Fetch information about current base 0 params ▾

Fetch information about current base

nocodbmcp_getrecord # Fetch a record by ID 3 params ▾

Fetch a record by ID

Name Type Required Description

recordId string required The ID or primary key value of the record to fetch.

tableId string required The unique ID of the NocoDB table containing the record.

fields string optional Comma-separated list of field names to include in the response. Leave blank to return all fields.

nocodbmcp_gettableschema # Get the table schema including fields and views information 1 param ▾

Get the table schema including fields and views information

Name Type Required Description

tableId string required The unique ID of the NocoDB table to retrieve the schema for.

nocodbmcp_gettableslist # List tables accessible by user 0 params ▾

List tables accessible by user

nocodbmcp_queryrecords # Query Records from a Table 6 params ▾

Query Records from a Table

Name Type Required Description

tableId string required The unique ID of the NocoDB table to query records from.

fields array optional List of field names to include in the response. Returns all fields when omitted.

page number optional Page number for pagination. Starts at 1.

pageSize number optional Number of records to return per page. Default is 50.

sort array optional List of sort options. Each entry specifies a field name and sort direction.

where string optional Filter expression using NocoDB query syntax: (field,operator,value). Combine with ~and / ~or.

nocodbmcp_readattachment # Read attachments in a record 1 param ▾

Read attachments in a record

Name Type Required Description

files array required List of attachment objects from NocoDB. Each attachment must include title, mimeType, size, and either a URL or a path.

nocodbmcp_updaterecords # Update records in a table 2 params ▾

Update records in a table

Name Type Required Description

records array required List of records to update. Each entry must include the record ID and a 'fields' object with the updated values.

tableId string required The unique ID of the NocoDB table to update records in.