Convert PostgreSQL to MySQL online

Paste PostgreSQL, get MySQL. Nothing you paste is stored.

Paste PostgreSQL SQL (a CREATE TABLE or a query) and get the MySQL equivalent: BIGSERIAL and identity columns become AUTO_INCREMENT, NUMERIC becomes DECIMAL, TIMESTAMPTZ maps to TIMESTAMP, and function spellings like now() are translated.

Converted on the server, discarded after the response.

Try it on your own schema

Example

PostgreSQL in:

CREATE TABLE product (
    id BIGSERIAL PRIMARY KEY,
    sku VARCHAR(40) UNIQUE NOT NULL,
    name VARCHAR(200) NOT NULL,
    price NUMERIC(12, 2) NOT NULL,
    in_stock BOOLEAN NOT NULL DEFAULT true,
    created_at TIMESTAMP NOT NULL DEFAULT now()
);

Generated:

mysql.sql

CREATE TABLE product (
  id BIGINT PRIMARY KEY AUTO_INCREMENT,
  sku VARCHAR(40) UNIQUE NOT NULL,
  name VARCHAR(200) NOT NULL,
  price DECIMAL(12, 2) NOT NULL,
  in_stock BOOLEAN NOT NULL DEFAULT TRUE,
  created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP()
);

Related

• MySQL to PostgreSQL
• PostgreSQL to Flyway
• SQL formatter