JMAN SQL Formatter

A lightweight SQL formatter extension for Visual Studio Code built for teams with custom SQL formatting conventions.

JMAN SQL Formatter helps standardize SQL files across projects by applying consistent formatting rules while preserving readability and developer workflow.

Features

✨ SQL Document Formatting

Format SQL files directly inside VS Code using:

Shift + Alt + F
Right Click → Format Document
Command Palette → JMAN SQL Formatter: Format Document

📁 Format Entire Workspace

Format all SQL files in your workspace at once:

Command Palette → JMAN SQL Formatter: Format Directory
A confirmation dialog will appear to prevent accidental formatting
Progress indicator shows file-by-file formatting status
Failed files are reported without interrupting the batch process

🧠 Smart SQL Formatting

Supports:

SQL keyword formatting
Consistent indentation
Line breaks
Readability improvements
Company-specific formatting rules

Example:

Before

select id,name from users where active=1;

After

SELECT

    id
    , name

FROM users

WHERE
    active = 1
;

🚨 SQL Error Highlighting

When formatting fails due to invalid SQL syntax:

The exact error line is highlighted
Errors appear in the Problems panel

🛠 dbt & Jinja Friendly

Built with templated SQL workflows in mind.

Example:

Before

SELECT {{ dbt_utils.generate_surrogate_key(['id']) }}, name, age FROM {{ ref('users') }}

After

SELECT

    {{ dbt_utils.generate_surrogate_key(['id']) }}
    , name
    , age

FROM {{ ref('users') }}

Requirements

No additional setup required.

Supported environments:

Visual Studio Code ^1.100.0
SQL files
dbt SQL files (partial support)

Extension Settings

This extension contributes the following settings: