DQ + MySQL

DQ supports MySQL 5.7 and above, MySQL 8.x, and MariaDB 10.3+. Managed instances are supported: Amazon RDS for MySQL, Google Cloud SQL for MySQL, PlanetScale (via connection string), and self-hosted instances with network access.

What You Get

• Schema auto-discovery. DQ reads information_schema.tables and information_schema.columns to enumerate all accessible tables. No manual table list required.
• All six quality dimensions. Every profiling run scores completeness, uniqueness, validity, consistency, integrity, and accuracy for every column.
• Referential integrity checks. DQ reads information_schema.KEY_COLUMN_USAGE to detect declared foreign keys and validates their integrity automatically.
• Schedule-based monitoring. Configure per-table schedules. DQ alerts when dimension scores degrade beyond configured thresholds.
• Cross-database consistency. For schemas split across multiple MySQL databases on the same server, DQ supports cross-database consistency rules.

How to Connect

1. Create a read-only MySQL user: CREATE USER 'dq_reader'@'%' IDENTIFIED BY 'your_password';
2. Grant read access: GRANT SELECT ON your_database.* TO 'dq_reader'@'%'; FLUSH PRIVILEGES;
3. In the DQ dashboard, navigate to Datasources → Add New → MySQL.
4. Enter your connection string: mysql://dq_reader:your_password@host:3306/your_database
5. Click Test Connection to verify connectivity and check that DQ can read information_schema.
6. Click Run Profile to start the first profiling run.

For PlanetScale connections, use the PlanetScale branch connection string and add ?ssl={"rejectUnauthorized":true} to the URI. PlanetScale does not enforce foreign key constraints — DQ will infer likely FK relationships from column names and types and surface them for confirmation.

See /pricing for datasource limits per plan and /docs for the full profiling guide.

---

About DQ. DQ is the data quality engine that profiles, validates, and remediates your tables in 90 seconds. Built by K/20X Labs.