Query

MaiBot.db — llm_usage

+/- table definition

Query 

CREATE TABLE "llm_usage"  (
  "id" INTEGER NOT NULL PRIMARY KEY,
  "model_name" TEXT NOT NULL,
  "user_id" TEXT NOT NULL,
  "request_type" TEXT NOT NULL,
  "endpoint" TEXT NOT NULL,
  "prompt_tokens" INTEGER NOT NULL,
  "completion_tokens" INTEGER NOT NULL,
  "total_tokens" INTEGER NOT NULL,
  "cost" REAL NOT NULL,
  "status" TEXT NOT NULL,
  "timestamp" DATETIME NOT NULL,
  model_assign_name TEXT NULL,
  model_api_provider TEXT NULL,
  time_cost DOUBLE NULL
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop