Quickbase MCP by usefulapi
Query records, run reports and formulas, and insert or update records in Quickbase.
我該用這個嗎
品質與安全性
發現項目（1）
- LOWTool 'quickbase_list_table_relationships' name length outside 3-30 range在 quickbase_list_table_relationships 中
根據工具定義與協定合規性的自動化分析。
上下文成本
這是每次將伺服器的工具載入模型上下文時所消耗的約略 token 數量。數量越高，可用於其他工作的注意力就越少。
安裝
一鍵安裝
將以下內容加入你的 `claude_desktop_config.json` 檔案：
{
"mcpServers": {
"quickbase": {
"url": "https://quickbase.usefulapi.io/mcp"
}
}
}遠端端點
https://quickbase.usefulapi.io/mcpstreamable-http它能做什麼
工具清單
工具（14）
🟢quickbase_get_app(app_id)
Get the main properties of a Quickbase app, including its application variables. Quickbase API: GET /apps/{appId}.
輸入結構描述
{
"type": "object",
"properties": {
"app_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The app id (dbid)."
}
},
"required": [
"app_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_get_app_roles(app_id)
List the roles of a Quickbase app. Needs admin access to the app. Quickbase API: GET /apps/{appId}/roles.
輸入結構描述
{
"type": "object",
"properties": {
"app_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The app id (dbid)."
}
},
"required": [
"app_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_list_tables(app_id)
List all tables in a Quickbase app, with their ids, names and record names. Good first call to find table ids. Quickbase API: GET /tables?appId=.
輸入結構描述
{
"type": "object",
"properties": {
"app_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The app id (dbid)."
}
},
"required": [
"app_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_get_table(app_id, table_id)
Get the properties of one table in a Quickbase app. Quickbase API: GET /tables/{tableId}?appId=.
輸入結構描述
{
"type": "object",
"properties": {
"app_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The app id (dbid)."
},
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The table id (dbid)."
}
},
"required": [
"app_id",
"table_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_list_table_relationships(table_id, skip)
List the parent-child relationships of a table, with their definitions. Quickbase API: GET /tables/{tableId}/relationships.
輸入結構描述
{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The child table id (dbid)."
},
"skip": {
"description": "Number of items to skip.",
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
}
},
"required": [
"table_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_list_fields(table_id, include_field_permissions)
List all fields of a table with their ids, labels, types and properties. Use the field ids in record queries. Quickbase API: GET /fields?tableId=.
輸入結構描述
{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The table id (dbid)."
},
"include_field_permissions": {
"description": "true = include the custom field permissions.",
"type": "boolean"
}
},
"required": [
"table_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_get_field(table_id, field_id, include_field_permissions)
Get one field of a table by its field id, including type-specific properties. Quickbase API: GET /fields/{fieldId}?tableId=.
輸入結構描述
{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The table id (dbid)."
},
"field_id": {
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 9007199254740991,
"description": "The field id (fid), an integer."
},
"include_field_permissions": {
"description": "true = include the custom field permissions.",
"type": "boolean"
}
},
"required": [
"table_id",
"field_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_list_reports(table_id)
List the reports of a table (their ids, names and types). Quickbase API: GET /reports?tableId=.
輸入結構描述
{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The table id (dbid)."
}
},
"required": [
"table_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_get_report(table_id, report_id)
Get the definition of one report of a table. Quickbase API: GET /reports/{reportId}?tableId=.
輸入結構描述
{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The table id (dbid)."
},
"report_id": {
"type": "string",
"minLength": 1,
"maxLength": 32,
"description": "The report id, unique to the table."
}
},
"required": [
"table_id",
"report_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_run_report(table_id, report_id, skip, top)
Run a saved report and return its data (records for table reports, rows for summary reports). Quickbase pages the result: pass skip and top to read more. Quickbase API: POST /reports/{reportId}/run?tableId=.
輸入結構描述
{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The table id (dbid)."
},
"report_id": {
"type": "string",
"minLength": 1,
"maxLength": 32,
"description": "The report id, unique to the table."
},
"skip": {
"description": "Number of items to skip.",
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"top": {
"description": "Maximum number of items to return (0 = Quickbase default).",
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
}
},
"required": [
"table_id",
"report_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_query_records(table_id, select, where, sort_by, skip, ...)
Query records of a table with a Quickbase query (where clause, sort, group, select fields). Quickbase pages the result: pass skip and top to read more. Quickbase API: POST /records/query. Example where: {6.EX.'Open'}.
輸入結構描述
{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The table id (dbid) to query."
},
"select": {
"description": "Field ids to return. Omit to return the default fields.",
"type": "array",
"items": {
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 9007199254740991,
"description": "The field id (fid), an integer."
}
},
"where": {
"description": "Quickbase query-language filter, e.g. {6.EX.'Open'}.",
"type": "string",
"maxLength": 4000
},
"sort_by": {
"description": "Sort order, e.g. [{\"fieldId\": 3, \"order\": \"ASC\"}].",
"type": "array",
"items": {
"type": "object",
"properties": {
"fieldId": {
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 9007199254740991,
"description": "The field id (fid), an integer."
},
"order": {
"type": "string",
"enum": [
"ASC",
"DESC"
]
}
},
"required": [
"fieldId",
"order"
]
}
},
"skip": {
"description": "Number of items to skip.",
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
},
"top": {
"description": "Maximum number of items to return (0 = Quickbase default).",
"type": "integer",
"minimum": 0,
"maximum": 9007199254740991
}
},
"required": [
"table_id"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_run_formula(table_id, formula, record_id)
Evaluate a Quickbase formula against a table (optionally for one record) and return the value. Nothing is saved. Quickbase API: POST /formula/run.
輸入結構描述
{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The table id (dbid) the formula refers to."
},
"formula": {
"type": "string",
"minLength": 1,
"maxLength": 4000,
"description": "The formula text, e.g. Sum([Amount],20)."
},
"record_id": {
"description": "Record id (rid) for field references.",
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 9007199254740991
}
},
"required": [
"table_id",
"formula"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🟢quickbase_get_users(emails, app_ids, next_page_token, account_id)
Look up users of the account by email, or list the users of the account. Returns a nextPageToken when more pages exist. Quickbase API: POST /users.
輸入結構描述
{
"type": "object",
"properties": {
"emails": {
"description": "Only these users (email addresses).",
"maxItems": 100,
"type": "array",
"items": {
"type": "string",
"format": "email",
"pattern": "^(?:[A-Za-z0-9_'+\\-]+\\.)*[A-Za-z0-9_'+\\-]*[A-Za-z0-9_+-]@(?:[A-Za-z0-9][A-Za-z0-9\\-]*\\.)+[A-Za-z]{2,}$"
}
},
"app_ids": {
"description": "Only users of these apps (dbids).",
"maxItems": 50,
"type": "array",
"items": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$"
}
},
"next_page_token": {
"description": "The nextPageToken from the previous reply.",
"type": "string",
"maxLength": 4000
},
"account_id": {
"description": "Account id. Omit for the first account of the token.",
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 9007199254740991
}
},
"$schema": "https://json-schema.org/draft/2020-12/schema"
}🔴quickbase_upsert_records(table_id, data, merge_field_id, fields_to_return)
Insert new records into a table, or update existing ones when mergeFieldId names a unique field (for example the key field). Writes live data: it changes records. Each data item maps field ids to values, e.g. [{"6": {"value": "Open"}}]. Quickbase API: POST /records.
輸入結構描述
{
"type": "object",
"properties": {
"table_id": {
"type": "string",
"pattern": "^[A-Za-z0-9]{1,64}$",
"description": "The table id (dbid) to write to."
},
"data": {
"minItems": 1,
"maxItems": 100,
"type": "array",
"items": {
"type": "object",
"propertyNames": {
"type": "string",
"pattern": "^\\d+$"
},
"additionalProperties": {
"type": "object",
"properties": {
"value": {}
},
"required": [
"value"
]
}
},
"description": "Records keyed by field id, e.g. [{\"6\": {\"value\": \"Open\"}}]."
},
"merge_field_id": {
"description": "Unique field id that decides update versus insert.",
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 9007199254740991
},
"fields_to_return": {
"description": "Field ids to return for the written records.",
"maxItems": 100,
"type": "array",
"items": {
"type": "integer",
"exclusiveMinimum": 0,
"maximum": 9007199254740991,
"description": "The field id (fid), an integer."
}
}
},
"required": [
"table_id",
"data"
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}社群
證據