SQL Dialect Converter & Analyzer

sql-dialect-converter-analyzer

Use SQL Dialect Converter & Analyzer through the Zavilo SDK. Check input limits, parameters, output and supported modes below.

H · HeadlessE · Embedded

Tool IDsql-dialect-converter-analyzer

Version1

ExecutionCLIENT

WorkloadSTANDARD

ModesHeadless, Embedded

Quick actions

Input files 0–1Output files 0

Result handling → Recipes → Integration examples → Playground →

Input

Accepted input contract for this Tool.

Kind	file-or-data
File count	0 – 1
Accepted MIME types	text/plain, application/sql

Parameters

Pass these values through request.options.

Parameter	Type	Required	Default	Allowed / Range	Description
`operation`	enum	Optional	`analyze`	convert \| analyze	convert performs common rule-based dialect conversion; analyze performs static heuristic analysis without a database connection.
`sourceDialect`	enum	Optional	—	mysql \| postgres \| sqlserver	Source SQL dialect. Required when operation=convert.
`targetDialect`	enum	Optional	—	mysql \| postgres \| sqlserver	Target SQL dialect. Required when operation=convert.

Output

Result contract returned after successful processing.

Type	data
File count	0 – 0
MIME types	None
Metadata	statement, tables, joins, ctes, warnings, sourceDialect, targetDialect
ZIP archive	No

Basic usage

Choose a supported integration mode and copy the generated starter code.

Headless

const result = await client.run("sql-dialect-converter-analyzer", {
  
  options: { operation: "analyze" }
});
console.log(result.files, result.data, result.metadata);

Embedded

await client.mount({ tool: "sql-dialect-converter-analyzer", target: "#zavilo-tool", mode: "embedded" });

This page is generated from the SDK Tool Definition used by the runtime.