twilio -by-cdata

This MCP server exposes Twilio data via a read-only MCP interface built on top of the CData JDBC Driver for Twilio. It allows LLMs and other clients to query live Twilio data without writing SQL, by presenting the data as relational-like tables accessible through the MCP API. The server is designed to run locally on the same machine as the client (stdio mode). Tools exposed follow the pattern {servername}_get_tables, {servername}_get_columns, and {servername}_run_query, where {servername} is the configured server name (for this setup, twilio). For example, twilio_get_tables retrieves available tables, twilio_get_columns lists columns for a chosen table, and twilio_run_query executes a SQL SELECT query against the Twilio data exposed by the JDBC driver. Use these tools to discover schema and retrieve data, then compose natural-language questions that map to these SQL-backed views.

Prerequisites:

• Java (JDK) installed and available on the PATH
• Maven installed (for building the MCP server JAR)
• Access to download the CData JDBC Driver for Twilio and a valid license

Install steps:

1. Clone the repository and build the MCP server

   git clone https://github.com/cdatasoftware/twilio-mcp-server-by-cdata.git
   cd twilio-mcp-server-by-cdata
   mvn clean install
   

   This builds the CDataMCP-jar-with-dependencies.jar (the MCP server binary).

2. Download and install the CData JDBC Driver for Twilio

   • Visit: https://www.cdata.com/drivers/twilio/download/jdbc
   • Install the driver according to your OS

3. License the JDBC driver (example steps):

   • Locate the lib directory of the driver installation
   • Run: java -jar cdata.jdbc.twilio.jar --license
   • Provide your name, email, and a license key (or TRIAL)

4. Prepare a .prp configuration file for your JDBC connection (example: twilio.prp):

   Prefix=twilio
   ServerName=CDataTwilio
   ServerVersion=1.0
   DriverPath=PATH\TO\cdata.jdbc.twilio.jar
   DriverClass=cdata.jdbc.twilio.TwilioDriver
   JdbcUrl=jdbc:twilio:InitiateOAuth=GETANDREFRESH;
   Tables=
   

   Save this file to a path you will reference when starting the MCP server.

5. Run the MCP server locally

   • Start the server using the built JAR and the .prp file
   • Example (adjust PATHs accordingly):

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

6. Configure clients (e.g., Claude Desktop) to connect to this locally running MCP server using the appropriate CLI/JSON-RPC setup as shown in the README.

Notes:

• The server communicates via STDIO; use with clients running on the same machine.
• You must ensure the JDBC driver is licensed and the connection string is valid before starting the MCP server.

Tips and troubleshooting:

• If the MCP server does not appear in Claude Desktop, fully quit and re-open Claude Desktop, then refresh.
• Ensure your twilio.prp contains a valid JdbcUrl and that DriverPath points to the correct driver JAR.
• The server is read-only; write/update/delete capabilities are not exposed in this build.
• For Windows paths in the .prp, ensure proper escaping (double backslashes) when in JSON configs that feed the runtime.
• If OAuth is used for the Twilio data source, you may need to authenticate in a browser during connection setup.
• Maintain the JDBC driver license status to avoid runtime errors.
• When debugging, check that java -jar ... /path/to/twilio.prp is correctly referencing the prepared connection configuration.