Quickbase MCP by usefulapi

io.usefulapi由 usefulapi.io 发布官方发布者v1.2.3更新于 Nov 5, 2026

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

发布方自己的服务:Ably MCP by usefulapi

已验证Streamable HTTP可网页运行数据库数据与分析

概览

AI 生成的概览

托管的 Quickbase MCP 服务器,让助手查看应用与表、查询记录、运行报表和公式,并插入或更新记录。

可以做什么
  • 查看应用:获取应用属性与变量,列出角色、表、表关系、字段及字段详情
  • 浏览报表:列出某张表的报表、读取报表定义,并分页运行已保存的报表
  • 按 where 条件、排序、分组和指定字段查询记录,并在表上计算公式且不保存任何内容
  • 按邮箱查找账户用户或列出用户
  • 向表中插入或更新记录,可按唯一字段合并
  • 查看当月用量、提交缺失功能请求,以及管理或取消付费方案
适用场景
适合在 Quickbase 中工作时使用:让助手了解应用结构、拉取并汇总记录或已保存报表、测试公式,或直接在对话中写入和更新记录。
运行要求
远程 MCP 端点,只需添加 URL,无需本地安装。通过 OAuth 登录,首次连接时需提供 Quickbase realm 和 Quickbase 用户令牌,服务器按用户存储。部分工具(如列出应用角色)需要应用的管理员权限。
安装前请注意
upsert 工具会写入真实数据并修改记录,运行前请确认。Quickbase realm 和用户令牌由第三方托管方保存。用量受限:免费方案每月 50 次工具调用,付费方案通过助手返回的结账链接付款。取消 Pro 后在付费期结束时生效,当期不退款。

安装

在 SourceWeft 中

  1. 打开 控制台中的 Quickbase MCP by usefulapi,将其添加到工作区。
  2. 为需要使用其工具的对话启用该服务。

Web executable,通过 Streamable HTTP。 远程服务在工作区中配置后即可从网页运行时运行。

交给智能体安装

把这段提示词粘贴到 Claude Code、Codex、Cursor 等智能体,或 SourceWeft 对话中。智能体会读取该服务器的安装指南,先向你展示发布者、端点和登录方式,经你同意后再把它添加到你的客户端。密钥不会写进任何命令。

阅读 https://sourceweft.com/mcp/io.usefulapi%2Fquickbase/install.md,并按其中说明把这个 MCP 服务器接入我的客户端。修改任何配置之前,先告诉我它的发布者、端点和登录方式,等我确认。不要把 API 密钥写进命令或我会提交的文件;问我密钥应从哪里获取。

查看智能体所依据的安装指南

其他 MCP 客户端

把它添加到你客户端的 mcpServers 配置中。

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

README

Quickbase MCP by usefulapi

Use your Quickbase account from Claude, Cursor, or any MCP client. Query records, run reports and formulas, and insert or update records. Hosted, no local install: connect with your own credentials.

Live endpoint: https://quickbase.usefulapi.io/mcp · Homepage: https://usefulapi.io

Connect

  • Claude (claude.ai, Desktop): open Customize → Connectors, click + Add → Add custom connector, and paste https://quickbase.usefulapi.io/mcp.
  • Claude Code: claude mcp add --transport http quickbase https://quickbase.usefulapi.io/mcp, then run /mcp to log in.
  • VS Code: Add to VS Code.
  • Cursor and other clients: add the URL as a remote MCP server:
json
{  "mcpServers": {    "quickbase": {      "url": "https://quickbase.usefulapi.io/mcp"    }  }}

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, and the login page asks for your Quickbase credentials.

Step-by-step setup, where to find your credentials, and FAQ: https://usefulapi.io/quickbase/

On first connect you provide your Quickbase realm (the part before .quickbase.com) and a Quickbase user token, which you create in your Quickbase user settings. The server validates them and stores them per user. No keys go in config files.

Tools

