list_records

list_records

Retrieve records from an Airtable table with options to filter, sort, and select specific fields using the Airtable OAuth MCP Server interface.

Instructions

List records from a table with optional filtering

Input Schema

Name	Required	Description
`base_id`	Yes	The Airtable base ID
`fields`	No	Specific fields to include (field name or array of field names)
`filter_by_formula`	No	Airtable formula for filtering
`sort`	No	Sort configuration - array of {field: string, direction: 'asc'\|'desc'}
`table_id`	Yes	The table ID or name
`view`	No	View name or ID

Input Schema (JSON Schema)

{
  "properties": {
    "base_id": {
      "description": "The Airtable base ID",
      "title": "Base Id",
      "type": "string"
    },
    "fields": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "items": {
            "type": "string"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Specific fields to include (field name or array of field names)",
      "title": "Fields"
    },
    "filter_by_formula": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Airtable formula for filtering",
      "title": "Filter By Formula"
    },
    "sort": {
      "anyOf": [
        {
          "items": {
            "additionalProperties": {
              "type": "string"
            },
            "type": "object"
          },
          "type": "array"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "Sort configuration - array of {field: string, direction: 'asc'|'desc'}",
      "title": "Sort"
    },
    "table_id": {
      "description": "The table ID or name",
      "title": "Table Id",
      "type": "string"
    },
    "view": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "description": "View name or ID",
      "title": "View"
    }
  },
  "required": [
    "base_id",
    "table_id"
  ],
  "type": "object"
}

Airtable OAuth MCP Server

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from Airtable OAuth MCP Server

Related Tools

MCP directory API