5.19 Release notes

Upgrade guides

• Upgrading on IIS
• Upgrading on Kubernetes

5.19 Release notes

Release date

Cinchy v5.19 was released on April 2, 2026.

New capabilities

Cinchy MCP Server

Cinchy v5.19 introduces the Cinchy MCP Server, a Model Context Protocol (MCP) server that lets AI assistants like Claude, Gemini, and ChatGPT interact directly with your Cinchy data platform.

MCP is an open standard created by Anthropic that provides a universal interface for AI models to interact with external tools and data sources. Think of it as USB-C for AI: one protocol that connects any AI client to any data platform.

With the Cinchy MCP Server, you can use natural language in your AI assistant to query tables, insert and update data, troubleshoot data syncs, and more. All operations are authenticated under your own identity and respect Cinchy's row and column-level entitlements.

---

How it works

You ask a question in plain English. The AI assistant picks the right tool, the MCP server calls the Cinchy API using your identity, and Cinchy enforces your permissions. You never leave your AI client.

---

What you can do

The Cinchy MCP Server exposes 21 tools that AI assistants can call on your behalf. Click a category below to see what's possible.

Explore data

Your prompt

"What tables are in the HR domain?"

The AI uses list_tables to browse domains and tables, then get_table_schema to show column structures. No queries needed.

Your prompt

"Find everything related to customer invoices"

The discover_data tool performs a smart lookup across table names, column names, and saved queries using natural language keywords.

Tools in this category

Tool	Description
list_tables	List tables in a domain or across all domains
get_table_schema	Get columns and their types for a table
discover_data	Smart lookup by natural language keywords
search_data	Search row data across text and link columns

Query and modify

Your prompt

"Show me all active employees hired in the last 6 months"

The AI uses execute_cql to run a CQL query on your behalf. Since CQL is similar to T-SQL, the AI constructs queries directly from your natural language request.

Your prompt

"Add a new row to the Contacts table with name 'Acme Corp' and type 'Vendor'"

Tools like insert_row, update_row, delete_rows, and bulk_insert allow data changes, all subject to your Cinchy permissions.

Tools in this category

Tool	Description
execute_cql	Execute a CQL (Cinchy Query Language) query
insert_row	Insert a new row into a table
update_row	Update a row by Cinchy Id
delete_rows	Delete rows by Cinchy Ids
bulk_insert	Insert multiple rows in one operation

Troubleshoot syncs

Your prompt

"Why is my Salesforce sync failing?"

The diagnose_sync tool provides a one-shot diagnosis of any Data Sync Configuration. It pulls together the config, execution history, and recent errors so the AI can pinpoint the root cause.

Your prompt

"Validate the column mappings on my sync config before I run it"

The validate_sync_config tool checks source/target columns, mappings, sync keys, mandatory attributes, and data type compatibility, catching misconfigurations before they cause runtime errors.

Tools in this category

Tool	Description
validate_sync_config	Validate columns, mappings, keys, and data types
diagnose_sync	Comprehensive one-shot diagnosis
get_sync_errors	Get execution errors for a sync config
get_sync_execution_history	Get execution history (batch and event)
get_sync_execution_detail	Detailed results for a specific execution
download_sync_logs	Download error log files (CSV)
get_listener_status	Check Event Listener status and topic info

Run syncs

Your prompt

"Run the nightly inventory sync and show me the results"

The AI can execute_sync to trigger a batch sync job, then use get_sync_execution_history and get_sync_execution_detail to show you the outcome, including record counts, errors, and duration.

Tools in this category

Tool	Description
execute_sync	Trigger a batch Data Sync job by config name
get_sync_execution_history	View execution history after a run
get_sync_execution_detail	Drill into record counts, errors, and duration

Platform health

Your prompt

"Give me an overview of the platform"

The get_platform_health tool returns connection status, counts of domains, tables, users, and a data sync overview. A quick health check from a single prompt.

Your prompt

"Describe the Finance domain"

The describe_domain tool returns a comprehensive view of a domain including all tables, columns, types, and link targets.

Tools in this category

Tool	Description
execute_saved_query	Execute pre-built CQL saved queries
get_platform_health	Platform statistics and sync overview
describe_domain	Full domain view with tables and columns

---

All 21 tools at a glance

Click a category to view the tools available.

Core

