1. Java SQL Formatting Library

Gradle CI Maven Codacy Badge Coverage Status License issues - JSQLFormatter PRs Welcome

Platform independent SQL Formatter, Beautifier and Pretty Printer by Manticore Projects.

Latest stable release: JSQLFormatter-5.0.jar

Development version: JSQLFormatter-5.1-SNAPSHOT.jar

GitHub Repository

Features

  • based on JSQLParser

  • supports complex SELECT, INSERT INTO, MERGE, UPDATE, DELETE, CREATE, ALTER statements

  • Syntax highlighting (ANSI, HTML, RTF)

  • Command Line Options (CLI) and SQL Inline Formatting Options

    • Indent Width

    • Comma Before or After

    • Upper/Lower/Camel-Case Spelling of Keywords, Functions and Object Names

  • Import from Java String or StringBuilder Code preserving variables

  • Export to Java String, StringBuilder or MessageFormat handling variables

Platform

  • Java Library (JAR)

  • Native Static Binary or Dynamic Library for Windows, Linux or MacOS

  • Netbeans Plugin (Other platforms such as Eclipse, JEdit, Squirrel SQL, DBeaver coming soon)