mysql-list-tables-missing-unique-indexes

About

A mysql-list-tables-missing-unique-indexes tool searches tables that do not have primary or unique indices in a MySQL database.

mysql-list-tables-missing-unique-indexes outputs table names, including table_schema and table_name in JSON format. It takes 2 optional input parameters:

• table_schema (optional): Only check tables in this specific schema/database. Search all visible tables in all visible databases if not specified.
• limit (optional): max number of queries to return, default 50.

Compatible Sources

{{< compatible-sources others="integrations/cloud-sql-mysql">}}

Example

kind: tool
name: list_tables_missing_unique_indexes
type: mysql-list-tables-missing-unique-indexes
source: my-mysql-instance
description: Find tables that do not have primary or unique key constraint. A primary key or unique key is the only mechanism that guaranttes a row is unique. Without them, the database-level protection against data integrity issues will be missing.

The response is a json array with the following fields:

{
  "table_schema": "the schema/database this table belongs to",
  "table_name": "name of the table",
}

Reference