CData Connect AI

Yes, if the connection permits it. CData documents INSERT, UPDATE, UPSERT, DELETE and EXECUTE statements against connected sources, and its OpenAPI specification names execute_insert and execute_update as MCP operations. Whether a given agent can use them depends on the Select, Insert, Update, Delete and Execute permissions an administrator set on that connection inside Connect AI.

Far more than twelve. The twelve names Anthropic lists are a SQL dispatcher: queryData forwards arbitrary SQL to any connected source. CData documents 318 data source connectors, and the reachable surface is every table, view and stored procedure across every connection your account holds, multiplied by the SQL verbs permitted.

No. The server's RFC 9728 descriptor and its authentication challenge both advertise exactly four scopes: openid, profile, email and offline_access. All four are identity claims. Nothing at the MCP consent step separates reading a row from deleting one, so the boundary lives entirely in CData's own per-connection permissions.

Yes, where the connection grants Delete permission. CData documents DELETE and DELETE SELECT statements, the latter deleting multiple rows from a temporary table in one request. Its per-connection permissions list Delete as a separate toggle, which is CData's own acknowledgement that deletion is reachable through this SQL surface and needs gating.

A second MCP server at mcp.cloud.cdata.com/mcp/mgmt that Anthropic's directory does not list. CData documents eighteen administrative tools on it, including create_connection, which saves new credentials for another data source, and set_tool_op_enabled, which turns individual operations on or off inside a toolkit.

By default, yes. CData states that all users on an account access a data source through the same login credentials, so a Salesforce connection made by one administrator serves everyone. Some sources support per-user authentication instead, but CData notes this is not available for every source and only administrators can switch it on.

Yes, in two separate logs. CData's query log records the timestamp, query type, user, status, connection and full query text for every query, and a separate audit log records administrative tasks such as user creation and permission changes. Downloadable per-query log files are retained for seven days only.

At least one configured data source. CData's Claude setup page lists connecting a data source to your Connect AI account as the prerequisite, because the connector has no data of its own. Toolkits, which scope the MCP surface to chosen connections and operations, additionally require a Growth+ plan and administrator rights.