Keep Postgres boring. Put the exciting parts around it.

-- A plain Postgres trigger that now reaches the outside world:
-- analyze the incident with your operator, file a Linear ticket.
CREATE FUNCTION on_critical_incident() RETURNS trigger AS $$
BEGIN
  PERFORM rvbbit.mcp_call('linear', 'create_issue', jsonb_build_object(
    'title',       'SEV1 · ' || NEW.service,
    'description', summarize_incident(NEW.logs)   -- your LLM operator
  ));
  RETURN NEW;
END $$ LANGUAGE plpgsql;

CREATE TRIGGER incident_to_linear
  AFTER INSERT ON incidents
  FOR EACH ROW WHEN (NEW.severity = 'critical')
  EXECUTE FUNCTION on_critical_incident();

-- Or declare it: a condition → an action, swept on a clock, edge-triggered.
SELECT rvbbit.define_alert(
  'revenue_drop',
  '{"kind":"sql","metric_name":"daily_revenue"}'::jsonb,
  '{"operator":"mcp_call","server":"linear","tool":"create_issue"}'::jsonb
);

-- what did the last day of AI + actions cost, and where?
SELECT operator,
       model,
       count(*)                                  AS calls,
       round(sum(cost_usd)::numeric, 4)          AS cost_usd,
       round(avg(latency_ms))                    AS avg_ms,
       count(*) FILTER (WHERE error IS NOT NULL) AS errors
FROM   rvbbit.receipts
WHERE  invocation_at > now() - interval '1 day'
GROUP  BY operator, model
ORDER  BY cost_usd DESC;

SELECT rvbbit.register_mcp_server(
  server_name       => 'github',
  server_transport  => 'stdio',
  server_command    => 'npx',
  server_args       => ARRAY['-y', '@modelcontextprotocol/server-github'],
  server_env        => '{"GITHUB_PERSONAL_ACCESS_TOKEN":"${GITHUB_TOKEN}"}'::jsonb
);

SELECT rvbbit.refresh_mcp_server('github');

SELECT a.account_id,
       a.company_name,
       repo->>'full_name' AS matching_repo,
       (repo->>'stargazers_count')::int AS stars
FROM accounts a
JOIN LATERAL rvbbit.mcp_rows(
  'github',
  'search_repositories',
  jsonb_build_object(
    'query', a.company_name || ' postgres',
    'perPage', 3
  )
) repo ON true
WHERE a.tier = 'strategic'
ORDER BY stars DESC;