Skip to content
Written with Claude
IMPORTANT

As you may notice, this page and pretty much the entire website were obviously created with the help of AI. I wonder how you could tell? Was it a big "Written With Claude" badge on every page? I moved it to the top now (with the help of AI of course) to make it even more obvious. There are a few blogposts that were written by me manually, the old-fashioned way, I hope there will be more in the future, and those have a similar "Human Written" badge. This project (not the website), on the other hand, is a very, very different story. It took me more than two years of painstaking and unpaid work in my own free time. A story that, hopefully, I will tell someday. But meanwhile, what would you like me to do? To create a complex documentation website with a bunch of highly technical articles with the help of AI and fake it, to give you an illusion that I also did that manually? Like the half of itnernet is doing at this point? How does that makes any sense? Is that even fair to you? Or maybe to create this website manually, the old-fashioned way, just for you? While working a paid job for a salary, most of you wouldn't even get up in the morning. Would you like me to sing you a song while we're at it? For your personal entertainment? Seriously, get a grip. Do you find this information less valuable because of the way this website was created? I give my best to fix it to keep the information as accurate as possible, and I think it is very accurate at this point. If you find some mistakes, inaccurancies or problems, there is a comment section at the bottom of every page, which I also made with the help of the AI. And I woould very much appreciate if you leave your feedback there. Look, I'm just a guy who likes SQL, that's all. If you don't approve of how this website was constructed and the use of AI tools, I suggest closing this page and never wever coming back. And good riddance. And I would ban your access if I could know how. Thank you for your attention to this matter.

Code Generation

Configuration for generating TypeScript/JavaScript client code for NpgsqlRest endpoints.

Overview

json
{
  "NpgsqlRest": {
    "ClientCodeGen": {
      "Enabled": false,
      "FilePath": null,
      "FileOverwrite": true,
      "IncludeHost": true,
      "CustomHost": null,
      "CommentHeader": "Simple",
      "CommentHeaderIncludeComments": true,
      "BySchema": true,
      "IncludeStatusCode": true,
      "CreateSeparateTypeFile": true,
      "ImportBaseUrlFrom": null,
      "ImportParseQueryFrom": null,
      "IncludeParseUrlParam": false,
      "IncludeParseRequestParam": false,
      "HeaderLines": ["// autogenerated at {0}", ""],
      "SkipRoutineNames": [],
      "SkipFunctionNames": [],
      "SkipPaths": [],
      "SkipSchemas": [],
      "DefaultJsonType": "string",
      "UseRoutineNameInsteadOfEndpoint": false,
      "ExportUrls": false,
      "SkipTypes": false,
      "UniqueModels": false,
      "XsrfTokenHeaderName": null,
      "ExportEventSources": true,
      "CustomImports": [],
      "CustomHeaders": {},
      "IncludeSchemaInNames": true,
      "ErrorExpression": "await response.json()",
      "ErrorType": "{status: number; title: string; detail?: string | null} | undefined"
    }
  }
}

General Settings

SettingTypeDefaultDescription
EnabledboolfalseEnable client code generation.
FilePathstringnullOutput file path. Use {0} for schema name when BySchema is true. null to skip.
FileOverwritebooltrueOverwrite existing files.
BySchemabooltrueCreate separate files per PostgreSQL schema.
IncludeSchemaInNamesbooltrueInclude schema name in generated type names to avoid collisions.

Host Configuration

SettingTypeDefaultDescription
IncludeHostbooltrueInclude current host in URL prefix.
CustomHoststringnullCustom host prefix for URLs.

Comment Headers

SettingTypeDefaultDescription
CommentHeaderstring"Simple"Comment header style: "None", "Simple", or "Full".
CommentHeaderIncludeCommentsbooltrueInclude routine comments in header.

Comment Header Styles

StyleDescription
NoneNo comment header.
SimpleAdd routine name, parameters, and return values (default).
FullAdd entire routine code as comment header.

Response Options

SettingTypeDefaultDescription
IncludeStatusCodebooltrueInclude status code in response: {status: response.status, response: model}.
ErrorExpressionstring"await response.json()"Expression to parse error responses. Only used when IncludeStatusCode is true.
ErrorTypestring(see below)TypeScript type for error responses. Only used when IncludeStatusCode is true.

Default ErrorType: "{status: number; title: string; detail?: string | null} | undefined"

These options allow customization of error handling in generated code. Void functions and procedures also return the error object when IncludeStatusCode is true.

Type Generation

SettingTypeDefaultDescription
CreateSeparateTypeFilebooltrueCreate separate {name}Types.d.ts file for global types.
DefaultJsonTypestring"string"Default TypeScript type for JSON types.
SkipTypesboolfalseSkip type generation for pure JavaScript output (changes .ts to .js).
UniqueModelsboolfalseMerge models with same fields/types into one (reduces generated models).

Import Configuration

SettingTypeDefaultDescription
ImportBaseUrlFromstringnullModule to import baseUrl constant from.
ImportParseQueryFromstringnullModule to import parseQuery function from.
CustomImportsarray[]Custom import statements (full expressions).

Function Parameters

SettingTypeDefaultDescription
IncludeParseUrlParamboolfalseInclude parseUrl: (url: string) => string parameter.
IncludeParseRequestParamboolfalseInclude parseRequest: (request: RequestInit) => RequestInit parameter.

Skip Options

SettingTypeDefaultDescription
SkipRoutineNamesarray[]Routine names to skip (without schema).
SkipFunctionNamesarray[]Generated function names to skip (without schema).
SkipPathsarray[]URL paths to skip.
SkipSchemasarray[]Schema names to skip.

Export Options

SettingTypeDefaultDescription
ExportUrlsboolfalseExport URLs as constants.
ExportEventSourcesbooltrueExport EventSource create functions for streaming events.
UseRoutineNameInsteadOfEndpointboolfalseUse routine name instead of endpoint name for functions.

Headers and Security

SettingTypeDefaultDescription
CustomHeadersobject{}Custom headers added to each request.
XsrfTokenHeaderNamestringnullXSRF token header name for anti-forgery (used in upload FORM POSTs).

File Headers

SettingTypeDefaultDescription
HeaderLinesarray["// autogenerated at {0}", ""]Header lines for generated files. {0} = timestamp.

Path Parameters Support

When endpoints use path parameters (e.g., /products/{id}), TsClient automatically generates template literal URLs in the generated TypeScript code:

typescript
// Generated function for endpoint: GET /products/{pId}
export async function getProduct(request: { pId: number }) {
    const response = await fetch(`${baseUrl}/products/${request.pId}`, {
        method: "GET",
        headers: { "Content-Type": "application/json" }
    });
    return { status: response.status, response: await response.json() };
}

The parseQuery helper function is only included in generated files when there are actual query string parameters. Endpoints with only path parameters will not include this helper.

Example Configurations

Basic TypeScript Generation

json
{
  "NpgsqlRest": {
    "ClientCodeGen": {
      "Enabled": true,
      "FilePath": "./src/api/{0}Api.ts",
      "BySchema": true,
      "IncludeStatusCode": true,
      "CreateSeparateTypeFile": true
    }
  }
}

Single JavaScript File

json
{
  "NpgsqlRest": {
    "ClientCodeGen": {
      "Enabled": true,
      "FilePath": "./src/api/client.js",
      "BySchema": false,
      "SkipTypes": true,
      "IncludeSchemaInNames": false
    }
  }
}

Production Configuration

json
{
  "NpgsqlRest": {
    "ClientCodeGen": {
      "Enabled": true,
      "FilePath": "./client/src/api/{0}Api.ts",
      "FileOverwrite": true,
      "IncludeHost": false,
      "CustomHost": null,
      "CommentHeader": "Simple",
      "CommentHeaderIncludeComments": true,
      "BySchema": true,
      "IncludeStatusCode": true,
      "CreateSeparateTypeFile": true,
      "ImportBaseUrlFrom": "./config",
      "SkipSchemas": ["internal", "pg_catalog"],
      "UniqueModels": true,
      "ExportUrls": true,
      "ExportEventSources": true,
      "CustomHeaders": {
        "X-Client-Version": "\"1.0.0\""
      },
      "HeaderLines": [
        "// Auto-generated API client",
        "// Do not edit manually",
        ""
      ]
    }
  }
}

With Custom Imports and Parse Functions

json
{
  "NpgsqlRest": {
    "ClientCodeGen": {
      "Enabled": true,
      "FilePath": "./src/api/{0}Api.ts",
      "ImportBaseUrlFrom": "@/config",
      "ImportParseQueryFrom": "@/utils/query",
      "IncludeParseUrlParam": true,
      "IncludeParseRequestParam": true,
      "CustomImports": [
        "import { handleError } from '@/utils/errors';"
      ]
    }
  }
}

Next Steps

Comments

Released under the MIT License.