coder
diff --git a/‎coderd/database/dump.sql
+13 b/‎coderd/database/dump.sql
+13
diff --git a/‎coderd/database/migrations/000039_agent_stats.down.sql
+1 b/‎coderd/database/migrations/000039_agent_stats.down.sql
+1
diff --git a/‎coderd/database/migrations/000039_agent_stats.up.sql
+14 b/‎coderd/database/migrations/000039_agent_stats.up.sql
+14
diff --git a/‎coderd/database/models.go
+9 b/‎coderd/database/models.go
+9
diff --git a/‎coderd/database/querier.go
+1 b/‎coderd/database/querier.go
+1
diff --git a/‎coderd/database/queries.sql.go
+44 b/‎coderd/database/queries.sql.go
+44
diff --git a/‎coderd/database/queries/agentstats.sql
+12 b/‎coderd/database/queries/agentstats.sql
+12
diff --git a/‎site/src/api/typesGenerated.ts
+10 b/‎site/src/api/typesGenerated.ts
+10
@@ -0,0 +1 @@
+-- this is a no-op
@@ -0,0 +1,14 @@
+CREATE TABLE agent_stats (
+	id text NOT NULL,
+    created_at timestamptz NOT NULL,
+    user_id uuid NOT NULL,
+    agent_id uuid NOT NULL,
+    workspace_id uuid NOT NULL,
+	payload jsonb NOT NULL
+);
+
+-- We use created_at for DAU analysis and pruning.
+CREATE INDEX idx_agent_stats_created_at ON agent_stats USING btree (created_at);
+
+-- We perform user grouping to analyze DAUs.
+CREATE INDEX idx_agent_stats_user_id ON agent_stats USING btree (user_id);
@@ -0,0 +1,12 @@
+-- name: InsertAgentStat :one
+INSERT INTO
+	agent_stats (
+		id,
+		created_at,
+		user_id,
+		workspace_id,
+		agent_id,
+		payload
+	)
+VALUES
+	($1, $2, $3, $4, $5, $6) RETURNING *;
@@ -29,6 +29,16 @@ export interface AgentGitSSHKey {
   readonly private_key: string
 }
 
+// From codersdk/workspaceagents.go
+export interface AgentStatsReportRequest {}
+
+// From codersdk/workspaceagents.go
+export interface AgentStatsReportResponse {
+  // Named type "github.com/coder/coder/agent.ConnStats" unknown, using "any"
+  // eslint-disable-next-line @typescript-eslint/no-explicit-any
+  readonly conns?: any[]
+}
+
 // From codersdk/roles.go
 export interface AssignableRoles extends Role {
   readonly assignable: boolean