First set the cockroach binary: (setq sql-postgres-program "cockroach") Then invoke the SQL client with the first arg, and pass options in with the rest.
(setq sql-postgres-login-params '((user :default "root") (database :default "") (server :default "localhost") (port :default 26500))) Step 2.