Query records, run reports and formulas, and insert or update records in Quickbase. For teams that run business apps, tables and reports on Quickbase. Hosted by usefulapi — connect from Claude, ChatGPT, Cursor, or any MCP client.
Team and Enterprise: an Owner adds the connector for the organization first.
Run this command, then run /mcp in Claude Code to log in:
Add to Cursor or add this to ~/.cursor/mcp.json:
{
"mcpServers": {
"quickbase": {
"url": "https://quickbase.usefulapi.io/mcp"
}
}
}Add to VS Code or add this to .vscode/mcp.json:
{
"servers": {
"quickbase": {
"type": "http",
"url": "https://quickbase.usefulapi.io/mcp"
}
}
}No Add custom MCP server option? It depends on your account or workspace settings: see OpenAI's guide.
Run these commands. The second one opens the login page:
Other MCP clients (Windsurf, Cline, Zed and more): add the URL as a remote MCP server (Streamable HTTP). The client then opens the login page in your browser. Do not add an Authorization header: see Before you connect.
List the tables of an app, then read the fields of one table to learn their ids.
quickbase_list_tables quickbase_list_fields
Query a table with a where clause and a sort order. Read more pages with skip and top.
quickbase_query_records
List the reports of a table, then run one and read its rows.
quickbase_list_reports quickbase_run_report
Insert new records, or update existing ones that match a unique key field. Writes change live data.
Changes data · quickbase_upsert_records
Evaluate a formula against a table, optionally for one record. Nothing is saved.
quickbase_run_formula
The login page asks for your Quickbase realm and Quickbase user token.
Your realm is the part before .quickbase.com in your Quickbase address (for example acme for acme.quickbase.com). Create the user token in your Quickbase user settings. The token is used only to call the Quickbase API on your behalf and to derive a private account id; it is never shown to anyone.
Add only the URL. Do not add an Authorization header or an API key to the client config. The server signs you in with OAuth: the login page asks for your Quickbase realm and Quickbase user token. If the config has such a header, remove it: some clients then send that header instead of the login token, and every call fails with 401.
Turn on the Quickbase connector, then ask in plain words. The AI picks the tools.
| Tool | Type | What it does |
|---|---|---|
quickbase_get_app | read | Get an app Get the main properties of a Quickbase app, including its application variables. Quickbase API: GET /apps/{appId}. |
quickbase_get_app_roles | read | 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 | read | 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 | read | Get a table Get the properties of one table in a Quickbase app. Quickbase API: GET /tables/{tableId}?appId=. |
quickbase_list_table_relationships | read | List table relationships List the parent-child relationships of a table, with their definitions. Quickbase API: GET /tables/{tableId}/relationships. |
quickbase_list_fields | read | 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 | read | Get a field Get one field of a table by its field id, including type-specific properties. Quickbase API: GET /fields/{fieldId}?tableId=. |
quickbase_list_reports | read | List reports List the reports of a table (their ids, names and types). Quickbase API: GET /reports?tableId=. |
quickbase_get_report | read | Get a report Get the definition of one report of a table. Quickbase API: GET /reports/{reportId}?tableId=. |
quickbase_run_report | read | Run a 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 | read | 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 | read | Run a 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 | read | 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 | write | Insert or update 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_usage_status | Usage status (free-tier meter) Report the caller's current usage: the plan, calls used this month, the limit of the plan (the free monthly cap or the Pro fair use limit), remaining, and whether the limit is reached. Read-only; does not count against the meter. | |
quickbase_request_feature | Request a missing feature Tell usefulapi that the user needs something the Quickbase tools cannot do yet (a missing tool, field or filter). Call it only when the user asks for something none of the tools can do, and tell the user that you send the request. Do not call it for errors or for normal requests. Do not include personal data, credentials or customer records. Stored with the product name and the client type (for example Claude or Cursor), without the user's account. At most 5 requests per day. Does not count against the meter. | |
quickbase_upgrade | Upgrade to Pro (unlimited*) Get Pro: unlimited tool calls (fair use limit: 10,000 a month) on Quickbase (the free tier caps monthly usage). Plans: "monthly" — $9/month; "yearly" — $90/year (2 months free). Cancel any time: Pro then runs to the end of the paid period, so it also suits a one-time job. *A fair use limit applies. For heavy use (near Pro's limit): "plus" or "plus_yearly" — Pro+, $39/month or $390/year, unlimited tool calls (fair use limit: 100,000 a month); an existing Pro subscription changes to Pro+ in place (needs confirm: true; the price difference for the rest of the period is charged at once). Otherwise returns a short link to open in your browser (it opens Stripe Checkout); after payment the account upgrades automatically. Does not count against the meter. | |
quickbase_cancel_subscription | Cancel the Pro subscription Cancel the caller's Quickbase Pro subscription at the end of the paid period (no refund for the current period; Pro continues until then, then the free tier applies). Requires confirm: true. Run quickbase_upgrade later to undo the cancel before the period ends. Does not count against the meter. |
| Plan | Price | Limit |
|---|---|---|
| Free | $0 | 50 tool calls / month |
| Proper user | $9/mo · $90/yr | Unlimited* |
*Pro fair use limit: 10,000 tool calls a month on this server. For more, write to [email protected].
Pro covers this Quickbase server only. Subscribe with quickbase_upgrade (it returns a Stripe Checkout link). Cancel any time with quickbase_cancel_subscription: Pro continues to the end of the paid period, with no refund for the current period, and running quickbase_upgrade before then undoes the cancel. Or write to [email protected].
Explore the tables of an app. Query records with a filter. Run a saved report. Insert or update records. Check a formula before you use it. See what you can do for the details.
No. usefulapi is an independent service. It is not affiliated with or endorsed by Quickbase. The server calls the Quickbase API with your own Quickbase access, so it sees only the data that your account can see.
Yes. In Claude, add this server's URL as a custom connector. In ChatGPT, add it as a custom MCP server in Plugins. Then log in once. Cursor, VS Code, Claude Code and Codex work too. See the setup steps.
The login page asks for your Quickbase realm and Quickbase user token. See Before you connect for where to find them.
No. Add only the URL. Do not add an Authorization header or an API key to the client config. The server signs you in with OAuth: the login page asks for your Quickbase realm and Quickbase user token. If the config has such a header, remove it: some clients then send that header instead of the login token, and every call fails with 401.
The login stores them encrypted in the authorization grant of your connection. The server uses them to call the Quickbase API for you and to derive a private account id for usage metering. usefulapi does not show them on any page or in any reply. To stop all access, remove the connector and change or delete these credentials in Quickbase.
Yes, if you approve it. 1 of the 14 Quickbase tools can create or change data. The other 13 are marked read-only. Most MCP clients ask you to approve a tool call before it runs.
The Free plan gives 50 tool calls / month. Pro costs $9/mo or $90/yr, with unlimited tool calls (fair use limit: 10,000 tool calls a month), for this Quickbase server only. Cancel any time: Pro then runs to the end of the paid period. Run quickbase_usage_status to see how many calls you used.
Ask the AI to run quickbase_upgrade: it returns a Stripe Checkout link. To cancel, run quickbase_cancel_subscription. Pro continues to the end of the paid period.
Tell the AI what you wanted to do. It can send the request with quickbase_request_feature. We store the text with the server name, the type of AI client and the tool you tried, not with your account, and read every request when we plan new tools. You can send up to 5 requests per day.
Any client that supports remote MCP servers (Streamable HTTP) with OAuth login: Claude (web and desktop), Claude Code, ChatGPT, Codex, Cursor, VS Code, Windsurf and others.
This is a Model Context Protocol endpoint — meant to be connected from an AI client, not opened in a browser. An invalid_token response at the URL is the auth gate working as designed; clients authenticate automatically.
Need a tool this server does not have, or a connection to another system? We build custom integrations and MCP servers.