#	Tool	Access	Description
1	test_connection	Read	Test connectivity to Cinchy server
2	list_tables	Read	List tables in a domain or across all domains
3	get_table_schema	Read	Get columns and their types for a table
4	execute_cql	Read/Write	Execute a CQL query (SELECT, INSERT, UPDATE, DELETE)

Data

#	Tool	Access	Description
5	insert_row	Write	Insert a new row into a table
6	update_row	Write	Update an existing row by Cinchy Id
7	delete_rows	Write	Delete one or more rows by Cinchy Ids
8	bulk_insert	Write	Insert multiple rows in a single operation

Syncs

#	Tool	Access	Description
9	validate_sync_config	Read	Validate columns, mappings, sync keys, and data types
10	diagnose_sync	Read	Comprehensive one-shot diagnosis of a sync config
11	get_sync_errors	Read	Get execution errors for a sync config
12	get_sync_execution_history	Read	Get execution history (batch and event)
13	get_sync_execution_detail	Read	Detailed results for a specific batch execution
14	download_sync_logs	Read	Download error log files (CSV)
15	get_listener_status	Read	Check Event Listener status, topic, and cursor position
16	execute_sync	Write	Trigger a batch Data Sync job by config name

Discovery

#	Tool	Access	Description
17	discover_data	Read	Smart lookup by natural language keywords
18	search_data	Read	Search row data across text and link columns

Platform

#	Tool	Access	Description
19	execute_saved_query	Read	Execute pre-built CQL saved queries
20	get_platform_health	Read	Platform statistics, domain/table/user counts, sync overview
21	describe_domain	Read	Full domain view with all tables, columns, and link targets

---

Security and authentication

Every MCP tool call runs as the authenticated user. Cinchy's existing row-level and column-level entitlements are fully enforced. The AI assistant can only see and modify data that you have access to. There are no elevated privileges or service account workarounds.

Authentication uses OAuth 2.1 with PKCE. When you connect an AI client (e.g., Claude.ai), you are redirected to the Cinchy login page to authenticate. The MCP server passes your identity through to the Cinchy REST API on every tool call.

---

Connecting with Claude Desktop

To connect the Cinchy MCP Server with Claude Desktop:

1. Open Claude Desktop and click the + button in the chat input area.
2. Select Connectors.
3. Find Cinchy in the list and click Connect.
4. You will be redirected to the Cinchy login page. Enter your credentials to authenticate.
5. Once authenticated, you can start using natural language to interact with your Cinchy data directly from Claude Desktop.

warning

Only the Owner of the Claude organization subscription can add MCP connectors. Team members cannot add or manage connectors on their own. The Owner must configure the Cinchy MCP connection for the organization.

To add the Cinchy MCP connector as an Owner:

1. Navigate to Settings > Connectors in Claude Desktop.
2. Click Add Connector.
3. Fill in the following fields:
   • Name: Cinchy (or any name you prefer)
   • URL: Your Cinchy MCP Server URL (e.g., https://your-environment.cinchy.net/mcp)
4. Leave Client ID and Client Secret blank. These fields are optional and should not be filled in.
5. Click Save.

---

Bug fixes

• Fixed an issue where the Cinchy Connections WebApi IIS package did not include the correct IBM DB2 native driver libraries for Windows. The build pipeline now produces platform-specific builds for both Linux and Windows (IIS), ensuring that DB2 data sources work correctly on IIS deployments.

Post-upgrade step for IIS customers using DB2

After upgrading Cinchy Connections to v5.19.0 on IIS, you must add the DB2 CLI driver to the system PATH and restart IIS. Run the following in an elevated PowerShell prompt on the machine hosting Cinchy Connections:

$clidriver = "<path\to\clidriver>"
[Environment]::SetEnvironmentVariable("PATH", "$clidriver\bin;$clidriver\bin\icc64;$env:PATH", "Machine")
iisreset

For example, if Cinchy Connections is installed at C:\inetpub\wwwroot\Connections:

$clidriver = "C:\inetpub\wwwroot\Connections\clidriver"
[Environment]::SetEnvironmentVariable("PATH", "$clidriver\bin;$clidriver\bin\icc64;$env:PATH", "Machine")
iisreset

warning

If the Cinchy Connections Worker is hosted on a separate machine, repeat this process on that machine as well.