Control TypeScript client code generation for individual endpoints using custom parameter annotations.

::: warning Requires Configuration TypeScript client generation must be enabled in the Code Generation configuration (ClientCodeGen.Enabled = true). :::

@tsclient = <true|false>
@tsclient_module = <module_name>
@tsclient_events = <true|false>
@tsclient_parse_url = <true|false>
@tsclient_parse_request = <true|false>
@tsclient_status_code = <true|false>
@tsclient_export_url = <true|false>
@tsclient_url_only = <true|false>

Use @tsclient = false to skip client generation for endpoints that return binary data or are not useful in the TypeScript client:

create function get_image(_id int)
returns bytea
language sql
begin atomic;
  select data from images where id = _id;
end;

comment on function get_image(int) is '
HTTP GET
@tsclient = false
';

Equivalent as a SQL file endpoint (sql/get-image.sql):

/*
HTTP GET
@tsclient = false
@param $1 id
*/
select data from images where id = $1;

Use @tsclient_url_only = true for endpoints consumed via browser navigation rather than fetch — such as table format downloads or file exports:

create function get_data(
    _format text,
    _excel_file_name text = null,
    _excel_sheet text = null
)
returns table (int_val int, text_val text, date_val date)
language sql
begin atomic;
  select * from data;
end;

comment on function get_data(text, text, text) is '
HTTP GET
@table_format = {_format}
@excel_file_name = {_excel_file_name}
@excel_sheet = {_excel_sheet}
@tsclient_url_only = true
';

This generates only the URL builder and request interface:

export const getDataUrl = (request: IGetDataRequest) =>
    baseUrl + "/api/get-data" + parseQuery(request);

interface IGetDataRequest {
    format: string | null;
    excelFileName?: string | null;
    excelSheet?: string | null;
}

Use @tsclient_module to group endpoints from different schemas into the same generated file:

comment on function public.get_users() is '
HTTP GET
@tsclient_module = admin
';

comment on function auth.get_roles() is '
HTTP GET
@tsclient_module = admin
';

Both endpoints will be generated in the admin module file.

• Code Generation - Global TypeScript client generation configuration
• Custom Parameters - Custom parameter syntax and dynamic values
• Comment Annotations Guide - How annotations work
• Configuration Guide - How configuration works

• TABLE_FORMAT - Table format rendering (commonly used with tsclient_url_only)
• SSE - Server-Sent Events (use tsclient_events to control SSE parameter generation)

• Code Generation - Configure TypeScript client generation