Supported Databases

Complete list of database systems supported by the Synthesized platform with version compatibility and feature notes.

Fully Supported Databases

The platform provides first-class support for these databases:

PostgreSQL

  • Versions: 9.6, 10, 11, 12, 13, 14, 15, 16

  • Features: Full support for all platform features

  • Special Types: Arrays, JSON/JSONB, UUID, geometric types

  • Performance: Excellent (native JDBC driver)

JDBC URL:

jdbc:postgresql://localhost:5432/database_name

MySQL / MariaDB

  • MySQL Versions: 5.7, 8.0, 8.1, 8.2

  • MariaDB Versions: 10.3, 10.4, 10.5, 10.6, 10.11

  • Features: Full support

  • Special Types: JSON, spatial types

  • Performance: Excellent

JDBC URL:

jdbc:mysql://localhost:3306/database_name

Oracle

  • Versions: 11g, 12c, 18c, 19c, 21c, 23c

  • Features: Full support including sequences, triggers

  • Special Types: XMLType, LOBs

  • Licensing: Requires Oracle JDBC driver

  • Performance: Very good

JDBC URL:

jdbc:oracle:thin:@localhost:1521:orcl

Microsoft SQL Server

  • Versions: 2012, 2014, 2016, 2017, 2019, 2022

  • Features: Full support

  • Special Types: XML, spatial types

  • Performance: Very good

JDBC URL:

jdbc:sqlserver://localhost:1433;databaseName=mydb

IBM DB2

  • Versions: 10.5, 11.1, 11.5

  • Features: Full support

  • Platforms: Linux, Unix, Windows, z/OS

  • Performance: Good

JDBC URL:

jdbc:db2://localhost:50000/database_name

Cloud Databases

Amazon RDS

Support for all RDS database engines:

  • RDS PostgreSQL: Fully supported

  • RDS MySQL: Fully supported

  • RDS MariaDB: Fully supported

  • RDS Oracle: Fully supported

  • RDS SQL Server: Fully supported

Connection: Use RDS endpoint as hostname

Amazon Aurora

  • Aurora PostgreSQL: Fully supported (PostgreSQL-compatible)

  • Aurora MySQL: Fully supported (MySQL-compatible)

  • Serverless: Supported (v1 and v2)

Google Cloud SQL

  • Cloud SQL PostgreSQL: Fully supported

  • Cloud SQL MySQL: Fully supported

  • Cloud SQL SQL Server: Fully supported

Azure SQL Database

  • Azure SQL Database: Fully supported

  • Azure SQL Managed Instance: Fully supported

  • Azure Database for PostgreSQL: Fully supported

  • Azure Database for MySQL: Fully supported

Snowflake

  • Versions: All current versions

  • Features: Most features supported

  • Limitations: Some transformers may have limited support

  • Performance: Good for large datasets

JDBC URL:

jdbc:snowflake://account.snowflakecomputing.com/?db=database&schema=schema

Amazon Redshift

  • Versions: All current versions

  • Features: Most features supported

  • Performance: Optimized for data warehouses

JDBC URL:

jdbc:redshift://cluster.region.redshift.amazonaws.com:5439/database

Database-Specific Features

Sequences (PostgreSQL, Oracle)

Automatically handled:

- columns: ["id"]
  type: Sequence
  params:
    start: 1

Auto-Increment (MySQL, SQL Server)

The platform detects and handles IDENTITY columns automatically.

Triggers

Can be disabled during transformation:

default_config:
  disable_triggers: true

See: Triggers

Partitioned Tables

Supported in PostgreSQL, Oracle, SQL Server: * Range partitioning * List partitioning * Hash partitioning

See: PostgreSQL Partitions

JDBC Drivers

The platform includes JDBC drivers for:

  • PostgreSQL

  • MySQL / MariaDB

  • SQL Server

Oracle DB2, and other databases require you to provide the JDBC driver.

See: JDBC URL Examples

Connection Requirements

Permissions

Minimum permissions needed:

Source Database (Read-Only):

  • SELECT on all tables

  • SELECT on information_schema/system catalogs

  • CONNECT privilege

Destination Database (Write):

  • SELECT, INSERT, UPDATE, DELETE on tables

  • CREATE TABLE (if schema creation enabled)

  • DROP/CREATE INDEX (if index management enabled)

See: Database Permissions

Network Access

  • Source and destination must be reachable from the platform

  • Firewall rules must allow JDBC connections

  • SSL/TLS supported for encrypted connections

See: SSL Connection Issues

Compatibility Notes

Data Type Mappings

The platform automatically maps types between databases:

  • VARCHAR(255) (MySQL) → VARCHAR(255) (PostgreSQL)

  • DATETIME (MySQL) → TIMESTAMP (PostgreSQL)

  • NUMBER (Oracle) → NUMERIC (PostgreSQL)

See: Type Mappings

Character Sets

The platform supports Unicode (UTF-8) for all databases.

Time Zones

Timestamps handled consistently across databases.

Testing Compatibility

Before large transformations:

  1. Test connectivity:

tdk diagnostic --check-connection

  1. Validate schema:

tdk validate-config --config-file workflow.yaml

  1. Run on small dataset:

- table_name_pattern: "public.customer"
  num_rows: 100  # Test with 100 rows first

Get Help

For database-specific issues: