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 { FormatOptionsWithLanguage } from "sql-formatter";
import type { SQLDialect } from "@/types";
type FormatResult = {
data: string;
error: Error | null;
};
type FormatterLanguage = FormatOptionsWithLanguage["language"];
const convertDialectToFormatterLanguage = (
dialect: SQLDialect | undefined
): FormatterLanguage => {
if (dialect === "MYSQL" || dialect === "TIDB" || dialect === "OCEANBASE") {
return "mysql";
}
if (dialect === "POSTGRES") {
return "postgresql";
}
if (dialect === "SNOWFLAKE") {
return "snowflake";
}
return "sql";
};
export const formatSQL = async (
sql: string,
dialect: SQLDialect | undefined
): Promise<FormatResult> => {
const { format } = await import("sql-formatter");
const options: Partial<FormatOptionsWithLanguage> = {
language: convertDialectToFormatterLanguage(dialect),
};
try {
return { data: format(sql, options), error: null };
} catch (error) {
return { data: "", error: error as Error };
}
};