This MCP server wraps the CData JDBC Driver for Pinterest to expose Pinterest data via a read-only MCP interface. It enables large language models and clients to query live Pinterest data without direct SQL. The server is started by running a Java jar with a .prp configuration file that describes the JDBC connection and exposed tables. Once running, you can use the built-in MCP tools to discover available data and run queries. The available tools include: a get_tables tool to list tables exposed by the data source, a get_columns tool to list columns for a specific table, and a run_query tool to execute SQL SELECT statements against the underlying data source. The tools output in CSV format for tables and columns, and results of queries are returned to the client for downstream reasoning and response generation.

Prerequisites:

• Java Runtime Environment (JRE) or JDK installed and available on PATH
• Maven installed (for building the MCP server JAR from source)
• Access to the Pinterest JDBC driver package from CData (including license steps)

Installation steps:

1. Clone the repository and build the MCP server JAR git clone https://github.com/cdatasoftware/pinterest-mcp-server-by-cdata.git cd pinterest-mcp-server-by-cdata mvn clean install

   This should produce CDataMCP-jar-with-dependencies.jar

2. Obtain and license the CData JDBC Driver for Pinterest

   • Download from: https://www.cdata.com/drivers/pinterest/download/jdbc
   • Follow the platform-specific licensing steps (run the jar with --license as described in the setup guide)

3. Create a .prp connection file (e.g., pinterest.prp)

   • Use the following template and fill in the proper values from your JDBC setup:

     Prefix=pinterest ServerName=CDataPinterest ServerVersion=1.0 DriverPath=PATH\TO\cdata.jdbc.pinterest.jar DriverClass=cdata.jdbc.pinterest.PinterestDriver JdbcUrl=jdbc:pinterest:InitiateOAuth=GETANDREFRESH; Tables=

4. Run the MCP server

   • Start the server with the generated jar and the .prp file: java -jar CDataMCP-jar-with-dependencies.jar /PATH/TO/pinterest.prp
   • The server communicates via stdio, so it should be run on the same host as the client tooling.

Tips and considerations:

• The server is read-only by default in this package; full read/write capabilities may require a different MCP server package from CData.
• The MCP server uses stdio for communication, so clients must run on the same machine or use an appropriate wrapper to pipe stdio.
• Ensure the JdbcUrl and DriverPath in pinterest.prp are correct and the JDBC driver is licensed and accessible.
• If you encounter issues in Claude Desktop or similar clients, fully quit and restart the client after starting the MCP server and verify the prp file path is correct.
• For OAuth data sources, you may need to authenticate during driver initialization or in the connection string utility as described in the setup steps.