---
title: "MySQL Data Source Template"
slug: "mysql-data-source-template"
updated: 2026-05-07T20:35:54Z
published: 2026-05-07T20:35:54Z
canonical: "docs.validatar.com/mysql-data-source-template"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.validatar.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MySQL Data Source Template

## Overview

The MySQL data source template is a marketplace SQL template for MySQL and MariaDB connections. It provides metadata ingestion scripts that query MySQL's `information_schema` views, data type mappings including MySQL-specific types, and standard profiling definitions using MySQL-compatible SQL expressions.

**Platform:** MySQL (5.7+) / MariaDB (10.2+) **Connection Category:** Database **Template Category:** Marketplace

## What's Included

### Connection Configuration

- Supports MySQL native and ODBC connections
- Identifier delimiters: none (unquoted identifiers)

### Data Type Mappings

Includes mappings for MySQL data types including platform-specific types:

- String types: `varchar`, `char`, `text`, `MEDIUMTEXT`, `LONGTEXT`, `LONGBLOB`
- Numeric types: `int`, `bigint`, `smallint`, `tinyint`, `MEDIUMINT`, `decimal`, `numeric`, `float`, `double`, `real`, `SIGNED`, `UNSIGNED`
- Date/time types: `date`, `datetime`, `timestamp`, `time`, `year`
- Boolean: `boolean`, `bit`
- Binary/Other: `binary`, `varbinary`, `MEDIUMBLOB`, `bytea`
- Enum/Set: `ENUM`, `SET`
- Other: `json`, `uuid`

## Metadata Ingestion

### Schema Level

Queries `information_schema.schemata`, excluding the `information_schema` system schema.

### Table Level

Queries `information_schema.tables` joined with `information_schema.views` to discover base tables and views with view definitions.

### Column Level

Queries `information_schema.columns` to discover columns with data types, ordinal position, nullability, numeric precision/scale, datetime precision, and column comments.

## Profiling

Includes the standard set of ~35 profile definitions using MySQL-compatible SQL expressions, including:

- `CHAR_LENGTH()` for string length calculations
- `REGEXP` for numeric string detection
- `YEAR()` for date year extraction
- `row_number() OVER` for top/bottom value ranking

> **Note:** Median, standard deviation, lower quartile, and upper quartile profiles are disabled by default because MySQL does not natively support `percentile_cont()` or `STDDEV_POP()` as window functions. Enable these if using MariaDB 10.3+ or MySQL 8.0+ with appropriate workarounds.

## Installation

Import from the Validatar Marketplace. Navigate to **Settings > Data Source Templates > Import** and select the MySQL template file.

## Customization

Common customizations:

- **Schema filters** — Exclude MySQL system databases (`mysql`, `performance_schema`, `sys`)
- **Character set handling** — Adjust length calculations for multi-byte character sets
- **Storage engine awareness** — Add engine-specific metadata from `information_schema.tables`
- **Partitioned tables** — Extend ingestion to include partition metadata from `information_schema.partitions`
- **Custom types** — Add data type mappings for application-specific column types

## Related Articles

- [What Is a Data Source Template?](/docs/what-is-a-data-source-template-overview)
- [Metadata Ingestion Scripts — SQL Templates](/docs/metadata-ingestion-scripts-sql-templates)
- [Profiling Configuration — SQL Templates](/docs/profiling-configuration-sql-templates)