QuickBase MCP Server

Instructions

Implementation Reference

• src/quickbase/client.ts:169-181 (handler)

  Core implementation of quickbase_get_record tool: Queries QuickBase records endpoint with where clause `{3.EX.${recordId}}` to fetch specific record by ID (field 3 is record ID), optionally selecting specific fields.

  async getRecord(tableId: string, recordId: number, fieldIds?: number[]): Promise<any> {
    const params: any = { from: tableId };
    if (fieldIds) {
      params.select = fieldIds;
    }
  
    const response = await this.axios.post('/records/query', {
      ...params,
      where: `{3.EX.${recordId}}`
    });
    
    return response.data.data[0] || null;
  }

• src/index.ts:231-247 (registration)

  MCP server tool call handler registration in switch statement that validates args and delegates to QuickBaseClient.getRecord() method.

  case 'quickbase_get_record':
    if (!args || typeof args !== 'object') {
      throw new Error('Invalid arguments');
    }
    const record = await this.qbClient.getRecord(
      args.tableId as string, 
      args.recordId as number, 
      args.fieldIds as number[]
    );
    return {
      content: [
        {
          type: 'text',
          text: JSON.stringify(record, null, 2),
        },
      ],
    };

• src/tools/index.ts:267-279 (schema)

  Tool metadata and JSON input schema definition for quickbase_get_record, used for tool listing and validation.

  {
    name: 'quickbase_get_record',
    description: 'Get a specific record by ID',
    inputSchema: {
      type: 'object',
      properties: {
        tableId: { type: 'string', description: 'Table ID' },
        recordId: { type: 'number', description: 'Record ID' },
        fieldIds: { type: 'array', items: { type: 'number' }, description: 'Specific field IDs to retrieve' }
      },
      required: ['tableId', 'recordId']
    }
  },