Avrotize

Avrotize & Structurize

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.

• Programming languages: Python, C#, Java, TypeScript, JavaScript, Rust, Go, C++
• SQL Databases: MySQL, MariaDB, PostgreSQL, SQL Server, Oracle, SQLite, BigQuery, Snowflake, Redshift, DB2
• Other databases: KQL/Kusto, SurrealDB, MongoDB, Cassandra, Redis, Elasticsearch, DynamoDB, CosmosDB
• Data schema formats: Avro, JSON Schema, JSON Structure, XML Schema (XSD), Protocol Buffers 2 and 3, ASN.1, Apache Parquet, JSON Type Definition (JTD), CDDL, CUE, FlatBuffers, Apache Thrift IDL, Smithy IDL, Cap'n Proto, RAML 1.0 Data Types, and OpenAPI 3.x

Installation

You can install Avrotize from PyPI, having installed Python 3.10 or later:

pip install avrotize

For 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]

Usage

Avrotize provides several commands for converting schema formats via Avrotize Schema.

Converting to Avrotize Schema:

• avrotize s2a - Convert JSON Structure to Avrotize Schema.
• avrotize j2a - Convert JSON schema to Avrotize Schema.
• avrotize p2a - Convert Protobuf (2 or 3) schema to Avrotize Schema.
• avrotize x2a - Convert XML schema to Avrotize Schema.
• avrotize asn2a - Convert ASN.1 to Avrotize Schema.
• avrotize jtd2a - Convert JSON Type Definition (JTD) to Avrotize Schema.
• avrotize cue2a - Convert a supported CUE schema subset to Avrotize Schema.
• avrotize fbs2a - Convert FlatBuffers schema to Avrotize Schema.
• avrotize thrift2a - Convert Apache Thrift IDL to Avrotize Schema.
• avrotize smithy2a - Convert Smithy 2.0 IDL data shapes to Avrotize Schema.
• avrotize capnp2a - Convert Cap'n Proto schema to Avrotize Schema.
• avrotize raml2a - Convert RAML 1.0 Data Types to Avrotize Schema.
• avrotize kstruct2a - Convert Kafka Connect Schema to Avrotize Schema.
• avrotize sql2a - Convert SQL database schema to Avrotize Schema.
• avrotize k2a - Convert Kusto table definitions to Avrotize Schema.
• avrotize surreal2a - Convert SurrealQL schema definitions to Avrotize Schema.
• avrotize pq2a - Convert Parquet schema to Avrotize Schema.
• avrotize csv2a - Convert CSV file to Avrotize Schema.

Converting from Avrotize Schema:

• avrotize a2s - Convert Avrotize Schema to JSON Structure.
• avrotize a2j - Convert Avrotize Schema to JSON schema.
• avrotize a2p - Convert Avrotize Schema to Protobuf 3 schema.
• avrotize a2x - Convert Avrotize Schema to XML schema.
• avrotize a2asn - Convert Avrotize Schema to ASN.1 schema.
• avrotize a2jtd - Convert Avrotize Schema to JSON Type Definition (JTD).
• avrotize a2cue - Convert Avrotize Schema to the supported CUE schema subset.
• avrotize a2fbs - Convert Avrotize Schema to FlatBuffers schema.
• avrotize a2thrift - Convert Avrotize Schema to Apache Thrift IDL.
• avrotize a2smithy - Convert Avrotize Schema to Smithy 2.0 IDL data shapes.
• avrotize a2capnp - Convert Avrotize Schema to Cap'n Proto schema.
• avrotize a2raml - Convert Avrotize Schema to RAML 1.0 Data Types.
• avrotize a2sql - Convert Avrotize Schema to SQL table definition.
• avrotize a2k - Convert Avrotize Schema to Kusto table definition.
• avrotize a2tsml - Convert Avrotize Schema to Tabular Model Scripting Language (TMSL).
• avrotize a2surreal - Convert Avrotize Schema to SurrealQL schema definitions.
• avrotize a2pq - Convert Avrotize Schema to Parquet or Iceberg schema.
• avrotize a2ib - Convert Avrotize Schema to Iceberg schema.
• avrotize a2mongo - Convert Avrotize Schema to MongoDB schema.
• avrotize a2cassandra - Convert Avrotize 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 a2csv - Convert Avrotize schema to CSV schema.
• avrotize a2graphql - Convert Avrotize schema to GraphQL schema.
• avrotize a2md - Convert Avrotize Schema to Markdown documentation.

Converting to and from JSON Structure:

• avrotize j2s - Convert JSON Schema to JSON Structure.
• avrotize s2j - Convert JSON Structure to JSON Schema.
• avrotize s2p - Convert JSON Structure to Protocol Buffers (.proto files).
• avrotize s2x - Convert JSON Structure to XML Schema (XSD).
• avrotize s2asn - Convert JSON Structure Schema to ASN.1 schema.
• avrotize jtd2s - Convert JSON Type Definition (JTD) to JSON Structure.
• avrotize s2jtd - Convert JSON Structure to JSON Type Definition (JTD).
• avrotize cddl2s - Convert CDDL schema to JSON Structure.
• avrotize s2cddl - Convert JSON Structure to CDDL schema.
• avrotize oas2s - Convert OpenAPI 3.x document to JSON Structure.
• avrotize cue2s - Convert a supported CUE schema subset to JSON Structure.
• avrotize s2cue - Convert JSON Structure to the supported CUE schema subset.
• avrotize fbs2s - Convert FlatBuffers schema to JSON Structure.
• avrotize s2fbs - Convert JSON Structure to FlatBuffers schema.
• avrotize thrift2s - Convert Apache Thrift IDL to JSON Structure.
• avrotize s2thrift - Convert JSON Structure to Apache Thrift IDL.
• avrotize smithy2s - Convert Smithy 2.0 IDL data shapes to JSON Structure.
• avrotize s2smithy - Convert JSON Structure to Smithy 2.0 IDL data shapes.
• avrotize capnp2s - Convert Cap'n Proto schema to JSON Structure.
• avrotize s2capnp - Convert JSON Structure to Cap'n Proto schema.
• avrotize raml2s - Convert RAML 1.0 Data Types to JSON Structure.
• avrotize s2raml - Convert JSON Structure to RAML 1.0 Data Types.
• avrotize s2sql - Convert JSON Structure Schema to SQL table definition.
• avrotize s2k - Convert JSON Structure Schema to Kusto table definition.
• avrotize k2s - Convert Kusto table definitions to JSON Structure.
• avrotize s2tsml - Convert JSON Structure to Tabular Model Scripting Language (TMSL).
• avrotize s2pq - Convert JSON Structure to Parquet schema.
• avrotize s2ib - Convert JSON Structure to Iceberg schema.
• avrotize s2cassandra - Convert JSON Structure Schema to Cassandra schema.
• avrotize s2graphql - Convert JSON Structure schema to GraphQL schema.
• avrotize s2dp - Convert JSON Structure