Skip to content
| Marketplace
Sign in
Visual Studio Code>Other>sqlcl-codescanNew to Visual Studio Code? Get it now.
sqlcl-codescan

sqlcl-codescan

Niko Sperat

|
224 installs
| (0) | Free
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

sqlcl-codescan README

This extension adds the SQLcl codescan ability to VS Code

Features

Allows the usage of SQLcl codescan in VS code for any given sql file

Preview

Requirements

A working installation of SQLcl above version 23

Extension Settings

This extension contributes the following settings:

  • sqlclCodescan.checkOnSave: Check files on save
  • sqlclCodescan.checkOnOpen: Check files on open
  • sqlclCodescan.sqlClPath: Path to sqlcl executable
  • sqlclCodescan.ignorePaths: List of paths to ignore similar to .gitignore
  • sqlclCodescan.enableFormatting: Enable sql formatting
  • sqlclCodescan.formattingRulePath: Path to advanced formatting rules xml
  • sqlclCodescan.tvdFormatterPath: Path to format.js to load tvdformatter script
  • sqlclCodescan.tvdArboriPath: Path to tvd custom formatting arbori file
  • sqlclCodescan.websiteInfo: URL where details about the rules can be found

Known Issues

Release Notes

1.0.0

  • Initial release of sqlcl-codescan

1.1.0

  • dded severity level to diagnostics
  • Added code formatting capability

1.1.1

  • Added support for UTF-8 BOM encoded files
  • Showing results in vscode output channel

1.1.2

  • Refactored stdin/out handling for sqlcl
  • Improved output channel info
  • Improved error handling for failing scans

1.1.3

  • Fixed handling when no error occured

1.1.4

  • Fixed an issue caused by absolute paths for formatting rules or arbori file
  • Fixed issues caused by whitespace in paths for formatting rules or arbori file

1.1.5

  • Added SQL Developer Extension file support
  • Improved warning messages for configurations
  • Added support to format selected text
  • Experimental parsing error output for formatting
  • Added option to interactivly run codescan while typing

1.1.6

  • Improvements on auto scan on type
  • Added support for format on save

1.1.7

  • Fixed parsing when using sqlcl 24.1+
  • Relative paths for formatting config files are properly parsed
  • Added filetype matching for oracle-sql file types
  • Fixed bug causing error when out of workspace files are linted

1.1.8

  • Added formatting for oracle-sql file types

1.1.9

  • Closing diagnostics when files get closed
  • Contact us
  • Jobs
  • Privacy
  • Manage cookies
  • Terms of use
  • Trademarks
© 2025 Microsoft