Quickbase MCP Server

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 (25)

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
• get_field - Get properties of a specific field
• update_field - Update field properties
• delete_field - Delete a field from a table

Record Operations

• query_records - Query records with filtering, sorting, and groupBy
• 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

Relationship Management

• get_relationships - Get table relationships
• create_relationship - Create a new table relationship
• update_relationship - Update an existing relationship
• delete_relationship - Delete a table relationship

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+
• 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