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 type {
ColumnMetadata,
TableMetadata,
} from "@/types/proto-es/v1/database_service_pb";
export const findPrimaryKey = (table: TableMetadata) => {
return table.indexes.find((idx) => idx.primary);
};
export const isPrimaryKey = (table: TableMetadata, column: ColumnMetadata) => {
const pk = findPrimaryKey(table);
if (!pk) return false;
return pk.expressions.includes(column.name);
};
export const findIndexes = (table: TableMetadata, column: ColumnMetadata) => {
return table.indexes.filter(
(idx) => !idx.primary && idx.expressions.includes(column.name)
);
};
export const isIndex = (table: TableMetadata, column: ColumnMetadata) => {
return findIndexes(table, column).length > 0;
};