Codewerk
mysql to pg plan
Parses MySQL DDL (mysqldump or SHOW CREATE TABLE output; backticks, inline and table-level keys, table options) with an own parser and maps every column by pgloader's documented default MySQL casting rules (PostgreSQL License, docs/ref/mysql.rst at commit 231ab86, 2026-09-14), using exact value ranges from the MySQL 8.4 and PostgreSQL 18 manuals where pgloader decides by display width (INT -> integer, INT UNSIGNED -> bigint, BIGINT UNSIGNED -> numeric(20,0), DECIMAL -> numeric(10,0).
POST https://code.halowerk.com/v1/mysql-to-pg-planInputs
| Field | Type | Required | Description |
|---|---|---|---|
| mysql_ddl | string | Yes | MySQL CREATE TABLE statements (other statements are skipped). |
| tinyint1_as_boolean | boolean | No | |
| datetime_as | string | No | pgloader default is timestamptz. |
| enum_as | string | No | |
| unsigned_checks | boolean | No | Add CHECK (col >= 0) for UNSIGNED columns. |
| identity | string | No |
Show full input schema
{
"type": "object",
"additionalProperties": false,
"required": [
"mysql_ddl"
],
"properties": {
"mysql_ddl": {
"type": "string",
"minLength": 10,
"maxLength": 2000000,
"description": "MySQL CREATE TABLE statements (other statements are skipped)."
},
"tinyint1_as_boolean": {
"type": "boolean",
"default": true
},
"datetime_as": {
"type": "string",
"enum": [
"timestamptz",
"timestamp"
],
"default": "timestamptz",
"description": "pgloader default is timestamptz."
},
"enum_as": {
"type": "string",
"enum": [
"enum_type",
"check"
],
"default": "enum_type"
},
"unsigned_checks": {
"type": "boolean",
"default": true,
"description": "Add CHECK (col >= 0) for UNSIGNED columns."
},
"identity": {
"type": "string",
"enum": [
"identity",
"serial"
],
"default": "identity"
}
}
}Published input example
{
"mysql_ddl": "CREATE TABLE `users` (`id` int unsigned NOT NULL AUTO_INCREMENT, `email` varchar(191) NOT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;"
}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