home / mcp / quickbase mcp server

Quickbase MCP Server

This read-only MCP Server allows you to connect to Quickbase data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "cdatasoftware-quickbase-mcp-server-by-cdata": {
      "command": "java",
      "args": [
        "-jar",
        "CDataMCP-jar-with-dependencies.jar",
        "/PATH/TO/quickbase.prp"
      ]
    }
  }
}

This MCP server exposes live Quickbase data to chat clients through a simple MCP interface, enabling you to ask natural language questions and retrieve up‑to‑date information without writing SQL. It uses the CData JDBC Driver for Quickbase under the hood to present Quickbase data as relational models and serves them via a read‑only MCP endpoint for local querying by language models and other tools.

How to use

You connect your MCP client to the local server to query Quickbase data live. After the server is running, you can ask questions like “What is the average revenue by account type this quarter?” or “Show open tickets by priority,” and the client will route those requests to the MCP server, which translates them into SQL via the JDBC Driver and returns the results.

How to install

Prerequisites: Java and Maven are required to build and run the server.

# 1) Clone the MCP server project
git clone https://github.com/cdatasoftware/quickbase-mcp-server-by-cdata.git
cd quickbase-mcp-server-by-cdata

# 2) Build the server
mvn clean install

3) Install the CData JDBC Driver for Quickbase. Follow the driver download and installation steps from the CData site for your operating system and ensure the driver is installed locally.

4) License the CData JDBC Driver. In your installation’s lib directory, run the license command and provide your name, email, and a license key (TRIAL or your key).

5) Configure your data source connection. Use the driver’s connection utility to create and test a connection string. Copy the resulting JDBC URL for later use.

6) Create a .prp file for the MCP server connection. Use the following properties as a template and fill in your values.

Prefix=quickbase
ServerName=CDataQuickbase
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.quickbase.jar
DriverClass=cdata.jdbc.quickbase.QuickbaseDriver
JdbcUrl=jdbc:quickbase:InitiateOAuth=GETANDREFRESH;
Tables=

Run the MCP server locally

Start the server using the standard Java command with the prepared .prp file. The server runs as a local stdio server, so it is intended to be used with a client on the same machine.

java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/quickbase.prp

Notes on usage with Claude Desktop or similar clients

Configure the MCP server entry in your client as a stdio server. Provide the Java command and the path to the JAR and prp file as the runtime arguments so the client can launch the MCP server on demand.

Available tools

quickbase_get_tables

Retrieves the list of tables available from the Quickbase data source. The output is returned in CSV format with column headers on the first line.

quickbase_get_columns

Retrieves the list of columns for a specified table. The output is returned in CSV format with column headers on the first line.

quickbase_run_query

Executes a SQL SELECT query against the Quickbase data source and returns the result set.