Skip to content
MCP server

Quickbase MCP by usefulapi

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

Install
Runs
Remotely
Version
1.7.0
Listing updated
4 days ago

About Quickbase MCP by usefulapi

Quickbase MCP by usefulapi is an MCP server. It runs as a hosted remote server, so there is nothing to install locally.

Install

Run in a terminal

claude mcp add --transport http quickbase https://quickbase.usefulapi.io/mcp

Add to Settings → Connectors → Add custom connector

https://quickbase.usefulapi.io/mcp
Install in CursorOpens Cursor, which asks you to confirm. Or add it by hand:

Add to ~/.cursor/mcp.json

{
  "mcpServers": {
    "quickbase": {
      "url": "https://quickbase.usefulapi.io/mcp"
    }
  }
}
Install in VS CodeOpens VS Code, which asks you to confirm. Or add it by hand:

Add to .vscode/mcp.json

{
  "servers": {
    "quickbase": {
      "type": "http",
      "url": "https://quickbase.usefulapi.io/mcp"
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json

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

Add to your client's MCP settings (most use this shape)

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

Tools this server provides (14)

Read directly from the server.

quickbase_get_app
Get the main properties of a Quickbase app, including its application variables. Quickbase API: GET /apps/{appId}.
quickbase_get_app_roles
List the roles of a Quickbase app. Needs admin access to the app. Quickbase API: GET /apps/{appId}/roles.
quickbase_list_tables
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=.
quickbase_get_table
Get the properties of one table in a Quickbase app. Quickbase API: GET /tables/{tableId}?appId=.
quickbase_list_table_relationships
List the parent-child relationships of a table, with their definitions. Quickbase API: GET /tables/{tableId}/relationships.
quickbase_list_fields
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=.
quickbase_get_field
Get one field of a table by its field id, including type-specific properties. Quickbase API: GET /fields/{fieldId}?tableId=.
quickbase_list_reports
List the reports of a table (their ids, names and types). Quickbase API: GET /reports?tableId=.
quickbase_get_report
Get the definition of one report of a table. Quickbase API: GET /reports/{reportId}?tableId=.
quickbase_run_report
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=.
quickbase_query_records
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'}.
quickbase_run_formula
Evaluate a Quickbase formula against a table (optionally for one record) and return the value. Nothing is saved. Quickbase API: POST /formula/run.
quickbase_get_users
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.
quickbase_upsert_records
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.

Quickbase MCP by usefulapi FAQ

How do I add Quickbase MCP by usefulapi to Claude Code?

Run this command in your terminal: claude mcp add --transport http quickbase https://quickbase.usefulapi.io/mcp