---
sourceDocument: Brazil Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# MySQL metadata collector

# MySQL metadata collector {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
The MySQL metadata collector provides read-only access to metadata from an external MySQL database.

This collector is designed to directly harvest metadata from your MySQL server. It is suitable for both self-hosted MySQL instances and managed MySQL instances, such as those hosted on AWS RDS. This collector also works with MariaDB
instances.

## Metadata cataloged {#mysql-metadata-collector__section_fq3_4cp_13c}

The collector catalogs the following information.
{#mysql-metadata-collector__table_msp_rcp_13c__entry__2}

| Object | Information cataloged |
|-|-|
| Columns | Name, Description, JDBC type, Column Type, Is Nullable, Default Value, Key type (Primary, foreign), column size, column index |
| Table | Name, description, primary key, schema |
| Table Index | Index Cardinality, Column name, Index Type, Index Name, is non Unique, Ordinal Position, Pages, Sort Sequence |
| Views | Name, description, SQL definition |
| Schema | Identifier, Name |
| Database | Type, name, identifier, server, port, environment, JDBC URL |
| Function | Name, Description, Function Type |
| Stored Procedure | Name, Description, Stored Procedure Type |
[Table 1. Metadata harvested]

{#mysql-metadata-collector__table_msp_rcp_13c}

If you include the profiling and sampling specific parameters while running the collector, the following additional information is harvested for Columns.  
Note:  
The user/role must have read access to data to be able to harvest profiling information (column statistics).
{#mysql-metadata-collector__table_bvx_ddp_13c__entry__2}

| Object | Information cataloged |
|-|-|
| Column | * Average Length (sample) * Average Value (sample) * Data Distribution * Distinct Values * Estimated Distinct Values * Estimated Non-null Values * Maximum Length (sample) * Maximum Value (sample) sorted numerically or alphabetically (z-a) * Minimum Length (sample) * Minimum Value (sample) sorted numerically or alphabetically (a-z) * Non-null Values (sample) * Sample String Values (first 5 items in a column) |
| Table | * Row Count * Sample Count (Target sample size) |
[Table 2. Profiling and sampling specific information]

{#mysql-metadata-collector__table_bvx_ddp_13c}

## Relationships between objects {#mysql-metadata-collector__section_gln_4cp_13c}

The harvested metadata includes catalog pages for the following data asset types. Each catalog page has a relationship to the other related data asset types.
{#mysql-metadata-collector__table_yfq_mdp_13c__entry__2}

| Data asset page | Relationship |
|-|-|
| Table | Columns, Table Indexes |
| Columns | Table |
| Schema | Database that contains Schema, Table that is part of Schema |
| Database | Schema contained in Database |
[Table 3. Relationships between harvested data asset pages]

{#mysql-metadata-collector__table_yfq_mdp_13c}

## Authentication supported {#mysql-metadata-collector__section_ztr_4cp_13c}

The MySQL collector supports username/password authentication to MySQL.
* **[Prepare to run the MySQL collector](https://www.servicenow.com/docs/epluPqudcEiYWsaZkJp8cg)**   
  Create a MySQL user and grant permissions before running the collector.
* **[Create a MySQL metadata collector](https://www.servicenow.com/docs/cPT7GYtxBJ92yl4DE89mKA)**   
  Create a collector to import metadata from MySQL.