list_records

list_records

Retrieve and filter records from an Airtable table using view, formula, sorting, and field selection. Integrates with the Airtable OAuth MCP Server for secure data access.

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