Skip to content

RosettaDB

Declarative Database Management - DDL Transpiler

Alt text

Overview

RosettaDB is an open-source, declarative data modeling and transpilation tool that simplifies database migrations, data quality assurance, and data exploration. With support for schema extraction, AI-driven querying, and automated code generation, RosettaDB equips data engineers and developers to manage complex data workflows across diverse platforms with ease.

Rosetta utilizes JDBC to extract schema metadata from a database and generates declarative DBML models that can be used for conversion to alternate database targets.

Key Features

  • Declarative Data Modeling: Define your database schema using DBML (Database Markup Language), and RosettaDB generates target database-specific DDL (Data Definition Language) automatically.
  • Transpilation: Seamlessly convert database objects from one database platform to another. RosettaDB eliminates the manual effort in migrating between heterogeneous database systems.
  • Data Quality and Validation: Implement and automate data quality checks using built-in test rules to ensure data accuracy, consistency, and reliability.
  • DBT Model Generation: Generate dbt models from your database schema effortlessly, empowering robust and scalable analytics workflows.
  • AI-Powered Data Exploration: Query and explore your data using natural language, leveraging AI to simplify complex SQL tasks and uncover insights.
  • Spark Code Generation: Automatically generate PySpark or Scala code for transferring data between source and target systems, streamlining data movement in big data pipelines.

Whether you’re modernizing your data architecture, migrating legacy systems, implementing data validation pipelines, or orchestrating data transfer in Spark environments, RosettaDB provides a comprehensive suite of tools tailored to your needs.

Get Involved

Join our growing community of developers and data engineers on RosettaDB Slack, and visit our GitHub repository to explore supported databases, translations, and use cases.

Supported Databases and Translations

The table below lists the currently supported databases and their respective translation capabilities.

BigQuery Snowflake MySQL Postgres Kinetica Google Cloud Spanner SQL Server DB2 Oracle
BigQuery / ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅
Snowflake ✅ / ✅ ✅ ✅ ✅ ✅ ✅ ✅
MySQL ✅ ✅ / ✅ ✅ ✅ ✅ ✅ ✅
Postgres ✅ ✅ ✅ / ✅ ✅ ✅ ✅ ✅
Kinetica ✅ ✅ ✅ ✅ / ✅ ✅ ✅ ✅
Google Cloud Spanner ✅ ✅ ✅ ✅ ✅ / ✅ ✅ ✅
SQL Server ✅ ✅ ✅ ✅ ✅ ✅ / ✅ ✅
DB2 ✅ ✅ ✅ ✅ ✅ ✅ ✅ / ✅
Oracle ✅ ✅ ✅ ✅ ✅ ✅ ✅ ✅ /