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 grouping4 params▾

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

NameTypeRequiredDescription

aggregationsarrayrequiredList of aggregation operations to perform on the table fields.

filterGroupsarrayrequiredList of filter groups; each group produces a separate set of aggregation results.

tableIdstringrequiredThe unique ID of the NocoDB table to aggregate data from.

viewIdstringoptionalOptional view ID to scope the aggregation to a specific view's configuration.

nocodbmcp_countrecords#Count Records in a Table2 params▾

Count Records in a Table

NameTypeRequiredDescription

tableIdstringrequiredThe unique ID of the NocoDB table to count records in.

wherestringoptionalFilter 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 table2 params▾

Create records in a table

NameTypeRequiredDescription

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

tableIdstringrequiredThe unique ID of the NocoDB table to insert records into.

nocodbmcp_deleterecords#Delete records in a table2 params▾

Delete records in a table

NameTypeRequiredDescription

recordsarrayrequiredList of records to delete. Each entry must include the record ID.

tableIdstringrequiredThe unique ID of the NocoDB table to delete records from.

nocodbmcp_getbaseinfo#Fetch information about current base0 params▾

Fetch information about current base

nocodbmcp_getrecord#Fetch a record by ID3 params▾

Fetch a record by ID

NameTypeRequiredDescription

recordIdstringrequiredThe ID or primary key value of the record to fetch.

tableIdstringrequiredThe unique ID of the NocoDB table containing the record.

fieldsstringoptionalComma-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 information1 param▾

Get the table schema including fields and views information

NameTypeRequiredDescription

tableIdstringrequiredThe unique ID of the NocoDB table to retrieve the schema for.

nocodbmcp_gettableslist#List tables accessible by user0 params▾

List tables accessible by user

nocodbmcp_queryrecords#Query Records from a Table6 params▾

Query Records from a Table

NameTypeRequiredDescription

tableIdstringrequiredThe unique ID of the NocoDB table to query records from.

fieldsarrayoptionalList of field names to include in the response. Returns all fields when omitted.

pagenumberoptionalPage number for pagination. Starts at 1.

pageSizenumberoptionalNumber of records to return per page. Default is 50.

sortarrayoptionalList of sort options. Each entry specifies a field name and sort direction.

wherestringoptionalFilter expression using NocoDB query syntax: (field,operator,value). Combine with ~and / ~or.

nocodbmcp_readattachment#Read attachments in a record1 param▾

Read attachments in a record

NameTypeRequiredDescription

filesarrayrequiredList 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 table2 params▾

Update records in a table

NameTypeRequiredDescription

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

tableIdstringrequiredThe unique ID of the NocoDB table to update records in.