Skip to main content

Database Support

This page provides an overview of which databases are supported across DBML's different capabilities.

Support Matrix​

DatabaseImport (SQL to DBML)Export (DBML to SQL)Connector
PostgreSQL✓✓✓
MySQL✓✓✓
MSSQL (SQL Server)✓✓✓
Oracle✓✓✓
Snowflake✓—✓
BigQuery——✓

Legend:

  • ✓ = Supported
  • — = Not supported

Capabilities​

Import (SQL to DBML)​

Convert SQL DDL scripts to DBML format using @dbml/core.

const { importer } = require('@dbml/core');
const dbml = importer.import(sqlScript, 'postgres');

Export (DBML to SQL)​

Generate SQL DDL scripts from DBML using @dbml/core.

const { exporter } = require('@dbml/core');
const sql = exporter.export(dbmlContent, 'postgres');

Connector​

Connect directly to a live database and extract its schema using @dbml/connector.

const { connector } = require('@dbml/connector');
const schemaJson = await connector.fetchSchemaJson(connectionString, 'postgres');