MCP server
Quickbase MCP by usefulapi
Query records, run reports and formulas, and insert or update records in Quickbase.
- 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/mcpAdd to Settings → Connectors → Add custom connector
https://quickbase.usefulapi.io/mcpInstall 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