npmpackage.info

Gathering detailed insights and metrics for sql-formatter-plus

Other packages similar to sql-formatter-plus

@baurine/sql-formatter-plus

1.5.3

Formats whitespace in a SQL query to make it more readable

sql-formatter-plus-plus

1.4.0

Formats whitespace in a SQL query to make it more readable

sql-formatter-plus-jinja

1.3.8

Formats whitespace in a SQL query to make it more readable

Gathering detailed insights and metrics for sql-formatter-plus

sql-formatter-plus - 1.3.6 | npmpackage.info

sql-formatter-plus

A whitespace formatter for different query languages

1.3.6

MIT

JavaScript

11.84 kB

1,699,118 1.7

Installations

npm install sql-formatter-plus

Developer Guide

BETA

Typescript

No

Module System

CommonJS

Node Version

12.10.0

NPM Version

6.12.1 Score

Supply Chain

98.4

Quality

75.1

Maintenance

100

Vulnerability

99.6

License

Pull Requests

Open

3

Total

12

Closed

8

Merged

1

Issues

Open

0

Total

0

Closed

0

Releases

Unable to fetch releases

Languages

JavaScript

HTML

JavaScript (95.41%)

HTML (4.59%)

Developer

kufii

Download Statistics

Total Downloads

1,699,118

Last Day

8,099

Last Week

40,985

Last Month

169,967

Last Year

770,505

GitHub Statistics

MIT License

91 Stars

339 Commits

37 Forks

2 Watchers

6 Branches

1 Contributors

Updated on Mar 24, 2025

Bundle Size

44.06 kB

Minified

11.84 kB

Minified + Gzipped

Bundlephobia

Maintainers

View All 1 Contributors

Package Meta Information

Latest Version

1.3.6

Package Id

sql-formatter-plus@1.3.6

Unpacked Size

298.24 kB

Size

61.61 kB

File Count

NPM Version

6.12.1

Node Version

12.10.0

Total Downloads

Cumulative downloads

Total Downloads

1,699,118

Last Day

39.1%

8,099

Compared to previous day

Last Week

35.8%

40,985

Compared to previous week

Last Month

22.7%

169,967

Compared to previous month

Last Year

67.4%

770,505

Compared to previous year

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dependencies

@babel/polyfill lodash

Dev Dependencies

@babel/cli @babel/core @babel/preset-env babel-eslint babel-plugin-add-module-exports dedent-js eslint eslint-config-adpyke-es6 eslint-config-prettier jest prettier rimraf webpack webpack-cli

SQL Formatter Plus

A fork of SQL Formatter with some extra bug fixes and features.

Fixes:

Fixed formatting issue with unicode characters
Fixed comment formatting for non-unix line endings
Fixed null reference on input tokenization
Fixed indentation of multiple statements

New Features:

Convert keywords to uppercase with the uppercase config option
Configurable number of line breaks between queries with the linesBetweenQueries config option

SQL Formatter is a JavaScript library for pretty-printing SQL queries. It started as a port of a PHP Library, but has since considerably diverged. It supports Standard SQL, Couchbase N1QL, IBM DB2 and Oracle PL/SQL dialects.

Try the demo.

Install

Get the latest version from NPM:

1npm install sql-formatter

Usage

1import sqlFormatter from 'sql-formatter-plus';
2
3console.log(sqlFormatter.format('SELECT * FROM table1'));

This will output:

1SELECT
2  *
3FROM
4  table1

You can also pass in configuration options:

1sqlFormatter.format('SELECT *', {
2  language: 'n1ql', // Defaults to "sql"
3  indent: '    ', // Defaults to two spaces,
4  uppercase: true, // Defaults to false
5  linesBetweenQueries: 2 // Defaults to 1
6});

Currently just four SQL dialects are supported:

sql - Standard SQL
n1ql - Couchbase N1QL
db2 - IBM DB2
pl/sql - Oracle PL/SQL

Placeholders replacement

1// Named placeholders
2sqlFormatter.format("SELECT * FROM tbl WHERE foo = @foo", {
3  params: {foo: "'bar'"}
4}));
5
6// Indexed placeholders
7sqlFormatter.format("SELECT * FROM tbl WHERE foo = ?", {
8  params: ["'bar'"]
9}));

Both result in:

1SELECT
2  *
3FROM
4  tbl
5WHERE
6  foo = 'bar'

Usage without NPM

If you don't use a module bundler, clone the repository, run npm install and grab a file from /dist directory to use inside a <script> tag. This makes SQL Formatter available as a global variable window.sqlFormatter.

Contributing

1# run linter and tests
2npm run check

...and you're ready to poke us with a pull request.

License

MIT

No vulnerabilities found.

10

Binary-Artifacts

Determines if the project has generated executable (binary) artifacts in the source repository.

10

License

Determines if the project has defined a license.

0

Code-Review

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

0

SAST

Determines if the project uses static code analysis.

0

Maintained

Determines if the project is "actively maintained".

0

CII-Best-Practices

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

0

Security-Policy

Determines if the project has published a security policy.

0

Fuzzing

Determines if the project uses fuzzing.

0

Branch-Protection

Determines if the default and release branches are protected with GitHub's branch protection settings.

