MySQL URI Format

The Uniform Resource Identifier (URI) definition for MySQL follows this standard:

Identifier Fragments

• Namespace: mysql://{host}:{port}
  • Scheme = mysql
  • Authority = {host}:{port}
• Unique name: {schema}.{table}

Asset URI Format

• mysql://{host}:{port}/{schema}.{table}

Schema URI Format

• mysql://{host}:{port}/{schema}

Parameter Limitations

• host identifier must start with a lowercase letter and include only lowercase letters, numbers, dash and dot (regex: [a-z][a-z0-9-.]+)
• port number must include only numbers
• schema and table can have two formats, following MySQL naming standards: quoted format and unquoted format
  • unquoted identifier must include only lowercase letters, uppercase letters, numbers, dollar sign and underscore (regex:[a-zA-Z0-9$_]+) and characters in the Unicode range U+0080 to U+FFFF
  • quoted identifier must be enclosed in backticks (`) and must include only characters included in the Unicode range U+0001 to U+FFFF. If a backtick is included in the name, it needs to be escaped with another backtick.

Asset Examples

• mysql://sifflet-dev-mysql.quha2ngc.eu-west-1.rds.amazonaws.com:3306/my_database.my_table
• mysql://testing-mysql.cfbu.us-west-1.rds:3307/`MY DB`.테스트_데이터1

Schema Examples

• mysql://sifflet-dev-mysql.quha2ngc.eu-west-1.rds.amazonaws.com:3306/my_database
• mysql://testing-mysql.cfbu.us-west-1.rds:3307/`MY DB`