coder · blink-so · Jul 19, 2025 · Jul 19, 2025 · Jul 19, 2025 · Jul 19, 2025
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000350_workspace_apps.down.sql b/coderd/database/migrations/000350_workspace_apps.down.sql
@@ -0,0 +1,2 @@
+-- Remove workspace_apps column from workspace_agents table
+ALTER TABLE workspace_agents DROP COLUMN workspace_apps;
diff --git a/coderd/database/migrations/000350_workspace_apps.up.sql b/coderd/database/migrations/000350_workspace_apps.up.sql
@@ -0,0 +1,4 @@
+-- Add workspace_apps column to workspace_agents table
+ALTER TABLE workspace_agents ADD COLUMN workspace_apps text[] DEFAULT NULL;
+
+COMMENT ON COLUMN workspace_agents.workspace_apps IS 'List of app IDs to display in the workspace table, configured via terraform';
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
diff --git a/coderd/database/queries/workspaceagents.sql b/coderd/database/queries/workspaceagents.sql
@@ -58,11 +58,12 @@ INSERT INTO
 		troubleshooting_url,
 		motd_file,
 		display_apps,
+		workspace_apps,
 		display_order,
 		api_key_scope
 	)
 VALUES
-	($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20) RETURNING *;
+	($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21) RETURNING *;
 
 -- name: UpdateWorkspaceAgentConnectionByID :exec
 UPDATE

diff --git a/coderd/provisionerdserver/provisionerdserver.go b/coderd/provisionerdserver/provisionerdserver.go
@@ -2428,6 +2428,7 @@ func InsertWorkspaceResource(ctx context.Context, db database.Store, jobID uuid.
 			TroubleshootingURL:       prAgent.GetTroubleshootingUrl(),
 			MOTDFile:                 prAgent.GetMotdFile(),
 			DisplayApps:              convertDisplayApps(prAgent.GetDisplayApps()),
+			WorkspaceApps:            prAgent.GetWorkspaceApps(),
 			InstanceMetadata:         pqtype.NullRawMessage{},
 			ResourceMetadata:         pqtype.NullRawMessage{},
 			// #nosec G115 - Order represents a display order value that's always small and fits in int32

diff --git a/codersdk/workspaceagents.go b/codersdk/workspaceagents.go
@@ -169,6 +169,7 @@ type WorkspaceAgent struct {
 	Subsystems               []AgentSubsystem          `json:"subsystems"`
 	Health                   WorkspaceAgentHealth      `json:"health"` // Health reports the health of the agent.
 	DisplayApps              []DisplayApp              `json:"display_apps"`
+	WorkspaceApps            []string                  `json:"workspace_apps"`
 	LogSources               []WorkspaceAgentLogSource `json:"log_sources"`
 	Scripts                  []WorkspaceAgentScript    `json:"scripts"`
 

diff --git a/provisioner/terraform/resources.go b/provisioner/terraform/resources.go
@@ -59,6 +59,7 @@ type agentAttributes struct {
 	MOTDFile                 string                       `mapstructure:"motd_file"`
 	Metadata                 []agentMetadata              `mapstructure:"metadata"`
 	DisplayApps              []agentDisplayAppsAttributes `mapstructure:"display_apps"`
+	WorkspaceApps            []string                     `mapstructure:"workspace_apps"`
 	Order                    int64                        `mapstructure:"order"`
 	ResourcesMonitoring      []agentResourcesMonitoring   `mapstructure:"resources_monitoring"`
 }
@@ -348,6 +349,7 @@ func ConvertState(ctx context.Context, modules []*tfjson.StateModule, rawGraph s
 				ResourcesMonitoring:      resourcesMonitoring,
 				Metadata:                 metadata,
 				DisplayApps:              displayApps,
+				WorkspaceApps:            attrs.WorkspaceApps,
 				Order:                    attrs.Order,
 				ApiKeyScope:              attrs.APIKeyScope,
 			}
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- Remove workspace_apps column from workspace_agents table
		ALTER TABLE workspace_agents DROP COLUMN workspace_apps;