GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • About
  • Blog
  • My Account
  • Home page

This view

  • Original page
  • New address

GeezerVison is showing extendsclass.com — SQL formatter - Format SQL statements online

ExtendsClass
Free Online Toolbox for developers

SQL formatter

 
It would be nice to disable adBlock, advertising is the only resource of this website :)
  • English
    • English
    • Français
    • Deutsch

Your SQL statement
Choice a database Keyword case Indentation Comments Compact mode



Formatted SQL statement





SQL formatter tool allows to format and beautify SQL statements online. It is also a SQL minifier, you can minify SQL.

It is a instant SQL formatter, it will automatically format your SQL query in order to generate SQL pretty string.

Short user guide: Copy and paste, drag and drop a SQL query or directly type in the "Your SQL statement" editor below.
Your SQL query is automatically formatted in the "Formatted SQL statement" editor.

You can see the user guide to help you to use this online SQL editor.

User guide

This tool is an easy to use SQL formatter, you can easily format SQL online.

  • How to beautify SQL? :

    There is only one step to format your SQL query, you must fill the "Your SQL statement" editor, and automatically the SQL pretty is available in the "Formatted SQL statement" editor.
    In order to fill the "Your SQL statement" editor, you can:

    • Copy and paste your SQL query.
    • Drag and drop your SQL file.
    • Directly type your SQL string in the editor.

    You have several formatting options available:

    • Choice a database:

      By default, it formats for Standard SQL, but you can also choice a database in order to correctly format the specificities.

    • Keyword case:

      You can choice the case of SQL keywords (as SELECT, FROM ...).

    • Indentation:

      You can choice the indentation: You can choose the character (between tabulation and space characters) to use and the number of times to repeat it.

    • Comments:

      You can choice to keep or remove comments.

    • Compact mode:

      You can format your SQL to one line.
      Note: Single line comments (start with --) will be convert to multi-line comments (start with /* and end with */).

  • How to minify SQL? :

    Just select the "Yes (Minify)" option of the "compact mode" parameter to minify your SQL.

  • How to retrieve the formatted SQL? :

    You can click on "Download" button in order to download the formatted SQL statement.
    You can also copy the result to the clipboard by clicking on the button "Copy to clipboard".

Note: SQL keywords appear in green all-uppercase.


SQL pretty tool

When you debug a large automatically generated query, it is often not easy to understand. SQL pretty tool makes the queries more understandable. This online SQL editor tool allows you easily to read SQL statement! This SQL beautifier is useful for SELECT, UPDATE, INSERT and DELETE statements.

Your SQL query is formatted even if your SQL statement is invalid. This tool does not validate the syntax of your queries. If you need to check the syntax of SQL queries, you can visit our SQL validator.

You can choose the indentation level, the case of the SQL keywords, the database, whether you keep or remove comments and the compact mode.

This tool also allows to minify SQL (compress).


About SQL

SQL (Structured Query Language) is a domain-specific language used in programming for managing relational database. It allows to handle structured data where there are relations between different entities of the data.

SQL is a standard of ANSI and ISO.


SQL Formatter library

SQL-Formatter.js is a JavaScript library for pretty-printing SQL queries. It can be used like any javascript library in a browser. It is MIT licensed.

I made some changes to add some settings. You can retrieve the updated version from the url: https://extendsclass.com/lib/sql-formatter.js Look for "// UPDATED" to find the changes.



You can report a bug or give feedback by adding a comment (below) or by clicking "Contact me" link (at the top right hand corner of the page).

Comments

Captcha

Enter the code (case insensitive) *

If you can not read the code, click here to generate a new code



Peter Lyden-2020-02-21 21:35
Hello - using snippet to copy code from a Oracle based system. I can copy the image of the code into one note for example but then
when I use the'copy text from picture' when right clicking on the image and paste into your sql formatter or another one it doesn't seem to
copy the text correctly as some of the special characters are being converted to something else ? Any ideas why?

Thanks - can be reached @[email protected]
Reply

Answer
Captcha

Enter the code (case insensitive) *

If you can not read the code, click here to generate a new code


Nandakumar Kamat-2022-03-14 13:18
Thanks for this. I have a multi line complicated query which looked impossible to understand. Was formatted beautifully and makes it really easy to read.
Reply

Answer
Captcha

Enter the code (case insensitive) *

If you can not read the code, click here to generate a new code




Conditions of Use
These tools might interest you:
convert:
PHP to PythonPython to javascriptKotlin to javaTypeScript to JavaScriptXPath to CSS selectorjson to python object onlineJSON to PHPXML to JSON Converter
Playgrounds:
MongoDB onlineSQL to MongoDB ConverterSQL onlineOracle onlineSQL Server onlineJavaScript validatorJSONPath TesterXPath TesterRegex TesterSQLite browserMySQL onlinePostgreSQL online
API tools:
Fake APIJSON storageMock RESTWeb service testingOnline REST clientOnline SOAP client
Random Data Generator:
Data generatorXML generatorCSV generatorJSON generator
Code checkers:
Python Code CheckerRuby Code CheckerPHP Code Checker
Code testers:
Lua testerSQL syntax checkerPython testerOnline Golang CompilerOnline Java CompilerPHP tester
Diff:
XML diffJSON diffJSON PatchCSV diffText diffPDF diff
Converters:
SQL to SQLParquet to CSV ConverterParquet viewerAvro viewerJSON to Excel ConverterCSV to Excelbase 64 encryptorYAML to JSONImage to base64
Formatters:
PHP FormatterCSV editorXML FormatterJSON FormatterReact FormatterPython FormatterJavaScript formatterHTML Formatter
Validators:
Query builderJSON Schema Validator And GeneratorXML ValidatorXSD Validator
Minifiers:
JavaScript minifyCSS formatter
Generators:
Robots.txt GeneratorFree Sitemap Generator
Encoders:
HTML encodeJWT decoderURL encode
Other:
CSV splitterMerge CSVTAR to ZIP OnlinePDF ViewerGUID GeneratorNotepad OnlineUUID GeneratorExcel viewerZip filesUnzip filesDeveloper resourcesheight and width compressor

Disclaimer: The tools are provided "as is", without warranty of any kind, either express or implied.
Any links to third-party website or software available on this website are provided "as is",
without warranty of any kind, either express or implied and are to be used at your own risk.


You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.