Provides read-only access to ADP data through SQL queries, enabling retrieval of HR and payroll information from ADP systems
Enables querying of Airtable databases and tables through SQL interface, allowing access to structured data stored in Airtable bases
Provides SQL-based access to Amazon DynamoDB tables, enabling retrieval and querying of NoSQL data stored in DynamoDB
Allows querying of data stored in Amazon S3 buckets through SQL interface, enabling access to files and objects in S3 storage
Enables access to Asana project management data through SQL queries, allowing retrieval of tasks, projects, and team information
Provides SQL-based access to Basecamp project management data, enabling querying of projects, tasks, and team collaboration information
Allows querying of BigCommerce e-commerce data through SQL interface, providing access to products, orders, and customer information
Enables SQL-based access to Bitbucket repository data, allowing retrieval of code repositories, pull requests, and project information
Provides access to Box cloud storage data through SQL queries, enabling retrieval of files, folders, and sharing information
Allows querying of Confluence wiki and documentation data through SQL interface, providing access to pages, spaces, and content
Enables SQL-based access to Couchbase NoSQL database, allowing querying of documents and data stored in Couchbase clusters
Provides SQL access to Databricks analytics platform data, enabling querying of data lakehouse and analytics workloads
Allows querying of Dropbox cloud storage data through SQL interface, providing access to files, folders, and sharing metadata
Enables SQL-based access to eBay marketplace data, allowing retrieval of listings, orders, and seller information
Provides SQL interface to Elasticsearch search and analytics engine, enabling querying of indexed documents and search data
Allows SQL-based access to EnterpriseDB PostgreSQL database systems, enabling querying of enterprise database data
Enables access to Facebook social media data through SQL queries, allowing retrieval of posts, pages, and social engagement metrics
Provides SQL-based access to GitHub repository data, enabling querying of repositories, issues, pull requests, and development metrics
Allows querying of Gmail email data through SQL interface, providing access to messages, labels, and email metadata
Enables SQL-based access to Google Ads campaign data, allowing retrieval of advertising metrics, campaigns, and performance data
Provides access to Google Analytics web analytics data through SQL queries, enabling retrieval of website traffic and user behavior metrics
Allows querying of Google Calendar data through SQL interface, providing access to events, schedules, and calendar metadata
Enables SQL-based access to Google Campaign Manager 360 advertising data, allowing retrieval of campaign performance and ad metrics
Provides access to Google Cloud Storage data through SQL queries, enabling retrieval of files, buckets, and storage metadata
Allows querying of Google Drive file storage data through SQL interface, providing access to files, folders, and sharing information
Enables SQL-based access to Google Sheets spreadsheet data, allowing querying of spreadsheet content and metadata
Provides SQL interface to GraphQL APIs, enabling relational querying of GraphQL endpoints and schema data
Allows SQL-based access to Greenhouse recruiting platform data, enabling querying of candidates, jobs, and hiring pipeline information
Enables SQL access to Apache Hive data warehouse system, allowing querying of big data stored in Hive tables
Provides SQL-based access to HubSpot CRM and marketing data, enabling querying of contacts, deals, and marketing campaign information
Allows querying of Instagram social media data through SQL interface, providing access to posts, followers, and engagement metrics
Enables SQL-based access to Jira project management data, allowing querying of issues, projects, and development workflow information
Allows SQL-based access to MailChimp email marketing data, enabling querying of campaigns, subscribers, and email performance metrics
Enables SQL access to MariaDB database systems, allowing querying of relational data stored in MariaDB instances
Provides SQL interface to MongoDB NoSQL database, enabling relational-style querying of MongoDB collections and documents
Allows SQL-based access to MYOB accounting software data, enabling querying of financial records and business information
Enables SQL access to MySQL database systems, allowing querying of relational data stored in MySQL instances
Provides SQL interface to Neo4j graph database, enabling relational-style querying of graph data and relationships
Allows SQL-based access to Odoo ERP system data, enabling querying of business processes, accounting, and operational information
Enables SQL-based access to Okta identity management data, allowing querying of users, groups, and authentication information
Provides access to PayPal payment processing data through SQL queries, enabling retrieval of transactions and payment information
Allows querying of Pinterest social media data through SQL interface, providing access to pins, boards, and engagement metrics
Enables SQL access to PostgreSQL database systems, allowing querying of relational data stored in PostgreSQL instances
Provides SQL access to Presto distributed query engine, enabling querying of data across multiple data sources
Allows SQL-based access to QuickBooks accounting data, enabling querying of financial transactions, customers, and business records
Enables SQL interface to Redis in-memory database, allowing relational-style querying of Redis data structures
Provides SQL-based access to RSS feed data, enabling querying of feed content, articles, and syndication information
Allows SQL-based access to Sage accounting and business management data, enabling querying of financial and operational information
Enables SQL-based access to Salesforce CRM data, allowing querying of leads, opportunities, accounts, and sales pipeline information
Provides SQL interface to SAP enterprise systems, enabling querying of business processes, financials, and operational data
Allows SQL-based access to SendGrid email delivery data, enabling querying of email campaigns, deliverability metrics, and recipient information
Enables SQL-based access to Shopify e-commerce data, allowing querying of products, orders, customers, and sales information
Provides SQL access to SingleStore distributed database, enabling querying of real-time analytics and operational data
Allows SQL-based access to Slack workspace data, enabling querying of messages, channels, and team communication information
Enables access to Snapchat advertising data through SQL queries, allowing retrieval of ad campaigns and performance metrics
Provides SQL access to Snowflake cloud data warehouse, enabling querying of structured and semi-structured data
Allows SQL-based access to Splunk machine data platform, enabling querying of logs, metrics, and operational intelligence data
Enables SQL-based access to Square payment processing data, allowing querying of transactions, customers, and business metrics
Provides access to Stripe payment processing data through SQL queries, enabling retrieval of payments, customers, and subscription information
Allows SQL-based access to SurveyMonkey survey data, enabling querying of survey responses, analytics, and participant information
Enables SQL access to Teradata data warehouse systems, allowing querying of enterprise analytics and big data workloads
Provides SQL-based access to Trello project management data, enabling querying of boards, cards, and team collaboration information
Allows SQL access to Trino distributed query engine, enabling querying of data across multiple heterogeneous data sources
Enables SQL-based access to Twilio communication platform data, allowing querying of messages, calls, and communication analytics
Provides SQL-based access to WooCommerce e-commerce data, enabling querying of products, orders, and customer information
Allows SQL-based access to WordPress content management data, enabling querying of posts, pages, users, and site information
Enables SQL-based access to Xero accounting software data, allowing querying of financial transactions, invoices, and business records
Provides SQL interface to XML data sources, enabling relational querying of XML files and structured document data
Allows SQL-based access to YouTube Analytics data, enabling querying of video performance, channel metrics, and audience insights
Enables SQL-based access to Zendesk customer service data, allowing querying of tickets, customers, and support interaction information
Provides SQL-based access to Zoho business suite data, enabling querying of CRM, project management, and business application information
oracle-sales-mcp-server-by-cdata
CData's Model Context Protocol (MCP) Server for Oracle Sales
: This project builds a read-only MCP server. For full read, write, update, delete, and action capabilities and a simplified setup, check out our free CData MCP Server for Oracle Sales (beta).
Purpose
We created this read-only MCP Server to allow LLMs (like Claude Desktop) to query live data Oracle Sales supported by the CData JDBC Driver for Oracle Sales.
CData JDBC Driver connects to Oracle Sales by exposing them as relational SQL models.
This server wraps that driver and makes Oracle Sales data available through a simple MCP interface, so LLMs can retrieve live information by asking natural language questions — no SQL required.
Setup Guide
- Clone the repository:
- Build the server:This creates the JAR file: CDataMCP-jar-with-dependencies.jar
- Download and install the CData JDBC Driver for {source}: https://www.cdata.com/drivers/oraclesalescloud/download/jdbc
- License the CData JDBC Driver:
- Navigate to the
lib
folder in the installation directory, typically:- (Windows)
C:\Program Files\CData\CData JDBC Driver for Oracle Sales\
- (Mac/Linux)
/Applications/CData JDBC Driver for Oracle Sales/
- (Windows)
- Run the command
java -jar cdata.jdbc.oraclesales.jar --license
- Enter your name, email, and "TRIAL" (or your license key).
- Navigate to the
- Configure your connection to the data source (Salesforce as an example):
- Run the command
java -jar cdata.jdbc.oraclesales.jar
to open the Connection String utility. - Configure the connection string and click "Test Connection"
Note: If the data sources uses OAuth, you will need to authenticate in your browser.
- Once successful, copy the connection string for use later.
- Run the command
- Create a
.prp
file for your JDBC connection (e.g.oracle-sales.prp
) using the following properties and format:- Prefix - a prefix to be used for the tools exposed
- ServerName - a name for your server
- ServerVersion - a version for your server
- DriverPath - the full path to the JAR file for your JDBC driver
- DriverClass - the name of the JDBC Driver Class (e.g. cdata.jdbc.oraclesales.OracleSalesDriver)
- JdbcUrl - the JDBC connection string to use with the CData JDBC Driver to connect to your data (copied from above)
- Tables - leave blank to access all data, otherwise you can explicitly declare the tables you wish to create access for
Using the Server with Claude Desktop
- Create the config file for Claude Desktop ( claude_desktop_config.json) to add the new MCP server, using the format below. If the file already exists, add the entry to the
mcpServers
in the config file. WindowsLinux/MacIf needed, copy the config file to the appropriate directory (Claude Desktop as the example). WindowsLinux/Mac - Run or refresh your client (Claude Desktop).
Note: You may need to fully exit or quit your Claude Desktop client and re-open it for the MCP Servers to appear.
Running the Server
- Run the follow the command to run the MCP Server on its own
Usage Details
Once the MCP Server is configured, the AI client will be able to use the built-in tools to read, write, update, and delete the underlying data. In general, you do not need to call the tools explicitly. Simply ask the client to answer questions about the underlying data system. For example:
- "What is the correlation between my closed won opportunities and the account industry?"
- "How many open tickets do I have in the SUPPORT project?"
- "Can you tell me what calendar events I have today?"
The list of tools available and their descriptions follow:
Tools & Descriptions
In the definitions below, {servername}
refers to the name of the MCP Server in the config file (e.g. {classname_dash}
above).
{servername}_get_tables
- Retrieves a list of tables available in the data source. Use the{servername}_get_columns
tool to list available columns on a table. The output of the tool will be returned in CSV format, with the first line containing column headers.{servername}_get_columns
- Retrieves a list of columns for a table. Use the{servername}_get_tables
tool to get a list of available tables. The output of the tool will be returned in CSV format, with the first line containing column headers.{servername}_run_query
- Execute a SQL SELECT query
JSON-RPC Request Examples
If you are scripting out the requests sent to the MCP Server instead of using an AI Client (e.g. Claude), then you can refer to the JSON payload examples below – following the JSON-RPC 2.0 specification - when calling the available tools.
source_get_tables
source_get_columns
source_run_query
Troubleshooting
- If you cannot see your CData MCP Server in Claude Desktop, be sure that you have fully quit Claude Desktop (Windows: use the Task Manager, Mac: use the Activity Monitor)
- If Claude Desktop is unable to retrieve data, be sure that you have configured your connection properly. Use the Connection String builder to create the connection string (see above) and copy the connection string into the property (.prp) file.
- If you are having trouble connecting to your data source, contact the CData Support Team.
- If you are having trouble using the MCP server, or have any other feedback, join the CData Community.
License
This MCP server is licensed under the MIT License. This means you are free to use, modify, and distribute the software, subject to the terms and conditions of the MIT License. For more details, please see the LICENSE file in the project repository.
All Supported Sources
This server cannot be installed
local-only server
The server can only run on the client's local machine because it depends on local resources.
This read-only MCP Server allows you to connect to Oracle Sales data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcp
Related MCP Servers
- -securityAlicense-qualityThis read-only MCP Server allows you to connect to Exact Online data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcpLast updated -MIT License
- -securityAlicense-qualityThis read-only MCP Server allows you to connect to Email data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcpLast updated -MIT License
- -securityAlicense-qualityThis read-only MCP Server allows you to connect to Oracle Eloqua data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcpLast updated -MIT License
- -securityAlicense-qualityThis read-only MCP Server allows you to connect to SuiteCRM data from Claude Desktop through CData JDBC Drivers. Free (beta) read/write servers available at https://www.cdata.com/solutions/mcpLast updated -MIT License