home / mcp / paypal mcp server

PayPal MCP Server

This read-only MCP Server allows you to connect to PayPal 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-paypal-mcp-server-by-cdata": {
      "url": "https://mcp.example/paypal"
    }
  }
}

This MCP server makes PayPal data accessible to local clients in a read-only MCP interface powered by the CData JDBC Driver. It lets you query live PayPal data through natural language questions, enabling your AI workflows to retrieve up-to-date information without writing SQL.

How to use

You run a local MCP server on your machine and connect an MCP client to it. Start your server, then load the MCP into your client configuration so the AI can ask questions about PayPal data. The server exposes standard read-only tools for discovering data, inspecting table schemas, and running queries, all through conversational prompts. You won’t need to write SQL to ask about transactions, accounts, or other PayPal data points. When you ask questions, the AI client will use the exposed tools behind the scenes to fetch the information.

How to install

Prerequisites you need before installing: Java and Maven on your system.

1. Clone the project repository and navigate to it.

git clone https://github.com/cdatasoftware/paypal-mcp-server-by-cdata.git
cd paypal-mcp-server-by-cdata

2. Build the server to create the executable JAR.

mvn clean install

3. Install the CData JDBC Driver for PayPal (this step provides the data connectivity). Follow the driver installer and licensing flow as shown in the guide for your OS. You will license the driver with your name, email, and license key (or TRIAL for evaluation).

4. Configure your PayPal connection string with the CData JDBC Driver. Launch the connection utility to create a connection string, test the connection, and copy the final string for use in your .prp file. If OAuth is used, authenticate in your browser during the test.

5. Create a .prp file for the JDBC connection. Use the provided properties to define how the MCP server will connect to PayPal via the CData JDBC Driver.

Example properties (edit PATHS to your setup):

Prefix=paypal
ServerName=CDataPayPal
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.paypal.jar
DriverClass=cdata.jdbc.paypal.PayPalDriver
JdbcUrl=jdbc:paypal:InitiateOAuth=GETANDREFRESH;
Tables=

Available tools

paypal_get_tables

Retrieves a list of tables available in the data source. The output is CSV with a header row.

paypal_get_columns

Retrieves a list of columns for a specific table. The output is CSV with a header row.

paypal_run_query

Executes a SQL SELECT query against the PayPal data source and returns the results.