For AI agents: A markdown version of this page is available at https://docs.datadoghq.com/ddsql_reference/data_directory/dd/dd.mysql_tables.dataset.md. A documentation index is available at /llms.txt.

MySQL Tables

The MySQL Tables table provides metadata about database tables discovered in MySQL databases. Each row represents a table and includes information such as columns, indexes, foreign keys, partitioning, and storage engine. This table enables you to inventory database schemas, track table modifications, analyze table structures, and monitor database metadata across your MySQL infrastructure.

dd.mysql_tables

Fields

TitleIDTypeData TypeDescription
Key_keycorestringUnique identifier for the MySQL table record.
Table Nametable_namecorestringName of the database table.
Display Namedisplay_namecorestringHuman-readable display name for the table.
ColumnscolumnscorejsonJSON array containing column definitions including name, data type, nullability, and default values.
IndexesindexescorejsonJSON array containing index definitions including name, columns, and uniqueness.
Foreign Keysforeign_keyscorejsonJSON array containing foreign key constraints and referenced tables.
EngineenginecorestringStorage engine used by the table (e.g., InnoDB).
Row Formatrow_formatcorestringRow storage format (e.g., Dynamic).
PartitionspartitionscorejsonJSON array containing partition definitions.
Create Timecreate_timecoretimestampTimestamp when the table was created.
MySQL Logical Database Keymysql_logical_database_keycorestringUsed to join this table to dd.mysql_logical_databases to get database name and walk the hierarchy (table to logical database to database instance).