> ## Documentation Index
> Fetch the complete documentation index at: https://docs.pinkfish.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# quickbase

> Applications, tables, records, and fields

**Server path:** `/quickbase` | **Type:** Application | **PCID required:** Yes

## Tools

| Tool                                                          | Description                                                           |
| ------------------------------------------------------------- | --------------------------------------------------------------------- |
| [`quickbase_create_record`](#quickbase_create_record)         | Create a new record in a Quickbase table                              |
| [`quickbase_update_record`](#quickbase_update_record)         | Update an existing record in a Quickbase table                        |
| [`quickbase_delete_record`](#quickbase_delete_record)         | Delete a record from a Quickbase table                                |
| [`quickbase_query_records`](#quickbase_query_records)         | Query records from a Quickbase table                                  |
| [`quickbase_get_app_info`](#quickbase_get_app_info)           | Get information about a Quickbase application                         |
| [`quickbase_get_table_info`](#quickbase_get_table_info)       | Get information about a Quickbase table                               |
| [`quickbase_list_tables`](#quickbase_list_tables)             | List all tables in a Quickbase application                            |
| [`quickbase_get_fields`](#quickbase_get_fields)               | Get field definitions for a Quickbase table                           |
| [`quickbase_list_reports`](#quickbase_list_reports)           | List all reports/views for a Quickbase table                          |
| [`quickbase_run_report`](#quickbase_run_report)               | Run a saved report/view in a Quickbase table and return its results   |
| [`quickbase_get_relationships`](#quickbase_get_relationships) | Get table relationships (foreign keys, lookups) for a Quickbase table |

***

## quickbase\_create\_record

Create a new record in a Quickbase table

**Parameters:**

| Parameter        | Type      | Required | Default | Description                                             |
| ---------------- | --------- | -------- | ------- | ------------------------------------------------------- |
| `tableId`        | string    | Yes      | —       | Table ID to create record in                            |
| `fieldData`      | object    | Yes      | —       | Field data as key-value pairs (field ID or name as key) |
| `fieldsToReturn` | string\[] | No       | —       | Specific field IDs to return in response                |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableId": {
        "type": "string",
        "description": "Table ID to create record in"
      },
      "fieldData": {
        "type": "object",
        "additionalProperties": true,
        "description": "Field data as key-value pairs (field ID or name as key)"
      },
      "fieldsToReturn": {
        "type": "array",
        "items": {
          "type": "string"
        },
        "description": "Specific field IDs to return in response"
      }
    },
    "required": [
      "PCID",
      "tableId",
      "fieldData"
    ]
  }
  ```
</Expandable>

***

## quickbase\_update\_record

Update an existing record in a Quickbase table

**Parameters:**

| Parameter        | Type      | Required | Default | Description                              |
| ---------------- | --------- | -------- | ------- | ---------------------------------------- |
| `tableId`        | string    | Yes      | —       | Table ID containing the record           |
| `recordId`       | string    | Yes      | —       | Record ID to update                      |
| `fieldData`      | object    | Yes      | —       | Updated field data as key-value pairs    |
| `fieldsToReturn` | string\[] | No       | —       | Specific field IDs to return in response |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableId": {
        "type": "string",
        "description": "Table ID containing the record"
      },
      "recordId": {
        "type": "string",
        "description": "Record ID to update"
      },
      "fieldData": {
        "type": "object",
        "additionalProperties": true,
        "description": "Updated field data as key-value pairs"
      },
      "fieldsToReturn": {
        "type": "array",
        "items": {
          "type": "string"
        },
        "description": "Specific field IDs to return in response"
      }
    },
    "required": [
      "PCID",
      "tableId",
      "recordId",
      "fieldData"
    ]
  }
  ```
</Expandable>

***

## quickbase\_delete\_record

Delete a record from a Quickbase table

**Parameters:**

| Parameter  | Type   | Required | Default | Description                    |
| ---------- | ------ | -------- | ------- | ------------------------------ |
| `tableId`  | string | Yes      | —       | Table ID containing the record |
| `recordId` | string | Yes      | —       | Record ID to delete            |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableId": {
        "type": "string",
        "description": "Table ID containing the record"
      },
      "recordId": {
        "type": "string",
        "description": "Record ID to delete"
      }
    },
    "required": [
      "PCID",
      "tableId",
      "recordId"
    ]
  }
  ```
</Expandable>

***

## quickbase\_query\_records

Query records from a Quickbase table

**Parameters:**

| Parameter | Type      | Required | Default | Description                           |
| --------- | --------- | -------- | ------- | ------------------------------------- |
| `tableId` | string    | Yes      | —       | Table ID to query                     |
| `where`   | string    | No       | —       | WHERE clause for filtering records    |
| `select`  | string\[] | No       | —       | Field IDs to select (defaults to all) |
| `sortBy`  | object\[] | No       | —       | Sort criteria                         |
| `top`     | number    | No       | —       | Maximum number of records to return   |
| `skip`    | number    | No       | —       | Number of records to skip             |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableId": {
        "type": "string",
        "description": "Table ID to query"
      },
      "where": {
        "type": "string",
        "description": "WHERE clause for filtering records"
      },
      "select": {
        "type": "array",
        "items": {
          "type": "string"
        },
        "description": "Field IDs to select (defaults to all)"
      },
      "sortBy": {
        "type": "array",
        "items": {
          "type": "object",
          "properties": {
            "fieldId": {
              "type": "string",
              "description": "Field ID to sort by"
            },
            "order": {
              "type": "string",
              "enum": [
                "ASC",
                "DESC"
              ],
              "description": "Sort order"
            }
          }
        },
        "description": "Sort criteria"
      },
      "top": {
        "type": "number",
        "description": "Maximum number of records to return"
      },
      "skip": {
        "type": "number",
        "description": "Number of records to skip"
      }
    },
    "required": [
      "PCID",
      "tableId"
    ]
  }
  ```
</Expandable>

***

## quickbase\_get\_app\_info

Get information about a Quickbase application

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## quickbase\_get\_table\_info

Get information about a Quickbase table

**Parameters:**

| Parameter | Type   | Required | Default | Description              |
| --------- | ------ | -------- | ------- | ------------------------ |
| `tableId` | string | Yes      | —       | Table ID to get info for |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableId": {
        "type": "string",
        "description": "Table ID to get info for"
      }
    },
    "required": [
      "PCID",
      "tableId"
    ]
  }
  ```
</Expandable>

***

## quickbase\_list\_tables

List all tables in a Quickbase application

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      }
    },
    "required": [
      "PCID"
    ]
  }
  ```
</Expandable>

***

## quickbase\_get\_fields

Get field definitions for a Quickbase table

**Parameters:**

| Parameter           | Type    | Required | Default | Description                           |
| ------------------- | ------- | -------- | ------- | ------------------------------------- |
| `tableId`           | string  | Yes      | —       | Table ID to get fields for            |
| `includeFieldPerms` | boolean | No       | `false` | Include field permissions in response |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableId": {
        "type": "string",
        "description": "Table ID to get fields for"
      },
      "includeFieldPerms": {
        "type": "boolean",
        "default": false,
        "description": "Include field permissions in response"
      }
    },
    "required": [
      "PCID",
      "tableId"
    ]
  }
  ```
</Expandable>

***

## quickbase\_list\_reports

List all reports/views for a Quickbase table

**Parameters:**

| Parameter | Type   | Required | Default | Description                  |
| --------- | ------ | -------- | ------- | ---------------------------- |
| `tableId` | string | Yes      | —       | Table ID to list reports for |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableId": {
        "type": "string",
        "description": "Table ID to list reports for"
      }
    },
    "required": [
      "PCID",
      "tableId"
    ]
  }
  ```
