PayPal MCP Server by CData

What is PayPal MCP Server by CData?

PayPal MCP Server by CData is a read-only Model Context Protocol server that allows LLMs like Claude Desktop to query live PayPal data using natural language. It wraps the CData JDBC Driver for PayPal, which exposes PayPal data as relational SQL models, and makes that data accessible through a simple MCP interface without requiring SQL.

How to use PayPal MCP Server by CData?

1. Clone the repository and build the JAR with mvn clean install. 2. Download and install the CData JDBC Driver for PayPal, then license it. 3. Use the connection string utility to configure OAuth and create a .prp file with driver details and JDBC URL. 4. Add the server to the Claude Desktop config file (claude_desktop_config.json) pointing to the Java executable, the JAR, and the .prp file. 5. Restart Claude Desktop; the tools will be available automatically.

Key features of PayPal MCP Server by CData

• Read-only access to live PayPal data via natural language queries
• Exposes PayPal data as relational SQL models through the CData JDBC Driver
• Provides three tools: get_tables, get_columns, and run_query
• Uses stdio transport; runs only on the same machine as the client
• Built on the CData JDBC Driver for PayPal (license required)

Use cases of PayPal MCP Server by CData

• Ask Claude Desktop questions about PayPal transaction history
• Query PayPal account balances or recent payments using plain English
• Explore available tables and columns in PayPal data without SQL
• Run arbitrary SQL SELECT queries on PayPal data through an LLM

FAQ from PayPal MCP Server by CData

Is this server read-only?

Yes, the README explicitly states that this project builds a read-only MCP server. For full read, write, update, delete, and action capabilities, see the CData MCP Server for PayPal (beta).

What are the dependencies and runtime requirements?

You need Java to run the server, Maven to build the JAR, and the CData JDBC Driver for PayPal installed and licensed. The driver must be downloaded separately from the CData website.

How is authentication handled?

The JDBC driver uses OAuth authentication. During setup, the connection string utility will open a browser for OAuth authentication (for data sources that require it).

Where does the data live?

The server connects to live PayPal data through the CData JDBC Driver. No data is stored locally; queries fetch results from PayPal in real time.

What transport does the server use?

The server uses the stdio transport and can only be used with clients that run on the same machine as the server.

Are there any known limits?

The server is intentionally read-only. It does not support write, update, delete, or action operations. The beta version from CData provides those capabilities with a simplified setup.