SQL Tools

Format SQL queries; visually build SELECT statements; inject parameters; convert between dialects; visualize schema; export INSERT statements to JSON, CSV, XML, YAML, or HTML; generate C# migration classes for EF Core, FluentMigrator, or DbUp; lint for anti-patterns; get index suggestions; look up dialect syntax; generate ORM models; estimate query cost; and simulate transaction isolation levels.

Convert dialect:

Press Ctrl+Enter to format

SQL Tools

Common uses

Format a multi-join SELECT query
Build a SELECT statement visually
Convert MySQL syntax to PostgreSQL
Export INSERT statements to JSON
Generate a C# EF Core migration from SQL
Lint a query for anti-patterns
Get index suggestions for slow queries
Generate a Prisma model from a CREATE TABLE
Simulate a dirty read under Read Uncommitted

Also searched as

sql formatter online
sql beautifier
convert mysql to postgresql syntax
visual sql query builder online
fill in sql query parameters
sql insert statements to json
generate ef core migration from sql
sql anti pattern linter
index suggestions for slow sql query
sql create table to prisma model
transaction isolation levels dirty read simulator
format t-sql query

Frequently asked questions

How do I format an SQL query?

Paste your query and it is reformatted with consistent keyword casing and indentation. You can also convert between database dialects.

Can it help catch performance problems?

Yes — the linter flags common anti-patterns and the index advisor suggests indexes for slow queries.

How do I format a messy SQL query?

Paste the query into the Format tab of SQL Tools and it is reformatted with consistent indentation and keyword casing. You can also minify it or pick a SQL dialect.

Can I convert SQL from MySQL to PostgreSQL?

SQL Tools includes a dialect converter that translates syntax between SQL dialects. Check the output before running it, since dialects differ in subtle ways.

How do I replace parameters in a SQL query with real values?

Use the Param Injector tab. Paste a parameterized query and the values, and it produces a query with the parameters filled in, handy for debugging logged queries.

Can I generate ORM models or C# migrations from a CREATE TABLE statement?

Yes. The ORM Generator tab produces models for tools such as Prisma, TypeORM, SQLAlchemy, Django, Sequelize and Eloquent, and the C# Migration tab produces EF Core, FluentMigrator or DbUp classes.

What does the SQL anti-pattern linter check?

The Anti-pattern Linter tab flags common query problems such as SELECT * usage. A separate Index Advisor tab suggests indexes for a query.

Is my data uploaded to a server?

No. This tool runs entirely in your browser — your input is processed locally on your device and is never uploaded or stored on a server.