KalamDB Server Procedures

Run KalamDB server logic next to your data and call it from SQL. Create the app schema first and use an account with routine creation privileges.

Create a KalamDB function or procedure

1CREATE OR REPLACE FUNCTION app.echo(msg TEXT)2RETURNS TEXT3LANGUAGE JAVASCRIPT4AS $$5  return input.msg;6$$;7 8SELECT app.echo('hello');

Expect a value of hello. Function arguments arrive in the named input object. In 0.8, a function declares RETURNS and is invoked with SELECT. A procedure uses CALL and can declare OUT or INOUT parameters instead:

1CREATE OR REPLACE PROCEDURE app.bump(INOUT value INT, OUT doubled INT)2LANGUAGE PLPGSQL3AS $$4BEGIN5  doubled := value * 2;6  value := value + 1;7END8$$;9 10CALL app.bump(7);

Expect value to be 8 and doubled to be 14.

Call it from your application

Use your SDK’s SQL query API to execute CALL, or use the generated function client from schema generation and deployment. Procedures also have an HTTP invocation endpoint.

Common mistakes

Do not use the older CREATE PROCEDURE … RETURNS syntax in 0.8. New routines are not executable by everyone. Grant execution intentionally before calling as a normal application user. Inline JavaScript runs immediately; project TypeScript needs compilation and deployment. Do not send ctx, actor identity, or transaction context from the client.

Next step

Send background work through topics →

Reference: Procedure permissions, topic triggers, and scheduled jobs.