Skip to main content
Glama
andrewlwn77
by andrewlwn77

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
NameRequiredDescriptionDefault
base_idYesThe ID of the base/project
table_nameYesThe name of the table
record_idYesThe ID of the record

Implementation Reference

  • 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,
      };
    },
  • 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,
    ];

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/andrewlwn77/nocodb-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server