0

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

Reason

63 existing vulnerabilities detected

Details

Warn: Project is vulnerable to: GHSA-968p-4wvh-cqc8
Warn: Project is vulnerable to: GHSA-67hx-6x53-jw92
Warn: Project is vulnerable to: GHSA-6chw-6frg-f759
Warn: Project is vulnerable to: GHSA-v88g-cgmw-v5xw
Warn: Project is vulnerable to: GHSA-93q8-gq69-wqmw
Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg
Warn: Project is vulnerable to: GHSA-x9w5-v3q2-3rhw
Warn: Project is vulnerable to: GHSA-w8qv-6jwh-64r5
Warn: Project is vulnerable to: GHSA-3xgq-45jj-v275
Warn: Project is vulnerable to: GHSA-gxpj-cx7g-858c
Warn: Project is vulnerable to: GHSA-w573-4hg7-7wgq
Warn: Project is vulnerable to: GHSA-vh7m-p724-62c2
Warn: Project is vulnerable to: GHSA-r9p9-mrjm-926w
Warn: Project is vulnerable to: GHSA-434g-2637-qmqr
Warn: Project is vulnerable to: GHSA-49q7-c7j4-3p7m
Warn: Project is vulnerable to: GHSA-977x-g7h5-7qgw
Warn: Project is vulnerable to: GHSA-f7q4-pwc6-w24p
Warn: Project is vulnerable to: GHSA-fc9h-whq2-v747
Warn: Project is vulnerable to: GHSA-vjh7-7g9h-fjfh
Warn: Project is vulnerable to: GHSA-8r6j-v8pm-fqw3
Warn: Project is vulnerable to: MAL-2023-462
Warn: Project is vulnerable to: GHSA-ww39-953v-wcq6
Warn: Project is vulnerable to: GHSA-3cqr-58rm-57f8
Warn: Project is vulnerable to: GHSA-g9r4-xpmj-mj65
Warn: Project is vulnerable to: GHSA-q2c6-c6pm-g3gh
Warn: Project is vulnerable to: GHSA-765h-qjxv-5f44
Warn: Project is vulnerable to: GHSA-f2jv-r9rf-7988
Warn: Project is vulnerable to: GHSA-43f8-2h32-f4cj
Warn: Project is vulnerable to: GHSA-qqgx-2p2h-9c37
Warn: Project is vulnerable to: GHSA-896r-f27r-55mw
Warn: Project is vulnerable to: GHSA-9c47-m6qq-7p4h
Warn: Project is vulnerable to: GHSA-6c8f-qphg-qjgp
Warn: Project is vulnerable to: GHSA-76p3-8jx3-jpfq
Warn: Project is vulnerable to: GHSA-3rfm-jhwj-7488
Warn: Project is vulnerable to: GHSA-hhq3-ff78-jv3g
Warn: Project is vulnerable to: GHSA-p6mc-m468-83gw
Warn: Project is vulnerable to: GHSA-29mw-wpgm-hmr9
Warn: Project is vulnerable to: GHSA-35jh-r3h4-6jhm
Warn: Project is vulnerable to: GHSA-952p-6rrq-rcjv
Warn: Project is vulnerable to: GHSA-f8q6-p94x-37v3
Warn: Project is vulnerable to: GHSA-vh95-rmgr-6w4m
Warn: Project is vulnerable to: GHSA-xvch-5gv4-984h
Warn: Project is vulnerable to: GHSA-5fw9-fq32-wv5p
Warn: Project is vulnerable to: GHSA-hj48-42vr-x3v9
Warn: Project is vulnerable to: GHSA-hrpp-h998-j3pp
Warn: Project is vulnerable to: GHSA-p8p7-x288-28g6
Warn: Project is vulnerable to: GHSA-c2qf-rxjj-qqgw
Warn: Project is vulnerable to: GHSA-h9rv-jmmf-4pgx
Warn: Project is vulnerable to: GHSA-hxcc-f52p-wc94
Warn: Project is vulnerable to: GHSA-vx3p-948g-6vhq
Warn: Project is vulnerable to: GHSA-3jfq-g458-7qm9
Warn: Project is vulnerable to: GHSA-r628-mhmh-qjhw
Warn: Project is vulnerable to: GHSA-9r2w-394v-53qc
Warn: Project is vulnerable to: GHSA-5955-9wpr-37jh
Warn: Project is vulnerable to: GHSA-qq89-hq3f-393p
Warn: Project is vulnerable to: GHSA-f5x3-32g6-xq36
Warn: Project is vulnerable to: GHSA-4wf5-vphf-c2xc
Warn: Project is vulnerable to: GHSA-jgrx-mgxx-jf9v
Warn: Project is vulnerable to: GHSA-72xf-g2v4-qvf3
Warn: Project is vulnerable to: GHSA-6fc8-4gx4-v693
Warn: Project is vulnerable to: GHSA-3h5v-q93c-6h6q
Warn: Project is vulnerable to: GHSA-c4w7-xm78-47vh
Warn: Project is vulnerable to: GHSA-p9pc-299p-vxgp

Score

1.7

/10

Last Scanned on 2025-04-28

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.

Learn More