get_record
Retrieve a specific database record by providing its ID, base ID, and table name to access stored data in NocoDB.
Instructions
Get a single record by ID
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| base_id | Yes | The ID of the base/project | |
| table_name | Yes | The name of the table | |
| record_id | Yes | The ID of the record |
Implementation Reference
- src/tools/record.ts:110-126 (handler)Handler function for the 'get_record' tool. It takes base_id, table_name, and record_id, calls the NocoDB client's getRecord method, and returns the record.
handler: async ( client: NocoDBClient, args: { base_id: string; table_name: string; record_id: string; }, ) => { const record = await client.getRecord( args.base_id, args.table_name, args.record_id, ); return { record, }; }, - src/tools/record.ts:92-109 (schema)Input schema defining the parameters for the 'get_record' tool: base_id, table_name, and record_id.
inputSchema: { type: "object", properties: { base_id: { type: "string", description: "The ID of the base/project", }, table_name: { type: "string", description: "The name of the table", }, record_id: { type: "string", description: "The ID of the record", }, }, required: ["base_id", "table_name", "record_id"], }, - src/index.ts:55-62 (registration)Registration of tools including recordTools (which contains 'get_record') into the allTools array used by the MCP server for tool discovery and execution.
const allTools = [ ...databaseTools, ...tableTools, ...recordTools, ...viewTools, ...queryTools, ...attachmentTools, ];