MySQL
change-me is every test credential. They are still encrypted and still ask for a login, because FACE refuses a connection that is not (see Connector security). Use a scratch machine or a scratch cluster.Grade A · dataset: SQL (DDL and rows in the engine’s dialect) · type mysql
What it is
A MySQL database. In the test estate it is the freight-billing system, database freight: the carriers (road, and the rail, air and lake carriers of the multi-leg shipments) with their transport mode, their rate contracts, the freight invoices, and each carrier’s depots at real city centroids (U.S. Census Bureau 2024 Gazetteer). The connector reference is SQL warehouses and databases.
Grade
A. Open source. It stands up locally from the download, with the model and its rows, end to end. MySQL 8.
See the grade table for all 32 types.
Settings and credentials
From the connection catalogue. Settings are ordinary fields on the connection record. Credentials are kept in a sealed bundle and never returned.
| Names | |
|---|---|
| Type | mysql |
| Settings | host, port, database, username, and ssl_mode (kept as a property of the connection) |
| Credentials | password |
The test connection
Quillmere freight billing (MySQL)
| Setting | Test value |
|---|---|
host | mysql.quillmere.invalid |
port | 3306 |
database | freight |
username | face_reader |
ssl_mode | require |
FACE refuses a MySQL connection whose ssl_mode is unset, disable, allow or prefer.
Credentials: password. In the test estate, every credential is change-me. Credentials are write-only: they go into the sealed credential bundle and are never returned.
Stand up the test system
The safety rule at the top of this page comes first: a scratch machine or a scratch cluster, never a production or platform one.
Download
mysql.zipand unzip it. It holdsmysql/01_schema.sql,mysql/02_data.sqlandmysql/expected.json.Start a scratch MySQL 8, for example
docker run --rm -e MYSQL_ROOT_PASSWORD=change-me -p 3306:3306 mysql:8. MySQL 8 makes a self-signed certificate at first start and accepts TLS, whichssl_moderequireneeds.Load the schema and the rows, in that order. The schema file creates the
freightdatabase:mysql -h 127.0.0.1 -u root -p < mysql/01_schema.sql mysql -h 127.0.0.1 -u root -p < mysql/02_data.sql mysql -h 127.0.0.1 -u root -p -e "CREATE USER 'face_reader'@'%' IDENTIFIED BY 'change-me'; GRANT SELECT ON freight.* TO 'face_reader'@'%'"Add the connection with the settings above, as Create it in the Console shows. Replace
mysql.quillmere.invalidwith the address of your scratch engine.
Create it in the Console
The screens below were taken on a live instance, adding the quickstart’s database as it runs in the data-systems namespace of Runink’s platform cluster. Your host is your scratch engine’s address; every other value is the test connection’s.
Open Settings › Integrations › Systems and select New connection.
Source: under Warehouses & databases, select MySQL, then Next.

Details: fill in the settings.
Field Value Connection name a name you will recognise, for example Quillmere freight billing (MySQL); the Id follows itEnvironment where this source lives, for example devorstagingHost / endpoint your engine’s address Port 3306Database name freightUser face_readerSsl mode require. MySQL stores it as a property of the connection.
Scroll to Credentials and enter the reader’s Password. It is sealed when you save and never shown again.
Runner: keep Runink managed, or pick a registered runner that can reach the engine, then Next.
Review: check the values. Credentials reads none entered until you type the password in step 4. Keep Test after saving ticked and select Test & save.

The new connection appears in the list with a credential stored chip and the test’s result. It shows as a source on Ask and in every brief’s source list. To read it, see Ask.
What FACE finds
FACE reads the catalogue: information_schema, with the declared primary and foreign keys. A test loads this dataset into an empty engine, runs FACE’s discovery, and compares the result with the expected model (TestSynthUniverseDiscoveryMatchesExpected).
| Dataset | Kind | Domain | Primary key | Rows | Fields |
|---|---|---|---|---|---|
freight.carriers | table | carriers | carrier_id | 7 | 5 |
freight.rate_contracts | table | freight_audit | contract_id | 7 | 8 |
freight.freight_invoices | table | freight_audit | invoice_id | 24 | 8 |
freight.carrier_depots | table | carriers | depot_id | 14 | 8 |
Declared foreign keys:
freight.rate_contracts(carrier_id) referencesfreight.carriers(carrier_id)freight.freight_invoices(carrier_id) referencesfreight.carriers(carrier_id)freight.carrier_depots(carrier_id) referencesfreight.carriers(carrier_id)
expected.json in the download has the full model: every field with its logical type, the source’s native type and nullability.
How it joins the Quillmere universe
This source carries 4 of the universe’s shared keys. The same ID means the same thing in every source: a shipment here is the same shipment in the database, the event bus, the GPS track and the claim PDF.
| Universe entity | Fields here | Also in |
|---|---|---|
| carrier | carriers.carrier_id, freight_invoices.carrier_id, rate_contracts.carrier_id | d365, document, files, guidewire, objectstore, postgres, redshift, sharepoint, tms, yms |
| invoice | freight_invoices.invoice_id | d365, files, objectstore, redshift |
| sap_vendor | carriers.sap_vendor | only here |
| shipment | freight_invoices.shipment_id | bigquery, d365, databricks, document, excel, files, github, guidewire, iot, kafka, logisticsapi, mqtt, objectstore, postgres, redshift, salesforce, sap, servicenow, sharepoint, tms, whs, yms |
Evidence it holds for the planted anomalies:
- ANOM-1, An overcharged freight invoice.
mysql/02_data.sqlinmysql.zip, look for'INV-90003'(billed_rate_per_mile 3.84). - ANOM-1, An overcharged freight invoice.
mysql/02_data.sqlinmysql.zip, look for'RC-CAR-01-2026'(contracted rate_per_mile 3.25). - ANOM-2, A claim near its filing deadline.
mysql/02_data.sqlinmysql.zip, look for'RC-CAR-01-2026'(claim_window_days 60).
See all connectors at once for the walkthrough across every source.
Download
mysql.zip: 3 files,expected.jsonincluded.
This is one of 25 zips: the 7 streaming types ship as replay recordings instead.
What is in the zip
mysql/01_schema.sqlmysql/02_data.sqlmysql/expected.json
The whole universe is universe.json. manifest.json lists every download with its size and SHA-256, and SHA256SUMS is the same list for sha256sum -c.