DataZen Documentation
DataZen User Guide

AI-Generated SQL CDC

DataZen SQL CDC is a rich language with many operations, options, and patterns. When an LLM writes scripts from general knowledge alone, it often invents invalid syntax. The open-source datazen-sqlcdc MCP server gives AI assistants first-class access to the official SQL CDC language specification so they can list operations, look up exact syntax, and pull canonical examples before generating a script.

Unlike the pipeline and API MCP servers, datazen-sqlcdc is a local language-spec server. It needs no Service Token, agent id, or Function App URL.

What It Enables

Point Claude Desktop, Cursor, Hermes, or any MCP-compatible client at this server. The assistant can then:

  • Discover every SQL CDC operation and a short description
  • Retrieve the exact syntax template and options for a chosen operation
  • Load working examples to model the generated script after

A typical flow is list_operations → get_operation → get_examples, then the assistant drafts a script that matches DataZen conventions. You can paste the result into the Portal SQL Editor or DataZen Manager and refine it with Preview runs.

MCP Tools

Tool Input Output
list_operations none One line per operation: key, command, and short description
get_operation operationKey Markdown with description, syntax, and options
get_examples operationKey, optional maxExamples Canonical SQL CDC examples in fenced SQL blocks

Operation keys are matched case-insensitively (for example addColumn and addcolumn both work).

Register the MCP Server

Run with no install via npx. Claude Desktop / Cursor example: 

{
  "mcpServers": {
    "datazen-spec": {
      "command": "npx",
      "args": ["-y", "datazen-sqlcdc@latest"]
    }
  }
}

Hermes YAML (no env block required): 

mcp_servers:
  datazen-spec:
    command: "npx"
    args: ["-y", "datazen-sqlcdc@latest"]

Full registration options, including Claude Code and a global install, are on the npm package page.

Programmatic Spec Access

The same package exports the fully resolved SQL CDC specification as typed JSON for tools and editors that do not use MCP. Import the default export from datazen-sqlcdc or load datazen-sqlcdc/sqlcdc-spec.json directly.

Related Topics