coder
diff --git a/‎Makefile
+3 b/‎Makefile
+3
diff --git a/‎cli/resetpassword.go
+4-4 b/‎cli/resetpassword.go
+4-4
diff --git a/‎coderd/database/dbresetpw/db.go
+31 b/‎coderd/database/dbresetpw/db.go
+31
diff --git a/‎coderd/database/dbresetpw/models.go
+121 b/‎coderd/database/dbresetpw/models.go
+121
diff --git a/‎coderd/database/dbresetpw/sqlc.yaml
+13 b/‎coderd/database/dbresetpw/sqlc.yaml
+13
diff --git a/‎coderd/database/dbresetpw/users_resetpw.sql.go
+75 b/‎coderd/database/dbresetpw/users_resetpw.sql.go
+75
@@ -516,6 +516,9 @@ coderd/database/dump.sql: coderd/database/gen/dump/main.go $(wildcard coderd/dat
 coderd/database/querier.go: coderd/database/sqlc.yaml coderd/database/dump.sql $(wildcard coderd/database/queries/*.sql)
 	./coderd/database/generate.sh
 
+coderd/database/dbresetpw/users_resetpw.sql.go: coderd/database/querier.go coderd/database/dbresetpw/sqlc.yaml
+	sqlc generate -f ./coderd/database/dbresetpw/sqlc.yaml
+
 coderd/database/dbmock/dbmock.go: coderd/database/db.go coderd/database/querier.go
 	go generate ./coderd/database/dbmock/
 
 
@@ -8,7 +8,7 @@ import (
 
 	"github.com/coder/coder/v2/cli/clibase"
 	"github.com/coder/coder/v2/cli/cliui"
-	"github.com/coder/coder/v2/coderd/database"
+	"github.com/coder/coder/v2/coderd/database/dbresetpw"
 	"github.com/coder/coder/v2/coderd/database/migrations"
 	"github.com/coder/coder/v2/coderd/userpassword"
 )
@@ -37,9 +37,9 @@ func (*RootCmd) resetPassword() *clibase.Cmd {
 			if err != nil {
 				return xerrors.Errorf("database needs migration: %w", err)
 			}
-			db := database.New(sqlDB)
+			db := dbresetpw.New(sqlDB)
 
-			user, err := db.GetUserByEmailOrUsername(inv.Context(), database.GetUserByEmailOrUsernameParams{
+			user, err := db.GetUserByEmailOrUsername(inv.Context(), dbresetpw.GetUserByEmailOrUsernameParams{
 				Username: username,
 			})
 			if err != nil {
@@ -73,7 +73,7 @@ func (*RootCmd) resetPassword() *clibase.Cmd {
 				return xerrors.Errorf("hash password: %w", err)
 			}
 
-			err = db.UpdateUserHashedPassword(inv.Context(), database.UpdateUserHashedPasswordParams{
+			err = db.UpdateUserHashedPassword(inv.Context(), dbresetpw.UpdateUserHashedPasswordParams{
 				ID:             user.ID,
 				HashedPassword: []byte(hashedPassword),
 			})
 
@@ -0,0 +1,13 @@
+# This sqlc.yaml file is used by sqlc to generate a subset of the coderd
+# database interface that can be used for the reset-password command.
+version: "2"
+
+sql:
+  - schema: "../dump.sql"
+    queries: "../queries/users_resetpw.sql"
+    engine: "postgresql"
+    gen:
+      go:
+        package: "dbresetpw"
+        out: "."
+        omit_unused_structs: true