Codewerk
pg migration safety
Splits a PostgreSQL migration into statements with its own tokenizer (dollar quotes, nested comments, BEGIN ATOMIC bodies) and checks every statement against the squawk rule set (docs at commit 0795f5e, 2026-10-31), for example adding-field-with-default, adding-not-nullable-field, constraint-missing-not-valid, changing-column-type, require-concurrent-index-creation, ban-drop-*, require-lock-timeout and transaction-nesting.
POST https://code.halowerk.com/v1/pg-migration-safetyInputs
| Field | Type | Required | Description |
|---|---|---|---|
| sql | string | Yes | Migration SQL (PostgreSQL), one or more statements. |
| pg_version | integer | No | Target PostgreSQL major version (affects DEFAULT rewrite and SET NOT NULL rules). |
| assume_in_transaction | boolean | No | Set true if the migration tool wraps the file in a transaction. |
| ignore_rules | array | No | Rule ids to skip. |
Show full input schema
{
"type": "object",
"additionalProperties": false,
"required": [
"sql"
],
"properties": {
"sql": {
"type": "string",
"minLength": 1,
"maxLength": 500000,
"description": "Migration SQL (PostgreSQL), one or more statements."
},
"pg_version": {
"type": "integer",
"minimum": 10,
"maximum": 19,
"default": 16,
"description": "Target PostgreSQL major version (affects DEFAULT rewrite and SET NOT NULL rules)."
},
"assume_in_transaction": {
"type": "boolean",
"default": false,
"description": "Set true if the migration tool wraps the file in a transaction."
},
"ignore_rules": {
"type": "array",
"maxItems": 40,
"items": {
"type": "string",
"maxLength": 60
},
"default": [],
"description": "Rule ids to skip."
}
}
}Published input example
{
"sql": "ALTER TABLE users ADD COLUMN token uuid DEFAULT gen_random_uuid();\nCREATE INDEX users_email_idx ON users (email);",
"pg_version": 16
}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