I’ve published a new GitHub Action called SQLCheck Action (View on Marketplace). The action automatically identifies anti-patterns in SQL queries using sqlcheck when PR is requested and comment on the PR if risks are found in the queries.

Usage

Supports pull_request event type.

Inputs

Parameter Required Default Value Description
post-comment false true Post comment to PR if it’s true
token true ”” GitHub Token in order to add comment to PR
risk-level false 3 Set of SQL anti-patterns to check: 1,2, or 3
- 1 (all anti-patterns, default)
- 2 (only medium and high risk anti-patterns)
- 3 (only high risk anti-patterns)
verbose false false Add verbose warnings to SQLCheck analysis result
postfixes false “sql” List of file postfix to match ( separator: comma )

Sample Workflow

.github/workflows/test.yml

name: sqlcheck workflow
on: pull_request

jobs:
  sqlcheck:
    name: sqlcheck job 
    runs-on: ubuntu-latest
    steps:
    - uses: actions/checkout@master
    - uses: yokawasa/action-sqlcheck@v1.2.1
      with:
        post-comment: true
        risk-level: 3
        verbose: false
        token: ${{ secrets.GITHUB_TOKEN }}

Enjoy the action!