Quickbase MCP server for AI agents

The Quickbase MCP Server provides a Model Context Protocol implementation that allows Claude Desktop and other AI assistants to interact with Quickbase applications and data through a standardized interface.

Getting Started with Claude Desktop

One-Line Setup Check

Run this command to verify your system has all necessary dependencies:

curl -fsSL https://raw.githubusercontent.com/danielbushman/MCP-Quickbase/main/check_dependencies.sh | bash

Configure Claude Desktop

Add the following configuration to your Claude Desktop configuration file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json

{
  "mcpServers": {
    "quickbase": {
      "command": "npx",
      "args": ["-y", "mcp-quickbase"],
      "env": {
        "QUICKBASE_REALM_HOST": "your-realm.quickbase.com",
        "QUICKBASE_USER_TOKEN": "your-user-token",
        "QUICKBASE_APP_ID": "your-app-id"
      }
    }
  }
}

After adding this configuration, restart Claude Desktop to apply the changes.

Installation Options

NPM Installation (Recommended)

You can use the package directly with npx without installation:

npx -y mcp-quickbase

Or install it globally for easier access:

npm install -g mcp-quickbase

Source Installation

If you prefer to install from source:

git clone https://github.com/danielbushman/MCP-Quickbase.git
cd MCP-Quickbase
npm install
npm run build

For source installation, use this Claude Desktop configuration:

{
  "mcpServers": {
    "quickbase": {
      "command": "node",
      "args": ["/path/to/MCP-Quickbase/dist/mcp-stdio-server.js"],
      "env": {
        "QUICKBASE_REALM_HOST": "your-realm.quickbase.com",
        "QUICKBASE_USER_TOKEN": "your-user-token",
        "QUICKBASE_APP_ID": "your-app-id"
      }
    }
  }
}

Configuration

Required Environment Variables

The following environment variables must be set for the server to function:

QUICKBASE_REALM_HOST - Your Quickbase realm (e.g., company.quickbase.com)
QUICKBASE_USER_TOKEN - Your Quickbase API token (generate one at Quickbase Help)

Optional Environment Variables

These settings can be configured as needed:

QUICKBASE_APP_ID - Default application ID to work with
QUICKBASE_CACHE_ENABLED - Enable caching (true/false, default: true)
QUICKBASE_CACHE_TTL - Cache duration in seconds (default: 3600)
DEBUG - Enable debug logging (true/false, default: false)
LOG_LEVEL - Logging level (DEBUG/INFO/WARN/ERROR, default: INFO)

Available Tools

Connection & Configuration

check_configuration - Verify if Quickbase configuration is properly set up
test_connection - Test connectivity to Quickbase
configure_cache - Adjust caching behavior

Application Management

create_app - Create new Quickbase applications
update_app - Modify existing applications
list_tables - Show all tables in an application

Table Operations

create_table - Create new tables
update_table - Update table properties
get_table_fields - Retrieve field information for a table

Field Management

create_field - Add new fields to tables
update_field - Modify field properties

Record Operations

query_records - Search for records with filtering and sorting
create_record - Add a single record
update_record - Modify existing records
bulk_create_records - Add multiple records at once
bulk_update_records - Update multiple records simultaneously

File Operations

upload_file - Upload files to file attachment fields
download_file - Download files from records

Reporting

run_report - Execute Quickbase reports

Usage Examples

You can ask Claude to perform various Quickbase operations. Here are some examples:

Query Records

To retrieve customer data:

Query all customers from the Customers table

Create Records

To add a new customer:

Create a new customer record with name "Acme Corp" and status "Active"

File Management

To upload a document:

Upload invoice.pdf to the Documents field in record 123

System Requirements

Node.js 18 or higher
Valid Quickbase account with API access
Claude Desktop (for MCP integration)

How to install this MCP server

For Claude Code

To add this MCP server to Claude Code, run this command in your terminal:

claude mcp add-json "quickbase" '{"command":"npx","args":["-y","mcp-quickbase"],"env":{"QUICKBASE_REALM_HOST":"your-realm.quickbase.com","QUICKBASE_USER_TOKEN":"your-user-token","QUICKBASE_APP_ID":"your-app-id"}}'

See the official Claude Code MCP documentation for more details.

For Cursor

There are two ways to add an MCP server to Cursor. The most common way is to add the server globally in the ~/.cursor/mcp.json file so that it is available in all of your projects.

If you only need the server in a single project, you can add it to the project instead by creating or adding it to the .cursor/mcp.json file.

Adding an MCP server to Cursor globally

To add a global MCP server go to Cursor Settings > Tools & Integrations and click "New MCP Server".

When you click that button the ~/.cursor/mcp.json file will be opened and you can add your server like this:

{
    "mcpServers": {
        "quickbase": {
            "command": "npx",
            "args": [
                "-y",
                "mcp-quickbase"
            ],
            "env": {
                "QUICKBASE_REALM_HOST": "your-realm.quickbase.com",
                "QUICKBASE_USER_TOKEN": "your-user-token",
                "QUICKBASE_APP_ID": "your-app-id"
            }
        }
    }
}

Adding an MCP server to a project

To add an MCP server to a project you can create a new .cursor/mcp.json file or add it to the existing one. This will look exactly the same as the global MCP server example above.

How to use the MCP server

Once the server is installed, you might need to head back to Settings > MCP and click the refresh button.

The Cursor agent will then be able to see the available tools the added MCP server has available and will call them when it needs to.

You can also explicitly ask the agent to use the tool by mentioning the tool name and describing what the function does.

For Claude Desktop

To add this MCP server to Claude Desktop:

1. Find your configuration file:

macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
Linux: ~/.config/Claude/claude_desktop_config.json

2. Add this to your configuration file:

{
    "mcpServers": {
        "quickbase": {
            "command": "npx",
            "args": [
                "-y",
                "mcp-quickbase"
            ],
            "env": {
                "QUICKBASE_REALM_HOST": "your-realm.quickbase.com",
                "QUICKBASE_USER_TOKEN": "your-user-token",
                "QUICKBASE_APP_ID": "your-app-id"
            }
        }
    }
}

3. Restart Claude Desktop for the changes to take effect