How to Use SQL Formatter
Step 1 : Paste or type your SQL query in the input box.
Step 2 : Select the SQL dialect from the dropdown. The SQL query will be formatted according to the selected dialect.
Step 3 : Click on the Format button to format the SQL query. You will see the formatted SQL query in the output box. If formatter unable to format the query, then error message will be shown at TOP.
FAQs
What is SQL Formatter Tool ?
SQL Formatter is a free online simple tool to beautify, format, prettify queries. It helps to make your SQL query more readable and understandable.
How many types of SQL supports?
This tool supports multiple SQL dialects,
Format Standard SQL or ANSI SQL.
Format MySQL, a free & open-source relational database.
Format PostgreSQL, a free & open-source relational database.
Format SQLite, a lightweight database engine.
Format BigQuery, a fully-managed, serverless data warehouse by Google.
Format Redshift, a fully-managed data warehouse service by Amazon.
Format Snowflake, a cloud-based data warehousing solution.
Format Oracle PL/SQL, Oracle's procedural extension for SQL.
Format SQL Server T-SQL, Microsoft's proprietary extension for SQL.
Format Apache Hive, a data warehouse software for querying and managing large datasets residing in distributed storage.
Format Spark SQL, the module for structured data processing in Apache Spark.
Format MariaDB, a community-developed fork of MySQL.
Format Trino, a distributed SQL query engine for big data.
Format Couchbase N1QL, a query language for Couchbase NoSQL database.
Format SingleStoreDB, a distributed, highly scalable SQL database.
Format TiDB, a distributed SQL database compatible with MySQL.
Format IBM DB2, IBM's database server.
Format IBM DB2i, IBM's integrated database management system for iSeries servers.