MySQL to PostgreSQL SQL Converter

Translate MySQL queries to PostgreSQL syntax with inline annotations. Free, 30 per hour.

FromTo

Hourly Limit: 0/30

Source SQL

SELECT `user_id`, DATE_FORMAT(created_at, '%Y-%m') AS month
FROM orders WHERE status = 'paid' LIMIT 10 OFFSET 20;

Translated Result

Key Differences

•MySQL features commonly rewritten: backtick identifiers, LIMIT offset comma syntax.
•PostgreSQL equivalents: JSONB operators, DISTINCT ON.
•Identifier quoting style differs — backticks → double quotes.
•Date/time function names and casting semantics vary between MySQL and PostgreSQL.