Discord: Automate stats messages

Is your feature request related to a problem?
We have set up a new Kaapi server and need to automate messages about yesterday's traffic in the "stats" channel. This feature is necessary to keep track of platform performance, similar to what Glific has already implemented.

Describe the solution you'd like
Send automated messages in the "stats" channel regarding yesterday's traffic including success and failure counts in the messages.

Summary stats SQL query

SELECT
 o.name as "organization_name",
 l.model,
 SUM((l.usage->>'total_tokens')::INTEGER) AS "sum_total_tokens", 
 SUM((l.usage->>'input_tokens')::INTEGER) AS "sum_input_tokens", 
 SUM((l.usage->>'output_tokens')::INTEGER) AS "sum_output_tokens"
FROM llm_call l
INNER JOIN 
	organization o on l.organization_id=o.id
WHERE l.inserted_at BETWEEN '2026-03-15' AND '2026-05-15'
GROUP BY
	o.name,
	l.model
ORDER BY 
	"sum_total_tokens" DESC;

🎉 This issue has been resolved in version 1.5.0-main.10 🎉

The release is available on GitHub release

Your semantic-release bot 📦🚀

Navigation Menu

Repository navigation

Discord: Automate stats messages #825

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Discord: Automate stats messages #825

Description

Activity

Prajna1999 commented on May 22, 2026

github-actions commented on Aug 26, 2026

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions