Codewerk
sql on csv
Loads the supplied CSV texts (auto-detected types, optional delimiter and header flag) into an in-memory DuckDB, then disables all file, network and extension access and locks the configuration before running exactly one statement. Limits: 5 MB CSV per table, 4.5 s execution, 512 MB memory, one thread, at most 1000 returned rows. Nothing is stored after the call.
POST https://code.halowerk.com/v1/sql-on-csvInputs
| Field | Type | Required | Description |
|---|---|---|---|
| tables | array | Yes | |
| query | string | Yes | |
| max_rows | integer | No |
Show full input schema
{
"type": "object",
"additionalProperties": false,
"required": [
"tables",
"query"
],
"properties": {
"tables": {
"type": "array",
"minItems": 1,
"maxItems": 5,
"items": {
"type": "object",
"additionalProperties": false,
"required": [
"name",
"csv"
],
"properties": {
"name": {
"type": "string",
"pattern": "^[A-Za-z_][A-Za-z0-9_]{0,62}$"
},
"csv": {
"type": "string",
"minLength": 1,
"maxLength": 5000000
},
"delimiter": {
"type": "string",
"enum": [
",",
";",
"\t",
"|"
]
},
"header": {
"type": "boolean",
"default": true
}
}
}
},
"query": {
"type": "string",
"minLength": 1,
"maxLength": 20000
},
"max_rows": {
"type": "integer",
"minimum": 1,
"maximum": 1000,
"default": 200
}
}
}Published input example
{
"tables": [
{
"name": "orders",
"csv": "id,amount,country\n1,19.90,DE\n2,5.00,AT\n3,42.10,DE"
}
],
"query": "SELECT country, sum(amount) AS total FROM orders GROUP BY country ORDER BY total DESC"
}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