Function sanitizeSingleIdentifier

apps/sim/app/api/tools/mysql/utils.ts:172–182

(identifier: string)

}

function sanitizeSingleIdentifier(identifier: string): string {
  const cleaned = identifier.replace(/`/g, '')

  if (!/^[a-zA-Z_][a-zA-Z0-9_]*$/.test(cleaned)) {
    throw new Error(
      `Invalid identifier: ${identifier}. Identifiers must start with a letter or underscore and contain only letters, numbers, and underscores.`
    )
  }

  return `\`${cleaned}\``
}

export interface MySQLIntrospectionResult {
  tables: Array<{