Avrotize & Structurize

mcp-name: io.github.clemensv/avrotize

📚 Documentation & Examples | 🎨 Conversion 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: