Skip to tool
All tools
FeuTex · free tools runs in-browser no bloat built by LiMiT

Online Converter: SQL to MySQL

Paste SQL from another dialect (PostgreSQL, SQL Server, Oracle, SQLite) and convert it into MySQL/MariaDB-friendly SQL. This tool focuses on the common breakpoints: identifier quoting, data types, paging syntax, and a few frequently-used functions.

Category: Data · URL: /tools/online-converter-sql-to-mysql.html

Tip: this is a pragmatic converter, not a full parser. Always review the result, especially for procedures, triggers, and vendor-specific syntax.

Related tools:
Privacy: runs locally in your browser. No uploads, no tracking scripts.

How to use

Convert your SQL in seconds:

  1. Paste your source SQL into the input box.
  2. Choose the conversion options (quoting, types, paging, functions).
  3. Click Convert to MySQL.
  4. Copy the output and run it in MySQL/MariaDB (review before production).
Keywords this page targets (natural cluster): online converter sql to mysql, sql to mysql converter, convert postgres sql to mysql, convert sql server to mysql, convert oracle sql to mysql, sql dialect converter to mysql, convert create table to mysql, convert identity to auto_increment, convert serial to auto_increment mysql, convert top to limit mysql, offset fetch to limit offset mysql, convert fetch first rows only to limit, replace brackets with backticks mysql, double quotes to backticks mysql, nvarchar to varchar mysql, number to decimal mysql, isnull to ifnull mysql, getdate to now mysql, len to char_length mysql, boolean to tinyint mysql
Secondary intents covered: Convert CREATE TABLE scripts so they run in MySQL, Rewrite SQL Server TOP / OFFSET-FETCH paging into MySQL LIMIT/OFFSET, Fix identifier quoting from [] or "" into backticks, Map common data types (NVARCHAR, NUMBER, SERIAL, BOOLEAN) to MySQL equivalents, Translate common functions (ISNULL, GETDATE, LEN, NVL) to MySQL functions, Strip schema prefixes like dbo. or public. for portability, Clean batch separators like GO from SQL Server scripts, Quickly copy the converted output for use in migrations

FAQ

What SQL dialects does this handle?

It targets common patterns from PostgreSQL, SQL Server, and Oracle, then rewrites them into MySQL/MariaDB-friendly SQL.

Does it convert stored procedures and triggers?

Not reliably—procedural SQL varies a lot. Use this for statements like CREATE TABLE and SELECT, then manually adjust advanced objects.

Will it change my string literals?

No—conversions avoid text inside single quotes, so string values stay intact in most cases.

What does it do with SQL Server TOP and OFFSET/FETCH?

TOP becomes LIMIT, and OFFSET/FETCH becomes LIMIT … OFFSET …, which is the MySQL paging style.

How are SERIAL, IDENTITY, and AUTO_INCREMENT handled?

SERIAL/BIGSERIAL are converted to INT/BIGINT AUTO_INCREMENT, and IDENTITY(1,1) is rewritten to AUTO_INCREMENT.

Does it support MySQL and MariaDB?

Yes—the output is intended to be compatible with both, but you should still test against your exact server version.

Is my SQL uploaded to a server?

No network calls are made by the tool script; conversion runs in your browser.