home / mcp / surveymonkey mcp server

SurveyMonkey MCP Server

Provides a read-only MCP server to query live SurveyMonkey data via the CData JDBC Driver.

Installation

Add the following to your MCP client configuration file.

Configuration

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

You can query live SurveyMonkey data through a focused MCP server that exposes data via a simple, read-only API. This server lets your AI client ask natural-language questions and retrieve up-to-date SurveyMonkey information without writing SQL. It wraps the CData JDBC Driver for SurveyMonkey and serves data via the MCP interface for quick, live insights.

How to use

Once you have the MCP server running, you interact with it through an MCP client. You do not need to know SQL to ask questions; just describe what you want to learn about SurveyMonkey data and the client will translate your questions into reads against the underlying data tables. Typical usage includes asking about open survey responses, response counts over time, or correlations between response attributes and project metadata.

How to install

# Prerequisites
- Java (JRE/JDK) installed
- Maven installed for building the MCP server

# 1. Clone the project and build the MCP server
git clone https://github.com/cdatasoftware/surveymonkey-mcp-server-by-cdata.git
cd surveymonkey-mcp-server-by-cdata
mvn clean install
# This creates the JAR: CDataMCP-jar-with-dependencies.jar

2. Install the CData JDBC Driver for SurveyMonkey and license it following the provided steps in the setup flow. Ensure the driver is licensed and ready to connect to SurveyMonkey.

3. Configure the JDBC connection string using the driver’s connection utility, test the connection, and copy the connection string for use in the .prp file.

4. Create the MCP connection profile file (surveymonkey.prp) with the following properties. Replace placeholders with your actual paths and values.

Prefix=surveymonkey
ServerName=CDataSurveyMonkey
ServerVersion=1.0
DriverPath=PATH\TO\cdata.jdbc.surveymonkey.jar
DriverClass=cdata.jdbc.surveymonkey.SurveyMonkeyDriver
JdbcUrl=jdbc:surveymonkey:InitiateOAuth=GETANDREFRESH;
Tables=

Running the server locally

The server runs locally via a Java command that loads your .prp configuration. Use a command that matches your environment and points to the surveymonkey.prp you created.

# Example for Linux/macOS
java -jar /PATH/TO/CDataMCP-jar-with-dependencies.jar /PATH/TO/surveymonkey.prp

# Example for Windows (PowerShell)
PATH\TO\java.exe -jar PATH\TO\CDataMCP-jar-with-dependencies.jar PATH\TO\surveymonkey.prp

Using Claude Desktop or other MCP clients

Add the MCP server as a new entry in your client’s configuration. The client will discover and load the server’s tools automatically. If needed, restart the client to ensure the server shows up.

For Windows, your config snippet should reference the Java executable and point to the MCP jar and the surveymonkey.prp file.

Notes and tips

This MCP server is read-only by design, enabling safe querying of live SurveyMonkey data. If you later require write or delete capabilities, look for a version of the server that supports full MCP interactions and adjust your configuration accordingly.

Available tools

surveymonkey_get_tables

Retrieves a list of tables available in the SurveyMonkey data source. The output is CSV with the first line containing column headers.

surveymonkey_get_columns

Retrieves a list of columns for a specified table. The output is CSV with the first line containing column headers.

surveymonkey_run_query

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