Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

1.7 KB
Raw Blame
import { useTranslation } from "react-i18next";
import {
  Select,
  SelectContent,
  SelectItem,
  SelectTrigger,
  SelectValue,
} from "@/components/ui/select";
import { useAppDatabaseMetadata } from "@/hooks/useAppDatabaseMetadata";
import { useConnectionOfCurrentSQLEditorTab } from "@/modules/sql-editor/hooks/useSQLEditorState";
import { hasSchemaProperty } from "@/utils";
import { useViewStateNav } from "./useViewStateNav";

/**
 * Renders nothing for engines without a schema concept.
 */
export function SchemaSelectToolbar() {
  const { t } = useTranslation();
  const { database, instance } = useConnectionOfCurrentSQLEditorTab();
  const databaseName = database.name;
  const engine = instance.engine;
  const databaseMetadata = useAppDatabaseMetadata(databaseName ?? "", {
    autoFetch: false,
  });

  const { schema, setSchema } = useViewStateNav();

  if (engine === undefined || !hasSchemaProperty(engine)) return null;

  const options = databaseMetadata.schemas.map((s) => ({
    label: s.name || t("db.schema.default"),
    value: s.name,
  }));

  return (
    <Select
      value={schema ?? ""}
      onValueChange={(value) => {
        if (typeof value === "string") setSchema(value);
      }}
    >
      {/* Use `h-8` to align with the sibling `DatabaseChooser` (also h-8);
          the default `size="sm"` trigger is `h-7` and looked shorter. */}
      <SelectTrigger size="sm" className="min-w-32 h-8 shrink-0">
        <SelectValue />
      </SelectTrigger>
      <SelectContent>
        {options.map((option) => (
          <SelectItem key={option.value} value={option.value}>
            {option.label}
          </SelectItem>
        ))}
      </SelectContent>
    </Select>
  );
}