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 { useEffect, useMemo } from "react";
import { useAppStore } from "@/stores/app";
import {
catalogResourceName,
emptyDatabaseCatalog,
} from "@/stores/app/databaseCatalog";
import { UNKNOWN_ID } from "@/types";
import type { DatabaseCatalog } from "@/types/proto-es/v1/database_catalog_service_pb";
import {
extractDatabaseResourceName,
getDatabaseProject,
hasProjectPermissionV2,
} from "@/utils";
// Fetches the catalog (gated by permission) and reactively returns the cached
// entry, falling back to a stable empty catalog so the selector never loops.
export function useDatabaseCatalog(
database: string,
skipCache: boolean
): DatabaseCatalog {
useEffect(() => {
if (
extractDatabaseResourceName(database).databaseName === String(UNKNOWN_ID)
) {
return;
}
void (async () => {
const db = await useAppStore
.getState()
.getOrFetchDatabaseByName(database);
if (
hasProjectPermissionV2(
getDatabaseProject(db),
"bb.databaseCatalogs.get"
)
) {
await useAppStore
.getState()
.getOrFetchDatabaseCatalog({ database, skipCache });
}
})();
}, [database, skipCache]);
const cached = useAppStore(
(state) => state.catalogsByName[catalogResourceName(database)]
);
return useMemo(
() => cached ?? emptyDatabaseCatalog(database),
[cached, database]
);
}