ToolTypeWhat it does
quickbase_get_appreadGet an app
quickbase_get_app_rolesreadGet app roles
quickbase_list_tablesreadList tables
quickbase_get_tablereadGet a table
quickbase_list_table_relationshipsreadList table relationships
quickbase_list_fieldsreadList fields
quickbase_get_fieldreadGet a field
quickbase_list_reportsreadList reports
quickbase_get_reportreadGet a report
quickbase_run_reportreadRun a report
quickbase_query_recordsreadQuery records
quickbase_run_formulareadRun a formula
quickbase_get_usersreadGet users
quickbase_upsert_recordswriteInsert or update records
quickbase_usage_statusmetaUsage status (free-tier meter)
quickbase_request_featuremetaRequest a missing feature
quickbase_upgrademetaUpgrade to Pro or Pro+
quickbase_cancel_subscriptionmetaCancel the Pro subscription

read tools are read-only; write tools mutate data (clients should confirm them); meta tools report usage, manage your subscription or send a feature request.

Pricing

PlanPriceLimit
Free$050 tool calls / month
Pro (per user)$9/mo or $90/yr (2 months free)Unlimited*

*Pro has a fair use limit of 10,000 tool calls a month on this server. For more, write to [email protected].

Pro covers this 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].

License

MIT — see LICENSE. Documentation only; the server is hosted.

来源:servers/quickbase/README.md,提交 4046075

工具

14

quickbase_get_app

Get an app

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

输入参数app_id必填

quickbase_get_app_roles

Get app roles

List the roles of a Quickbase app. Needs admin access to the app. Quickbase API: GET /apps/{appId}/roles.

输入参数app_id必填

quickbase_list_tables

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

输入参数app_id必填

quickbase_get_table

Get a table

Get the properties of one table in a Quickbase app. Quickbase API: GET /tables/{tableId}?appId=.

输入参数app_id必填table_id必填

quickbase_list_table_relationships

List table relationships

List the parent-child relationships of a table, with their definitions. Quickbase API: GET /tables/{tableId}/relationships.

输入参数skiptable_id必填

quickbase_list_fields

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

输入参数table_id必填include_field_permissions

quickbase_get_field

Get a field

Get one field of a table by its field id, including type-specific properties. Quickbase API: GET /fields/{fieldId}?tableId=.

输入参数field_id必填table_id必填include_field_permissions

quickbase_list_reports

List reports

List the reports of a table (their ids, names and types). Quickbase API: GET /reports?tableId=.

输入参数table_id必填

quickbase_get_report

Get a report

Get the definition of one report of a table. Quickbase API: GET /reports/{reportId}?tableId=.

输入参数table_id必填report_id必填

quickbase_run_report

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

输入参数topskiptable_id必填report_id必填

quickbase_query_records

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

输入参数topskipwhereselectsort_bytable_id必填

quickbase_run_formula

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.

输入参数formula必填table_id必填record_id

quickbase_get_users

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.

输入参数emailsapp_idsaccount_idnext_page_token

quickbase_upsert_records

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.

输入参数data必填table_id必填merge_field_idfields_to_return

版本历史

5
  1. v1.2.3最新Nov 5, 2026
  2. v1.2.2Nov 5, 2026
  3. v1.2.1Nov 4, 2026
  4. v1.2.0Nov 3, 2026
  5. v1.1.1Nov 3, 2026

评分

已满足适用检查项的 100%

该评分衡量此收录条目的完整程度,依据注册中心条目、端点与公开来源计算得出。它不是对服务器本身的评价,也不表示服务器安全或当前可用:可连通性是带日期的检查结果,评分也不包含安装量或用户评价。

  • 近 30 天内可连通必需25 分
  • 已声明认证方式必需10 分
  • 已列出工具必需15 分
  • 描述必需15 分
  • 图标10 分
  • 文档15 分
  • 许可证10 分

其他 Usefulapi 集成