Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
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>
);
}