Codewerk
sql antipatterns
Tokenizes every statement with an own dialect-aware SQL lexer and parses it with node-sql-parser where possible. Rules follow sqlcheck (Apache-2.0, anti-patterns 3001 SELECT *, 3006 ORDER BY RAND, 3007 pattern matching, 3011 implicit columns, 3014 OR, 3015 UNION, 3016 DISTINCT & JOIN), the PostgreSQL 18 manual (= NULL comparison, expression indexes, OFFSET cost, cross joins, operator type resolution), the PostgreSQL wiki "Don't Do This" (NOT IN), MySQL 8.4 safe-updates and type conversion.
POST https://code.halowerk.com/v1/sql-antipatternsInputs
| Field | Type | Required | Description |
|---|---|---|---|
| sql | string | No | One or more statements separated by semicolons. |
| queries | array | No | Statements in execution order, e.g. from a query log. |
| dialect | string | No | |
| schema_ddl | string | No | Optional CREATE TABLE statements for type-aware checks. |
| n_plus_one_threshold | integer | No | |
| large_offset | integer | No |
Show full input schema
{
"type": "object",
"additionalProperties": false,
"properties": {
"sql": {
"type": "string",
"maxLength": 1000000,
"description": "One or more statements separated by semicolons."
},
"queries": {
"type": "array",
"maxItems": 5000,
"items": {
"type": "string",
"maxLength": 20000
},
"description": "Statements in execution order, e.g. from a query log."
},
"dialect": {
"type": "string",
"enum": [
"postgresql",
"mysql"
],
"default": "postgresql"
},
"schema_ddl": {
"type": "string",
"maxLength": 1000000,
"description": "Optional CREATE TABLE statements for type-aware checks."
},
"n_plus_one_threshold": {
"type": "integer",
"minimum": 2,
"maximum": 1000,
"default": 5
},
"large_offset": {
"type": "integer",
"minimum": 100,
"maximum": 1000000000,
"default": 10000
}
}
}Published input example
{
"sql": "SELECT * FROM users WHERE email = NULL;\nDELETE FROM sessions;"
}Result & documentation
Machine-readable documentation of this hub
Source of this page: the published HALOWERK catalog. Updated: 2026-11-17 UTC.
More endpoints in this hub
- Codewerk0.003 USDC
action sha pin
POSThttps://code.halowerk.com/v1/action-sha-pinFinds every "uses: owner/repo[/path]@ref" in a GitHub Actions workflow, resolves tags (including annotated tags) and branches to the commit SHA with git ls-remote against github.com, and rewrites the line to "uses: owner/repo[/path]@<sha> #
- Codewerk0.003 USDC
actionlint
POSThttps://code.halowerk.com/v1/actionlintRuns the official statically linked actionlint 1.7.12 release binary (MIT, SHA-256 checked against the published checksums) in an isolated child process without network, with the bundled ShellCheck 0.11.0 for run: scripts (pyflakes is not a
- Codewerk0.004 USDC
api changelog
POSThttps://code.halowerk.com/v1/api-changelogCompares operations, parameters, request bodies, response codes and media types, component schemas (one property level), servers and security schemes of two documents (Swagger 2.0 is converted with swagger2openapi first; 3.0 and 3.1 are rea