MCP MeasureMCP Measure

índice observado

Quickbase MCP by usefulapi

Query records, run reports and formulas, and insert or update records in Quickbase.

¿Debería usar esto?

Calidad y seguridad

A
Calidad de la descripción
100%
Integridad del esquema
99%
Calidad de los nombres
79%
Riesgo de envenenamiento
100%
Coincidencia de permisos
100%
Cumplimiento del protocolo
100%

Hallazgos (1)

  • LOWTool 'quickbase_list_table_relationships' name length outside 3-30 rangeen quickbase_list_table_relationships

Basado en el análisis automatizado de las definiciones de herramientas y el cumplimiento del protocolo.

Costo de contexto

~2,710Tokens (definiciones de herramientas)
~1.4 KBTamaño de respuesta típico
Impacto significativo en la atención (2.12% del contexto de 128k)

Este es el número aproximado de tokens que se consumen cada vez que las herramientas del servidor se cargan en el contexto de un modelo. Los recuentos más altos reducen la atención disponible para otras tareas.

Instalar

Instalación con un clic

Agrega esto a tu archivo `claude_desktop_config.json`:

{
  "mcpServers": {
    "quickbase": {
      "url": "https://quickbase.usefulapi.io/mcp"
    }
  }
}

Puntos de conexión remotos

https://quickbase.usefulapi.io/mcpstreamable-http

Qué puede hacer

Inventario de herramientas

Herramientas (14)

🟢 Solo lectura🟡 Escritura🔴 Eliminación⚪ Desconocido
🟢quickbase_get_app(app_id)

Get the main properties of a Quickbase app, including its application variables. Quickbase API: GET /apps/{appId}.

Esquema de entrada

{
  "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.

Esquema de entrada

{
  "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=.

Esquema de entrada

{
  "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=.

Esquema de entrada

{
  "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.

Esquema de entrada

{
  "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=.

Esquema de entrada

{
  "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=.

Esquema de entrada

{
  "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=.

Esquema de entrada

{
  "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=.

Esquema de entrada

{
  "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=.

Esquema de entrada

{
  "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'}.

Esquema de entrada

{
  "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.

Esquema de entrada

{
  "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.

Esquema de entrada

{
  "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.

Esquema de entrada

{
  "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"
}

Comunidad

Califica este servidor

Evidencia

Observaciones recientes

verificadoversión no registrada14 herramientas