SQLCheck: SQL anti-pattern detection

This extension passes your SQL queries through the SQLCheck API, providing feedback on potential SQL anti-patterns in real time while you code.

More info on the SQLCheck API at https://github.com/georgia-tech-db/sqlcheck-feedback.

Features

Interactively checks your SQL code against common antipatterns. For issues detected, more information is provided describing the potential impact and general advice on adjusting the code to correct.

Requirements

Because this extension leverages hosted API endpoints, it requires network connectivity.

Extension Settings

This extension contributes the following settings:

• sqlcheck.delay: Delay in seconds between each code check
• sqlcheck.enable: Enable/disable this extension

Release Notes

0.2.0 (preview)

• Adds info message when query cannot be parsed by SQLCheck
• Consolidates endpoints

0.1.0 (preview)

• Preview release
• Displays antipattern information in "Problems"
• Option for "More Info" opens webview panel with description
• Obfuscates strings in query (" and ') before sending to API