</Expandable>

***

## quickbase\_run\_report

Run a saved report/view in a Quickbase table and return its results

**Parameters:**

| Parameter  | Type   | Required | Default | Description                         |
| ---------- | ------ | -------- | ------- | ----------------------------------- |
| `tableId`  | string | Yes      | —       | Table ID the report belongs to      |
| `reportId` | string | Yes      | —       | Report ID to run                    |
| `top`      | number | No       | —       | Maximum number of records to return |
| `skip`     | number | No       | —       | Number of records to skip           |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableId": {
        "type": "string",
        "description": "Table ID the report belongs to"
      },
      "reportId": {
        "type": "string",
        "description": "Report ID to run"
      },
      "top": {
        "type": "number",
        "description": "Maximum number of records to return"
      },
      "skip": {
        "type": "number",
        "description": "Number of records to skip"
      }
    },
    "required": [
      "PCID",
      "tableId",
      "reportId"
    ]
  }
  ```
</Expandable>

***

## quickbase\_get\_relationships

Get table relationships (foreign keys, lookups) for a Quickbase table

**Parameters:**

| Parameter | Type   | Required | Default | Description                       |
| --------- | ------ | -------- | ------- | --------------------------------- |
| `tableId` | string | Yes      | —       | Table ID to get relationships for |

<Expandable title="inputSchema">
  ```json theme={null}
  {
    "type": "object",
    "properties": {
      "PCID": {
        "type": "string",
        "description": "Pink Connect ID"
      },
      "tableId": {
        "type": "string",
        "description": "Table ID to get relationships for"
      }
    },
    "required": [
      "PCID",
      "tableId"
    ]
  }
  ```
</Expandable>