MySQL

MySQL is an open-source relational DBMS. Evidence supports connecting to MySQL as a data source, allowing you to query data using SQL.

Add a New MySQL Data Source

1. Start the Evidence dev server: npm run dev or Start Evidence using the VSCode extension.
2. Navigate to the settings page, also accessible via the ... menu in the top right.
3. Click the New Source button.
4. Select MySQL as the data source type.
5. Enter the configuration options for the connection.
6. Click the Test button to confirm the connection is successful.
7. Click the Save button to save the connection.
8. Your configuration options are saved in two files:
   • /sources/[source_name]/connections.yaml: Non-sensitive values, source controlled.
   • /sources/[source_name]/connection.options.yaml: Sensitive values, not source controlled, base-64 encoded.

Configuration

SSL

SSL options are:

• false (default)
• true
• Amazon RDS
• A credentials object