sqlcheck icon indicating copy to clipboard operation
sqlcheck copied to clipboard

Automatically identify anti-patterns in SQL queries

Results 16 sqlcheck issues
Sort by recently updated
recently updated
newest added

When this tool is run on a large file it prints all results on stdout, instead results in a json like file will be nice Also reporting line no. on...

Release artifacts to be provided by the GitHub actions pipeline - I wasn't able to complete the Windows support in the pipeline at this time.

help wanted

I'm having trouble installing sqlcheck on my linux machine with the following error: ``` yum --nogpgcheck localinstall sqlcheck-x86_64.rpm Loaded plugins: langpacks Examining sqlcheck-x86_64.rpm: sqlcheck-1.2-1.x86_64 Marking sqlcheck-x86_64.rpm to be installed Resolving...

help wanted

SQLCheck detecting Index Attribute Order on the following Query. "CREATE INDEX pin_stlmnt_index on d_trans_facts (pin_stlmnt_dt_ser_no) online;" The Query has only one attribute and this rule is not applicable for this...

I see that the name for the repository has changed to `sqlcheck-old`. Is this still going to be a maintained project or is it considered feature frozen/deprecated?

It would be a great feature to implement some kind of programmatic API to check an SQL file (either from path or from the contents given as argument) so that...

Hello! I'm trying to download the windows EXEC. I get a 404 error: joseplluis@MacBook-MacBook-Pro-de-Josep ~ % wget https://github.com/jarulraj/sqlcheck/releases/download/v1.3/sqlcheck.exe --2022-09-15 15:38:04-- https://github.com/jarulraj/sqlcheck/releases/download/v1.3/sqlcheck.exe Résolution de github.com (github.com)… 140.82.121.4 Connexion à github.com (github.com)|140.82.121.4|:443…...

- add github action build support for PR builds - update action deps to use nodejs 20 runtime - only upload artifacts per `workflow_dispatch` builds - remove travis config cc...

I think the gitignore is from some template, but need to update it to track down the `CMakeLists.txt` changes.

When doing a join with a using such as: ```sql SELECT t1.col1, t2.col2 FROM t1 JOIN t2 USING (col1); ``` this is triggering: ``` (HIGH RISK) (QUERY ANTI-PATTERN) JOIN Without...