coder
diff --git a/‎coderd/database/models.go
+1-1 b/‎coderd/database/models.go
+1-1
diff --git a/‎coderd/database/querier.go
+1-1 b/‎coderd/database/querier.go
+1-1
diff --git a/‎coderd/database/queries.sql.go
+1-1 b/‎coderd/database/queries.sql.go
+1-1
diff --git a/‎coderd/notifications/dispatch/smtp/html.gotmpl
+1-1 b/‎coderd/notifications/dispatch/smtp/html.gotmpl
+1-1
diff --git a/‎coderd/notifications/notifier.go
+18 b/‎coderd/notifications/notifier.go
+18
diff --git a/‎coderd/notifications/spec.go
+2 b/‎coderd/notifications/spec.go
+2
@@ -8,7 +8,7 @@
   <body style="margin: 0; padding: 0; font-family: -apple-system, system-ui, BlinkMacSystemFont, 'Segoe UI', 'Roboto', 'Oxygen', 'Ubuntu', 'Cantarell', 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; color: #020617; background: #f8fafc;">
     <div style="max-width: 600px; margin: 20px auto; padding: 60px; border: 1px solid #e2e8f0; border-radius: 8px; background-color: #fff; text-align: left; font-size: 14px; line-height: 1.5;">
       <div style="text-align: center;">
-        <img src="https://coder.com/coder-logo-horizontal.png" alt="Coder Logo" style="height: 40px;" />
+        <img src="{{ .Labels._logo_url }}" alt="Company Logo" style="height: 40px;" />
       </div>
       <h1 style="text-align: center; font-size: 24px; font-weight: 400; margin: 8px 0 32px; line-height: 1.5;">
         {{ .Labels._subject }}
 
@@ -2,7 +2,9 @@ package notifications
 
 import (
 	"context"
+	"database/sql"
 	"encoding/json"
+	"errors"
 	"sync"
 	"text/template"
 
@@ -22,6 +24,10 @@ import (
 	"github.com/coder/coder/v2/coderd/database"
 )
 
+const (
+	notificationsDefaultLogoURL = "https://coder.com/coder-logo-horizontal.png"
+)
+
 // notifier is a consumer of the notifications_messages queue. It dequeues messages from that table and processes them
 // through a pipeline of fetch -> prepare -> render -> acquire handler -> deliver.
 type notifier struct {
@@ -223,6 +229,18 @@ func (n *notifier) prepare(ctx context.Context, msg database.AcquireNotification
 		return nil, xerrors.Errorf("failed to resolve handler %q", msg.Method)
 	}
 
+	logoURL, err := n.store.GetLogoURL(ctx)
+	if err != nil && !errors.Is(err, sql.ErrNoRows) {
+		n.log.Error(ctx, "failed fetching logo url", slog.Error(err))
+	}
+
+	if logoURL == "" {
+		//nolint:ineffassign // define to default value if unable to fetch one from db
+		logoURL = notificationsDefaultLogoURL
+	}
+
+	payload.Labels["_logo_url"] = logoURL
+
 	var title, body string
 	if title, err = render.GoTemplate(msg.TitleTemplate, payload, n.helpers); err != nil {
 		return nil, xerrors.Errorf("render title: %w", err)
 
@@ -22,6 +22,8 @@ type Store interface {
 	FetchNewMessageMetadata(ctx context.Context, arg database.FetchNewMessageMetadataParams) (database.FetchNewMessageMetadataRow, error)
 	GetNotificationMessagesByStatus(ctx context.Context, arg database.GetNotificationMessagesByStatusParams) ([]database.NotificationMessage, error)
 	GetNotificationsSettings(ctx context.Context) (string, error)
+
+	GetLogoURL(ctx context.Context) (string, error)
 }
 
 // Handler is responsible for preparing and delivering a notification by a given method.
Original file line number	Diff line number	Diff line change
`@@ -22,6 +22,8 @@ type Store interface {`
`22`	`22`	`FetchNewMessageMetadata(ctx context.Context, arg database.FetchNewMessageMetadataParams) (database.FetchNewMessageMetadataRow, error)`
`23`	`23`	`GetNotificationMessagesByStatus(ctx context.Context, arg database.GetNotificationMessagesByStatusParams) ([]database.NotificationMessage, error)`
`24`	`24`	`GetNotificationsSettings(ctx context.Context) (string, error)`
	`25`	`+`
	`26`	`+ GetLogoURL(ctx context.Context) (string, error)`
`25`	`27`	`}`
`26`	`28`
`27`	`29`	`// Handler is responsible for preparing and delivering a notification by a given method.`