Avrotize — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Avrotize (Agent Skill) and scored it 45/100 (orange). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 1 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 1 flagged
A base64 string of 128+ characters appears in a documentation file. Encoded prompt injection hides the hostile instruction in base64 — invisible to keyword filters — and relies on the agent's ability to decode it at runtime. There is no normal authoring reason to embed a multi-hundred-byte base64 blob in skill docs.
*.sig, SIGNATURES) outside the documentation.Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
mcp-name: io.github.clemensv/avrotize
[📚 Documentation & Examples](https://clemensv.github.io/avrotize/) | [🎨 Conversion Gallery](https://clemensv.github.io/avrotize/gallery/)
Avrotize is a "Rosetta Stone" for data structure definitions, allowing you to convert between numerous data and database schema formats and to generate code for different programming languages.
It is, for instance, a well-documented and predictable converter and code generator for data structures originally defined in JSON Schema (of arbitrary complexity).
The tool leans on the Apache Avro-derived Avrotize Schema as its schema model.
You can install Avrotize from PyPI, having installed Python 3.10 or later:
pip install avrotizeFor MCP server support (avrotize mcp), install with the MCP extra:
pip install "avrotize[mcp]"For SQL database support (sql2a command), install the optional database drivers:
# PostgreSQL
pip install avrotize[postgres]
# MySQL
pip install avrotize[mysql]
# SQL Server
pip install avrotize[sqlserver]
# All SQL databases
pip install avrotize[all-sql]Avrotize provides several commands for converting schema formats via Avrotize Schema.
Converting to Avrotize Schema:
avrotize p2a - Convert Protobuf (2 or 3) schema to Avrotize Schema.avrotize j2a - Convert JSON schema to Avrotize Schema.avrotize x2a - Convert XML schema to Avrotize Schema.avrotize asn2a - Convert ASN.1 to Avrotize Schema.avrotize k2a - Convert Kusto table definitions to Avrotize Schema.avrotize sql2a - Convert SQL database schema to Avrotize Schema.avrotize json2a - Infer Avro schema from JSON files.avrotize json2s - Infer JSON Structure schema from JSON files.avrotize xml2a - Infer Avro schema from XML files.avrotize xml2s - Infer JSON Structure schema from XML files.avrotize pq2a - Convert Parquet schema to Avrotize Schema.avrotize csv2a - Convert CSV file to Avrotize Schema.avrotize kstruct2a - Convert Kafka Connect Schema to Avrotize Schema.Converting from Avrotize Schema:
avrotize a2p - Convert Avrotize Schema to Protobuf 3 schema.avrotize a2j - Convert Avrotize Schema to JSON schema.avrotize a2x - Convert Avrotize Schema to XML schema.avrotize a2k - Convert Avrotize Schema to Kusto table definition.avrotize s2k - Convert JSON Structure Schema to Kusto table definition.avrotize a2sql - Convert Avrotize Schema to SQL table definition.avrotize s2sql - Convert JSON Structure Schema to SQL table definition.avrotize a2pq - Convert Avrotize Schema to Parquet or Iceberg schema.avrotize a2ib - Convert Avrotize Schema to Iceberg schema.avrotize s2ib - Convert JSON Structure to Iceberg schema.avrotize a2mongo - Convert Avrotize Schema to MongoDB schema.avrotize a2cassandra - Convert Avrotize Schema to Cassandra schema.avrotize s2cassandra - Convert JSON Structure Schema to Cassandra schema.avrotize a2es - Convert Avrotize Schema to Elasticsearch schema.avrotize a2dynamodb - Convert Avrotize Schema to DynamoDB schema.avrotize a2cosmos - Convert Avrotize Schema to CosmosDB schema.avrotize a2couchdb - Convert Avrotize Schema to CouchDB schema.avrotize a2firebase - Convert Avrotize Schema to Firebase schema.avrotize a2hbase - Convert Avrotize Schema to HBase schema.avrotize a2neo4j - Convert Avrotize Schema to Neo4j schema.avrotize a2dp - Convert Avrotize Schema to Datapackage schema.avrotize a2md - Convert Avrotize Schema to Markdown documentation.avrotize s2md - Convert JSON Structure schema to Markdown documentation.Direct conversions (JSON Structure):
avrotize s2p - Convert JSON Structure to Protocol Buffers (.proto files).avrotize oas2s - Convert OpenAPI 3.x document to JSON Structure.Generate code from Avrotize Schema:
avrotize a2cs - Generate C# code from Avrotize Schema.avrotize a2java - Generate Java code from Avrotize Schema.avrotize a2py - Generate Python code from Avrotize Schema.avrotize a2ts - Generate TypeScript code from Avrotize Schema.avrotize a2js - Generate JavaScript code from Avrotize Schema.avrotize a2cpp - Generate C++ code from Avrotize Schema.avrotize a2go - Generate Go code from Avrotize Schema.avrotize a2rust - Generate Rust code from Avrotize Schema.Generate code from JSON Structure:
avrotize s2cpp - Generate C++ code from JSON Structure schema.avrotize s2cs - Generate C# code from JSON Structure schema.avrotize s2go - Generate Go code from JSON Structure schema.avrotize s2java - Generate Java code from JSON Structure schema.avrotize s2py - Generate Python code from JSON Structure schema.avrotize s2rust - Generate Rust code from JSON Structure schema.avrotize s2ts - Generate TypeScript code from JSON Structure schema.Direct JSON Structure conversions:
avrotize s2csv - Convert JSON Structure schema to CSV schema.avrotize a2csv - Convert Avrotize schema to CSV schema.avrotize s2x - Convert JSON Structure to XML Schema (XSD).avrotize s2graphql - Convert JSON Structure schema to GraphQL schema.avrotize a2graphql - Convert Avrotize schema to GraphQL schema.Other commands:
avrotize pcf - Create the Parsing Canonical Form (PCF) of an Avrotize Schema.avrotize validate - Validate JSON instances against Avro or JSON Structure schemas.avrotize mcp - Run Avrotize as a local MCP server exposing conversion tools to MCP clients.avrotize validate-tmsl - Validate TMSL scripts locally against documented object structure.JSON Structure conversions:
avrotize s2dp - Convert JSON Structure schema to Datapackage schema.You can run Avrotize as a local MCP server over stdio:
avrotize mcpCatalog-ready metadata files are included:
To publish to the official MCP Registry:
mcp-publisher validate server.json
mcp-publisher publish server.jsonThe MCP server exposes tools to:
describe_capabilities)list_conversions)get_conversion)run_conversion)You can use Avrotize to convert between Avro/Avrotize Schema and other schema formats like JSON Schema, XML Schema (XSD), Protocol Buffers (Protobuf), ASN.1, and database schema formats like Kusto Data Table Definition (KQL) and SQL Table Definition. That means you can also convert from JSON Schema to Protobuf going via Avrotize Schema.
You can also generate C#, Java, TypeScript, JavaScript, and Python code from Avrotize Schema documents. The difference to the native Avro tools is that Avrotize can emit data classes without Avro library dependencies and, optionally, with annotations for JSON serialization libraries like Jackson or System.Text.Json.
The tool does not convert data (instances of schemas), only the data structure definitions.
Mind that the primary objective of the tool is the conversion of schemas that describe data structures used in applications, databases, and message systems. While the project's internal tests do cover a lot of ground, it is nevertheless not a primary goal of the tool to convert every complex document schema like those used for devops pipeline or system configuration files.
Data structure definitions are an essential part of data exchange, serialization, and storage. They define the shape and type of data, and they are foundational for tooling and libraries for working with the data. Nearly all data schema languages are coupled to a specific data exchange or storage format, locking the definitions to that format.
Avrotize is designed as a tool to "unlock" data definitions from JSON Schema or XML Schema and make them usable in other contexts. The intent is also to lay a foundation for transcoding data from one format to another, by translating the schema definitions as accurately as possible into the schema model of the target format's schema. The transcoding of the data itself requires separate tools that are beyond the scope of this project.
The use of the term "data structure definition" and not "data object definition" is quite intentional. The focus of the tool is on data structures that can be used for messaging and eventing payloads, for data serialization, and for database tables, with the goal that those structures can be mapped cleanly from and to common programming language types.
Therefore, Avrotize intentionally ignores common techniques to model object-oriented inheritance. For instance, when converting from JSON Schema, all content from allOf expressions is merged into a single record type rather than trying to model the inheritance tree in Avro.
Avrotize Schema is a schema model that is a full superset of the popular Apache Avro Schema model. Avrotize Schema is the "pivot point" for this tool. All schemas are converted from and to Avrotize Schema.
Since Avrotize Schema is a superset of Avro Schema and uses its extensibility features, every Avrotize Schema is also a valid Avro Schema and vice versa.
Why did we pick Avro Schema as the foundational schema model?
Avro Schema ...
It needs to be noted here that while Avro Schema is great for defining data structures, and data classes generated from Avro Schema using this tool or other tools can be used to with the most popular JSON serialization libraries, the Apache Avro project's own JSON encoding has fairly grave interoperability issues with common usage of JSON. Avrotize defines an alternate JSON encoding
in avrojson.md.
Avro Schema does not support all the bells and whistles of XML Schema or JSON Schema, but that is a feature, not a bug, as it ensures the portability of the schemas across different systems and infrastructures. Specifically, Avro Schema does not support many of the data validation features found in JSON Schema or XML Schema. There are no pattern, format, minimum, maximum, or required keywords in Avro Schema, and Avro does not support conditional validation.
In a system where data originates as XML or JSON described by a validating XML Schema or JSON Schema, the assumption we make here is that data will be validated using its native schema language first, and then the Avro Schema will be used for transformation or transfer or storage.
When converting Avrotize Schema to Kusto Data Table Definition (KQL), SQL Table Definition, or Parquet Schema, the tool can add special columns for CloudEvents attributes. CNCF CloudEvents is a specification for describing event data in a common way.
The rationale for adding such columns to database tables is that messages and events commonly separate event metadata from the payload data, while that information is merged when events are projected into a database. The metadata often carries important context information about the event that is not contained in the payload itself. Therefore, the tool can add those columns to the database tables for easy alignment of the message context with the payload when building event stores.
avrotize p2a <path_to_proto_file> [--out <path_to_avro_schema_file>]Parameters:
<path_to_proto_file>: The path to the Protobuf schema file to be converted. If omitted, the file is read from stdin.--out: The path to the Avrotize Schema file to write the conversion result to. If omitted, the output is directed to stdout.Conversion notes:
Timestamp type is mapped to the Avro logical type 'timestamp-millis'. The rest of the well-known Protobuf types are kept as Avro record types with the same field names and types.map, Avro does not. When converting from Proto to Avro, the type information for the map keys is ignored.extensions and reserved keywords in the Proto schema.optional keyword results in an Avro field being nullable (union with the null type), while the required keyword results in a non-nullable field. The repeated keyword results in an Avro field being an array of the field type.oneof keyword in Proto is mapped to an Avro union type.options in the Proto schema are ignored.avrotize a2p <path_to_avro_schema_file> [--out <path_to_proto_directory>] [--naming <naming_mode>] [--allow-optional]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the Protobuf schema directory to write the conversion result to. If omitted, the output is directed to stdout.--naming: (optional) Type naming convention. Choices are snake, camel, pascal.--allow-optional: (optional) Enable support for 'optional' fields.Conversion notes:
.proto file with the package definition and an import statement for each namespace found in the Avrotize Schema.[] are converted to oneof expressions in Proto. Avro allows for maps and arrays in the type union, whereas Proto only supports scalar types and message type references. The tool will therefore emit message types containing a single array or map field for any such case and add it to the containing type, and will also recursively resolve further unions in the array and map values.oneof expressions, the alternative fields need to be assigned field numbers, which will shift the field numbers for any subsequent fields.avrotize j2a <path_to_json_schema_file> [--out <path_to_avro_schema_file>] [--namespace <avro_schema_namespace>] [--split-top-level-records]Parameters:
<path_to_json_schema_file>: The path to the JSON schema file to be converted. If omitted, the file is read from stdin.--out: The path to the Avrotize Schema file to write the conversion result to. If omitted, the output is directed to stdout.--namespace: (optional) The namespace to use in the Avrotize Schema if the JSON schema does not define a namespace.--split-top-level-records: (optional) Split top-level records into separate files.Conversion notes:
avrotize a2j <path_to_avro_schema_file> [--out <path_to_json_schema_file>] [--naming <naming_mode>]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the JSON schema file to write the conversion result to. If omitted, the output is directed to stdout.--naming: (optional) Type naming convention. Choices are snake, camel, pascal, default.Conversion notes:
avrotize x2a <path_to_xsd_file> [--out <path_to_avro_schema_file>] [--namespace <avro_schema_namespace>]Parameters:
<path_to_xsd_file>: The path to the XML schema file to be converted. If omitted, the file is read from stdin.--out: The path to the Avrotize Schema file to write the conversion result to. If omitted, the output is directed to stdout.--namespace: (optional) The namespace to use in the Avrotize Schema if the XML schema does not define a namespace.Conversion notes:
xsd:any as Avro does not support arbitrary typing and must always use a named type. The tool will map xsd:any to a field any typed as a union that allows scalar values or two levels of array and/or map nesting.simpleType declarations that define enums are mapped to enum types in Avro. All other facets are ignored and simple types are mapped to the corresponding Avro type.complexType declarations that have simple content where a base type is augmented with attributes is mapped to a record type in Avro. Any other facets defined on the complex type are ignored.xmlkind extension attribute that indicates whether the field was an element or an attribute in the XML schema.avrotize a2x <path_to_avro_schema_file> [--out <path_to_xsd_schema_file>] [--namespace <target_namespace>]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the XML schema file to write the conversion result to. If omitted, the output is directed to stdout.--namespace: (optional) Target namespace for the XSD schema.Conversion notes:
then joined with a choice.
avrotize s2x <path_to_structure_file> [--out <path_to_xsd_schema_file>] [--namespace <target_namespace>]Parameters:
<path_to_structure_file>: The path to the JSON Structure schema file to be converted. If omitted, the file is read from stdin.--out: The path to the XML schema file to write the conversion result to. If omitted, the output is directed to stdout.--namespace: (optional) Target namespace for the XSD schema.Conversion notes:
binary/bytes → xs:base64Binarydate → xs:datetime → xs:timedatetime/timestamp → xs:dateTimeduration → xs:durationuuid → xs:stringuri → xs:anyURIdecimal → xs:decimalarray and set → complex types with sequences of itemsmap → complex type with entry elements containing key and valuetuple → complex type with fixed sequence of typed itemschoice or type arrays like ["string", "null"]):xs:choice elementsminOccurs="0"$ref) are resolved to named XSD types$extends) are mapped to XSD complex type extensions with xs:complexContentabstract="true" in XSDminOccurs="1", optional properties have minOccurs="0"avrotize asn2a <path_to_asn1_schema_file>[,<path_to_asn1_schema_file>,...] [--out <path_to_avro_schema_file>]Parameters:
<path_to_asn1_schema_file>: The path to the ASN.1 schema file to be converted. The tool supports multiple files in a comma-separated list. If omitted, the file is read from stdin.--out: The path to the Avrotize Schema file to write the conversion result to. If omitted, the output is directed to stdout.Conversion notes:
SEQUENCE and SET are mapped to Avro record types.CHOICE is mapped to an Avro record types with all fields being optional. While the CHOICE type technically corresponds to an Avro union, the ASN.1 type has different named fields for each option, which is not a feature of Avro unions.OBJECT IDENTIFIER is mapped to an Avro string type.ENUMERATED is mapped to an Avro enum type.SEQUENCE OF and SET OF are mapped to Avro array type.BIT STRING is mapped to Avro bytes type.OCTET STRING is mapped to Avro bytes type.INTEGER is mapped to Avro long type.REAL is mapped to Avro double type.BOOLEAN is mapped to Avro boolean type.NULL is mapped to Avro null type.UTF8String, PrintableString, IA5String, BMPString, NumericString, TeletexString, VideotexString, GraphicString, VisibleString, GeneralString, UniversalString, CharacterString, T61String are all mapped to Avro string type.avrotize k2a --kusto-uri <kusto_cluster_uri> --kusto-database <kusto_database> [--out <path_to_avro_schema_file>] [--emit-cloudevents-xregistry]Parameters:
--kusto-uri: The URI of the Kusto cluster to connect to.--kusto-database: The name of the Kusto database to read the table definitions from.--out: The path to the Avrotize Schema file to write the conversion result to. If omitted, the output is directed to stdout.--emit-cloudevents-xregistry: (optional) See discussion below.Conversion notes:
bool is mapped to Avro boolean type.datetime is mapped to Avro long type with logical type timestamp-millis.decimal is mapped to a logical Avro type with the logicalType set to decimal and the precision and scale set to the values of the decimal type in Kusto.guid is mapped to Avro string type.int is mapped to Avro int type.long is mapped to Avro long type.real is mapped to Avro double type.string is mapped to Avro string type.timespan is mapped to a logical Avro type with the logicalType set to duration.dynamic columns, the tool will sample the data in the table to determine the structure of the dynamic column. The tool will map the dynamic column to an Avro record type with fields that correspond to the fields found in the dynamic column. If the dynamic column contains nested dynamic columns, the tool will recursively map those to Avro record types. If records with conflicting structures are found in the dynamic column, the tool will emit a union of record types for the dynamic column.--emit-cloudevents-xregistry option is set, the tool will emit an xRegistry registry manifest file with a CloudEvent message definition for each table in the Kusto database and a separate Avro Schema for each table in the embedded schema registry. If one or more tables are found to contain CloudEvent data (as indicated by the presence of the CloudEvents attribute columns), the tool will inspect the content of the type (or __type or __type) columns to determine which CloudEvent types have been stored in the table and will emit a CloudEvent definition and schema for each unique type.avrotize sql2a --connection-string <connection_string> [--username <user>] [--password <pass>] [--dialect <dialect>] [--database <database>] [--table-name <table>] [--out <path_to_avro_schema_file>] [--namespace <namespace>] [--infer-json] [--infer-xml] [--sample-size <n>] [--emit-cloudevents] [--emit-xregistry]Parameters:
--connection-string: The database connection string. Supports SSL/TLS and integrated authentication options (see examples below).--username: (optional) Database username. Overrides any username in the connection string. Use this to avoid credentials in command history.--password: (optional) Database password. Overrides any password in the connection string. Use this to avoid credentials in command history.--dialect: (optional) The SQL dialect: postgres (default), mysql, sqlserver, oracle, or sqlite.--database: (optional) The database name if not specified in the connection string.--table-name: (optional) A specific table to convert. If omitted, all tables are converted.--out: The path to the Avrotize Schema file. If omitted, output goes to stdout.--namespace: (optional) The Avro namespace for the generated schema.--infer-json: (optional, default: true) Infer schema for JSON/JSONB columns by sampling data.--infer-xml: (optional, default: true) Infer schema for XML columns by sampling data.--sample-size: (optional, default: 100) Number of rows to sample for JSON/XML schema inference.--emit-cloudevents: (optional) Detect CloudEvents tables and emit CloudEvents declarations.--emit-xregistry: (optional) Emit an xRegistry manifest instead of a single schema file.Connection string examples:
# PostgreSQL with separate credentials (preferred for security)
avrotize sql2a --connection-string "postgresql://host:5432/mydb?sslmode=require" --username myuser --password mypass --out schema.avsc
# PostgreSQL with SSL (credentials in URL)
avrotize sql2a --connection-string "postgresql://user:pass@host:5432/mydb?sslmode=require" --out schema.avsc
# MySQL with SSL
avrotize sql2a --connection-string "mysql://user:pass@host:3306/mydb?ssl=true" --dialect mysql --out schema.avsc
# SQL Server with Windows Authentication (omit user/password)
avrotize sql2a --connection-string "mssql://@host:1433/mydb" --dialect sqlserver --out schema.avsc
# SQL Server with TLS encryption
avrotize sql2a --connection-string "mssql://user:pass@host:1433/mydb?encrypt=true" --dialect sqlserver --out schema.avsc
# SQLite file
avrotize sql2a --connection-string "/path/to/database.db" --dialect sqlite --out schema.avscConversion notes:
uuid, jsonb, xml, arrays, and custom types.json, enum, set, and spatial types.uniqueidentifier, xml, money, and hierarchyid.number, clob, blob, and Oracle-specific types.map<string, T> types instead of record types.doc attributes where available.unique attribute.avrotize json2a <json_files...> [--out <path>] [--type-name <name>] [--namespace <namespace>] [--sample-size <n>] [--infer-choices] [--choice-depth <n>]Parameters:
<json_files...>: One or more JSON files to analyze. Supports JSON arrays, single objects, and JSONL (JSON Lines) format. Use @filelist.txt to read file paths from a response file.--out: The path to the Avro schema file. If omitted, output goes to stdout.--type-name: (optional) Name for the root type (default: "Document").--namespace: (optional) Avro namespace for generated types.--sample-size: (optional) Maximum number of records to sample (0 = all, default: 0).--infer-choices: (optional) Detect discriminated unions and emit as Avro unions with discriminator field defaults.--choice-depth: (optional) Maximum nesting depth for choice inference (1 = root only, 2+ = nested objects, default: 1).Example:
# Infer schema from multiple JSON files
avrotize json2a data1.json data2.json --out schema.avsc --type-name Event --namespace com.example
# Infer schema from JSONL file with discriminated union detection
avrotize json2a events.jsonl --out events.avsc --type-name LogEntry --infer-choices
# Use response file for many input files
avrotize json2a @file_list.txt --out schema.avsc --infer-choices --choice-depth 2avrotize json2s <json_files...> [--out <path>] [--type-name <name>] [--base-id <uri>] [--sample-size <n>] [--infer-choices] [--choice-depth <n>] [--infer-enums]Parameters:
<json_files...>: One or more JSON files to analyze. Use @filelist.txt to read file paths from a response file.--out: The path to the JSON Structure schema file. If omitted, output goes to stdout.--type-name: (optional) Name for the root type (default: "Document").--base-id: (optional) Base URI for $id generation (default: "https://example.com/").--sample-size: (optional) Maximum number of records to sample (0 = all, default: 0).--infer-choices: (optional) Detect discriminated unions and emit as choice types with discriminator field defaults.--choice-depth: (optional) Maximum nesting depth for choice inference (1 = root only, 2+ = nested objects, default: 1).--infer-enums: (optional) Detect enum types from repeated string values with low cardinality.The inferrer also automatically detects:
datetime, date, or time.Example:
# Basic inference
avrotize json2s data.json --out schema.jstruct.json --type-name Person --base-id https://myapi.example.com/schemas/
# Full inference with choices and enums
avrotize json2s events/*.json --out events.jstruct.json --type-name Event --infer-choices --choice-depth 2 --infer-enums
# Process many files via response file
avrotize json2s @file_list.txt --out schema.jstruct.json --infer-choices --infer-enumsavrotize xml2a <xml_files...> [--out <path>] [--type-name <name>] [--namespace <namespace>] [--sample-size <n>]Parameters:
<xml_files...>: One or more XML files to analyze. Use @filelist.txt to read file paths from a response file.--out: The path to the Avro schema file. If omitted, output goes to stdout.--type-name: (optional) Name for the root type (default: "Document").--namespace: (optional) Avro namespace for generated types.--sample-size: (optional) Maximum number of documents to sample (0 = all, default: 0).Example:
avrotize xml2a config.xml --out config.avsc --type-name Configuration --namespace com.example.configavrotize xml2s <xml_files...> [--out <path>] [--type-name <name>] [--base-id <uri>] [--sample-size <n>]Parameters:
<xml_files...>: One or more XML files to analyze. Use @filelist.txt to read file paths from a response file.--out: The path to the JSON Structure schema file. If omitted, output goes to stdout.--type-name: (optional) Name for the root type (default: "Document").--base-id: (optional) Base URI for $id generation (default: "https://example.com/").--sample-size: (optional) Maximum number of documents to sample (0 = all, default: 0).Conversion notes (applies to all inference commands):
@ (normalized to valid identifiers).#text field.avrotize a2k <path_to_avro_schema_file> [--out <path_to_kusto_kql_file>] [--record-type <record_type>] [--emit-cloudevents-columns] [--emit-cloudevents-dispatch]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the Kusto KQL file to write the conversion result to. If omitted, the output is directed to stdout.--record-type: (optional) The name of the Avro record type to convert to a Kusto table.--emit-cloudevents-columns: (optional) If set, the tool will add CloudEvents attribute columns to the table: ___id, ___source, ___subject, ___type, and ___time.--emit-cloudevents-dispatch: (optional) If set, the tool will add a table named _cloudevents_dispatch to the script or database, which serves as an ingestion and dispatch table for CloudEvents. The table has columns for the core CloudEvents attributes and a data column that holds the CloudEvents data. For each table in the Avrotize Schema, the tool will create an update policy that maps events whose type attribute matches the Avro type name to the respective table.Conversion notes:
record type can be mapped to a Kusto table. If the Avrotize Schema contains other types (like enum or array), the tool will ignore them.record type in the Avrotize Schema is converted to a Kusto table. If the Avrotize Schema contains other record types, they will be ignored. The --record-type option can be used to specify which record type to convert.dynamic in the Kusto table.avrotize s2k <path_to_structure_schema_file> [--out <path_to_kusto_kql_file>] [--record-type <record_type>] [--emit-cloudevents-columns] [--emit-cloudevents-dispatch]Parameters:
<path_to_structure_schema_file>: The path to the JSON Structure Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the Kusto KQL file to write the conversion result to. If omitted, the output is directed to stdout.--record-type: (optional) The name of the record type to convert to a Kusto table.--emit-cloudevents-columns: (optional) If set, the tool will add CloudEvents attribute columns to the table: ___id, ___source, ___subject, ___type, and ___time.--emit-cloudevents-dispatch: (optional) If set, the tool will add a table named _cloudevents_dispatch to the script or database, which serves as an ingestion and dispatch table for CloudEvents. The table has columns for the core CloudEvents attributes and a data column that holds the CloudEvents data. For each table in the JSON Structure Schema, the tool will create an update policy that maps events whose type attribute matches the type name to the respective table.Conversion notes:
object types can be mapped to a Kusto table. Other types (like enum, array, choice) are not directly convertible to tables.object type found in the schema, or uses the type specified with --record-type.dynamic.string, uri, jsonpointer → stringboolean → boolinteger, int8, uint8, int16, uint16, int32 → intuint32, int64, uint64 → longint128, uint128, decimal → decimalnumber, float, double, float8, binary32, binary64 → realdate, datetime, timestamp → datetimetime, duration → timespanuuid → guidbinary → dynamicavrotize a2sql [input] --out <path_to_sql_script> --dialect <dialect>Parameters:
input: The path to the Avrotize schema file to be converted (or read from stdin if omitted).--out: The path to the SQL script file to write the conversion result to.--dialect: The SQL dialect (database type) to target. Supported dialects include:mysql, mariadb, postgres, sqlserver, oracle, sqlite, bigquery, snowflake, redshift, db2--emit-cloudevents-columns: (Optional) Add CloudEvents columns to the SQL table.For detailed conversion rules and type mappings for each SQL dialect, refer to the SQL Conversion Notes document.
avrotize s2sql [input] --out <path_to_sql_script> --dialect <dialect> [--emit-cloudevents-columns]Parameters:
input: The path to the JSON Structure schema file to be converted (or read from stdin if omitted).--out: The path to the SQL script file to write the conversion result to.--dialect: The SQL dialect (database type) to target. Supported dialects include:mysql, mariadb, postgres, sqlserver, oracle, sqlite, bigquery, snowflake, redshift, db2--emit-cloudevents-columns: (Optional) Add CloudEvents columns to the SQL table.Conversion notes:
namespace and name properties from the JSON Structure schema are used to construct table names.maxLength, precision, and scale are preserved in column comments.For detailed conversion rules and type mappings for each SQL dialect when converting from JSON Structure, refer to the SQL Conversion Notes document.
avrotize a2mongo <path_to_avro_schema_file> [--out <path_to_mongodb_schema>] [--emit-cloudevents-columns]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the MongoDB schema file to write the conversion result to.--emit-cloudevents-columns: (optional) If set, the tool will add CloudEvents attribute columns to the MongoDB schema.Conversion notes:
object.mongoimport tool to create a collection with the specified schema.Here are the "Convert ..." sections for the newly added commands:
avrotize a2cassandra [input] --out <output_directory> [--emit-cloudevents-columns]input: Path to the Avrotize schema file (or read from stdin if omitted).--out: Output path for the Cassandra schema (required).--emit-cloudevents-columns: Add CloudEvents columns to the Cassandra schema (optional, default: false).Refer to the detailed conversion notes for Cassandra in the NoSQL Conversion Notes.
avrotize s2cassandra [input] --out <output_file> [--emit-cloudevents-columns]Parameters:
input: Path to the JSON Structure schema file (or read from stdin if omitted).--out: Output path for the Cassandra CQL schema file (required).--emit-cloudevents-columns: Add CloudEvents columns to the Cassandra schema (optional, default: false).Conversion notes:
Refer to the detailed conversion notes for Cassandra in the NoSQL Conversion Notes.
avrotize a2dynamodb [input] --out <output_directory> [--emit-cloudevents-columns]input: Path to the Avrotize schema file (or read from stdin if omitted).--out: Output path for the DynamoDB schema (required).--emit-cloudevents-columns: Add CloudEvents columns to the DynamoDB schema (optional, default: false).Refer to the detailed conversion notes for DynamoDB in the NoSQL Conversion Notes.
avrotize a2es [input] --out <output_directory> [--emit-cloudevents-columns]input: Path to the Avrotize schema file (or read from stdin if omitted).--out: Output path for the Elasticsearch schema (required).--emit-cloudevents-columns: Add CloudEvents columns to the Elasticsearch schema (optional, default: false).Refer to the detailed conversion notes for Elasticsearch in the NoSQL Conversion Notes.
avrotize a2couchdb [input] --out <output_directory> [--emit-cloudevents-columns]input: Path to the Avrotize schema file (or read from stdin if omitted).--out: Output path for the CouchDB schema (required).--emit-cloudevents-columns: Add CloudEvents columns to the CouchDB schema (optional, default: false).Refer to the detailed conversion notes for CouchDB in the NoSQL Conversion Notes.
avrotize a2neo4j [input] --out <output_directory> [--emit-cloudevents-columns]input: Path to the Avrotize schema file (or read from stdin if omitted).--out: Output path for the Neo4j schema (required).--emit-cloudevents-columns: Add CloudEvents columns to the Neo4j schema (optional, default: false).Refer to the detailed conversion notes for Neo4j in the NoSQL Conversion Notes.
avrotize a2firebase [input] --out <output_directory> [--emit-cloudevents-columns]input: Path to the Avrotize schema file (or read from stdin if omitted).--out: Output path for the Firebase schema (required).--emit-cloudevents-columns: Add CloudEvents columns to the Firebase schema (optional, default: false).Refer to the detailed conversion notes for Firebase in the NoSQL Conversion Notes.
avrotize a2cosmos [input] --out <output_directory> [--emit-cloudevents-columns]input: Path to the Avrotize schema file (or read from stdin if omitted).--out: Output path for the CosmosDB schema (required).--emit-cloudevents-columns: Add CloudEvents columns to the CosmosDB schema (optional, default: false).Refer to the detailed conversion notes for CosmosDB in the NoSQL Conversion Notes.
avrotize a2hbase [input] --out <output_directory> [--emit-cloudevents-columns]input: Path to the Avrotize schema file (or read from stdin if omitted).--out: Output path for the HBase schema (required).--emit-cloudevents-columns: Add CloudEvents columns to the HBase schema (optional, default: false).Refer to the detailed conversion notes for HBase in the NoSQL Conversion Notes.
avrotize a2pq <path_to_avro_schema_file> [--out <path_to_parquet_schema_file>] [--record-type <record-type-from-avro>] [--emit-cloudevents-columns]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the Parquet schema file to write the conversion result to. If omitted, the output is directed to stdout.--record-type: (optional) The name of the Avro record type to convert to a Parquet schema.--emit-cloudevents-columns: (optional) If set, the tool will add CloudEvents attribute columns to the Parquet schema: __id, __source, __subject, __type, and __time.Conversion notes:
record type. If the Avrotize Schema contains a top-level union, the --record-type option must be used to specify which record type to emit.avrotize a2ib <path_to_avro_schema_file> [--out <path_to_iceberg_schema_file>] [--record-type <record-type-from-avro>] [--emit-cloudevents-columns] [--format schema|arrow]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the Iceberg schema file to write the conversion result to. If omitted, the output is directed to stdout.--record-type: (optional) The name of the Avro record type to convert to an Iceberg schema.--emit-cloudevents-columns: (optional) If set, the tool will add CloudEvents attribute columns to the Iceberg schema: __id, __source, __subject, __type, and __time.--format: (optional) Output format. schema (default) outputs JSON per the Iceberg Table Spec Appendix C. arrow outputs a binary Arrow IPC serialized schema.Conversion notes:
record type. If the Avrotize Schema contains a top-level union, the --record-type option must be used to specify which record type to emit.avrotize s2ib <path_to_structure_schema_file> [--out <path_to_iceberg_schema_file>] [--record-type <record-type-from-structure>] [--emit-cloudevents-columns] [--format schema|arrow]Parameters:
<path_to_structure_schema_file>: The path to the JSON Structure schema file to be converted. If omitted, the file is read from stdin.--out: The path to the Iceberg schema file to write the conversion result to. If omitted, the output is directed to stdout.--record-type: (optional) The name of the record type in definitions to convert to an Iceberg schema.--emit-cloudevents-columns: (optional) If set, the tool will add CloudEvents attribute columns to the Iceberg schema: ___id, ___source, ___subject, ___type, and ___time.--format: (optional) Output format. schema (default) outputs JSON per the Iceberg Table Spec Appendix C. arrow outputs a binary Arrow IPC serialized schema.Conversion notes:
type: "object" at the top level. If the schema contains a $ref or the record type is in definitions, the --record-type option can be used to specify which type to emit.string → StringType, boolean → BooleanType, numeric types (int8-128, uint8-128, float, double) → appropriate IntegerType/LongType/FloatType/DoubleTypebinary/bytes → BinaryType, date → DateType, time → TimeType, datetime/timestamp → TimestampType, duration → LongType (microseconds), decimal → DecimalType (with precision/scale), uuid/uri/jsonpointer → StringTypeobject → StructType, array/set → ListType, map → MapType, tuple → StructType with indexed fieldsprecision, scale, and validation constraints are preserved where applicable.$extends feature is supported - base type properties are included in the conversion.required field flag.avrotize pq2a <path_to_parquet_file> [--out <path_to_avro_schema_file>] [--namespace <avro_schema_namespace>]Parameters:
<path_to_parquet_file>: The path to the Parquet file to be converted. If omitted, the file is read from stdin.--out: The path to the Avrotize Schema file to write the conversion result to. If omitted, the output is directed to stdout.--namespace: (optional) The namespace to use in the Avrotize Schema if the Parquet file does not define a namespace.Conversion notes:
avrotize csv2a <path_to_csv_file> [--out <path_to_avro_schema_file>] [--namespace <avro_schema_namespace>]Parameters:
<path_to_csv_file>: The path to the CSV file to be converted. If omitted, the file is read from stdin.--out: The path to the Avrotize Schema file to write the conversion result to. If omitted, the output is directed to stdout.--namespace: (optional) The namespace to use in the Avrotize Schema if the CSV file does not define a namespace.Conversion notes:
avrotize kstruct2a [input] --out <path_to_avro_schema_file>Parameters:
input: The path to the Kafka Struct file to be converted (or read from stdin if omitted).--out: The path to the Avrotize Schema file to write the conversion result to.--kstruct: Deprecated: The path to the Kafka Struct file (for backward compatibility).Conversion notes:
avrotize a2cs <path_to_avro_schema_file> [--out <path_to_csharp_dir>] [--namespace <csharp_namespace>] [--avro-annotation] [--system_text_json_annotation] [--newtonsoft-json-annotation] [--pascal-properties]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the directory to write the C# classes to. Required.--namespace: (optional) The namespace to use in the C# classes.--avro-annotation: (optional) Use Avro annotations.--system_text_json_annotation: (optional) Use System.Text.Json annotations.--newtonsoft-json-annotation: (optional) Use Newtonsoft.Json annotations.--pascal-properties: (optional) Use PascalCase properties.Conversion notes:
--avro-annotation option adds Avro annotations, the --system_text_json_annotation option adds System.Text.Json annotations, and the --newtonsoft-json-annotation option adds Newtonsoft.Json annotations.--pascal-properties option changes the naming convention of the properties to PascalCase.avrotize a2java <path_to_avro_schema_file> [--out <path_to_java_dir>] [--package <java_package>] [--avro-annotation] [--jackson-annotation] [--pascal-properties]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the directory to write the Java classes to. Required.--package: (optional) The package to use in the Java classes.--avro-annotation: (optional) Use Avro annotations.--jackson-annotation: (optional) Use Jackson annotations.--pascal-properties: (optional) Use PascalCase properties.Conversion notes:
--avro-annotation option adds Avro annotations, and the --jackson-annotation option adds Jackson annotations.--pascal-properties option changes the naming convention of the properties to PascalCase.avrotize a2py <path_to_avro_schema_file> [--out <path_to_python_dir>] [--package <python_package>] [--dataclasses-json-annotation] [--avro-annotation]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the directory to write the Python classes to. Required.--package: (optional) The package to use in the Python classes.--dataclasses-json-annotation: (optional) Use dataclasses-json annotations.--avro-annotation: (optional) Use Avro annotations.Conversion notes:
--dataclasses-json-annotation option adds dataclasses-json annotations, and the --avro-annotation option adds Avro annotations.avrotize a2ts <path_to_avro_schema_file> [--out <path_to_typescript_dir>] [--package <typescript_package>] [--avro-annotation] [--typedjson-annotation]Parameters:
<path_to_avro_schema_file>: The path to the Avrotize Schema file to be converted. If omitted, the file is read from stdin.--out: The path to the directory to write the TypeScript classes to. Required.--package: (optional) The package to use in the TypeScript classes.--avro-annotation: (optional) Use Avro annotations.--typedjson-annotation: (optional) Use TypedJSON annotations.Conversion notes:
type, namespace, module, and readonly are preserved when used as field names.--avro-annotation option adds Avro annotations, and the --typedjson-annotation option adds TypedJSON annotations.avrotize s2ts <path_to_structure_schema_file> [--out <path_to_typescript_dir>] [--package <typescript_package>] [--typedjson-annotation] [--avro-annotation]Parameters:
<path_to_structure_schema_file>: The path to the JSON Structure schema file to be converted. If omitted, the file is read from stdin.--out: The path to the d~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.