Sql Formatter

Format sql files using the sql-formatter npm package

Install

• Open VS Code and press F1 or Ctrl + Shift + P to open command palette, select Install Extension and type lea21st.vscode-sql-formatter. Or launch VS Code Quick Open (Ctrl + P), paste the following command, and press enter.

  ext install lea21st.vscode-sql-formatter

Options

   "sql-formatter.uppercase": false,
   "[sql]": {
       "editor.defaultFormatter": "lea21st.vscode-sql-formatter"
   }

SQL formatter supports the following dialects:

• sql - [Standard SQL][]
• mariadb - [MariaDB][]
• mysql - [MySQL][]
• postgresql - [PostgreSQL][]
• db2 - [IBM DB2][]
• plsql - [Oracle PL/SQL][]
• n1ql - [Couchbase N1QL][]
• redshift - [Amazon Redshift][]
• spark - [Spark][]
• tsql - [SQL Server Transact-SQL][tsql]

Configuration

sql-formatter.dialect: Defaults to "sql" (see the above list of supported dialects)

sql-formatter.uppercase: Defaults to false (not safe to use when SQL dialect has case-sensitive identifiers)

sql-formatter.linesBetweenQueries: Number of linebreaks between queries. Defaults to 2.

打包方法

• 安装依赖 npm install

• 打包 npm i vsce -g

• 打包成 vsix 文件 vsce package

• 当前目录会生成.vxix文件，打包成功

  或者直接下载.vsix文件，在 extensions 中安装

• 生成好的 vsix 文件不能直接拖入安装，只能从扩展的右上角选择Install from VSIX安装