What is Mcp Quickbase

MCP-Quickbase is a TypeScript-based Model Context Protocol (MCP) server designed for seamless integration with Quickbase and AI assistants like Claude Desktop. It is a community-developed project that utilizes Quickbase’s public APIs but is not officially supported by Quickbase, Inc.

Use cases

Use cases for MCP-Quickbase include automating data retrieval and updates in Quickbase, enhancing AI assistant capabilities with Quickbase data, and streamlining workflows in project management and customer relationship management.

How to use

To use MCP-Quickbase, you need to set it up in your Claude Desktop configuration file by adding the necessary environment variables and commands. You can install it via NPM or from source, and then restart Claude Desktop to start using Quickbase tools.

Key features

Key features of MCP-Quickbase include easy integration with Claude Desktop, support for Quickbase’s public APIs, and a community-maintained project that allows for flexibility and customization.

Where to use

MCP-Quickbase can be used in various fields that require data management and integration with AI tools, particularly in business environments where Quickbase is utilized for project management, CRM, and other applications.

Quickbase MCP Server

A TypeScript-based Model Context Protocol (MCP) server for Quickbase, designed for seamless integration with Claude Desktop and other AI assistants.

📋 Community Project Notice
This is a community-developed integration that is not an official Quickbase product. While it uses Quickbase’s public APIs, it is not officially supported by Quickbase, Inc. This project is provided “as is” and maintained by the community. For official Quickbase products and support, please visit quickbase.com.

🚀 Quick Start for Claude Desktop

One-Line Setup Check

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

Configure Claude Desktop

Add this 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"
      }
    }
  }
}

That’s it! Restart Claude Desktop and you can start using Quickbase tools.

📦 Installation Options

Option 1: NPM (Recommended)

# Use directly with npx (no installation needed)
npx -y mcp-quickbase

# Or install globally
npm install -g mcp-quickbase

Option 2: From Source

# Clone the repository
git clone https://github.com/danielbushman/MCP-Quickbase.git
cd MCP-Quickbase

# Install dependencies
npm install

# Build the project
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

The server can start without environment variables configured, but tools will not be functional until proper configuration is provided. Use the check_configuration tool to verify your setup.

Required Environment Variables

• QUICKBASE_REALM_HOST - Your Quickbase realm (e.g., company.quickbase.com)
• QUICKBASE_USER_TOKEN - Your Quickbase API token (Get one here)

Optional Environment Variables

• QUICKBASE_APP_ID - Default application ID

Optional Settings

• 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 - Check if Quickbase configuration is properly set up
• test_connection - Test connection to Quickbase
• configure_cache - Configure caching behavior

Application Management

• create_app - Create new Quickbase applications
• update_app - Update existing applications
• list_tables - List all tables in an application

Table Operations

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

Field Management

• create_field - Create new fields in tables
• update_field - Update field properties

Record Operations

• query_records - Query records with filtering and sorting
• create_record - Create single records
• update_record - Update existing records
• bulk_create_records - Create multiple records
• bulk_update_records - Update multiple records

File Operations

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

Reporting

• run_report - Execute Quickbase reports

📚 Usage Examples

Basic Record Query

Query all customers from the Customers table

Create a New Record

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

Upload a File

Upload invoice.pdf to the Documents field in record 123

🔒 Security

• API tokens are handled securely and never logged
• All file operations are sandboxed to the working directory
• Supports field-level permissions and access controls

📋 Requirements

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

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

🔗 Links

• Quickbase API Documentation
• Model Context Protocol
• Claude Desktop