Querying Data Catalog for Integrations

MindsDB exposes collected metadata from connected data sources via virtual tables in the INFORMATION_SCHEMA schema. These views allow users to inspect and query the Data Catalog using familiar SQL syntax.

Available Data Catalog Tables

To filter results for a specific data integration, use WHERE TABLE_SCHEMA = '<integration_name>'.

INFORMATION_SCHEMA.META_TABLES

Provides high-level metadata about available tables in a given integration.

Here are the available columns:

• TABLE_NAME (string): Name of the table.
• TABLE_TYPE (string, optional): Type of table (e.g., BASE TABLE, VIEW).
• TABLE_SCHEMA (string, optional): Schema name or integration name.
• TABLE_DESCRIPTION (string, optional): Description of the table.
• ROW_COUNT (integer, optional): Estimated row count.

Here is how to query it foe a specific data integration:

SELECT * FROM INFORMATION_SCHEMA.META_TABLES 
WHERE TABLE_SCHEMA = 'integration_name';

INFORMATION_SCHEMA.META_COLUMNS

Returns detailed column-level metadata for all tables in the specified integration.

Here are the available columns:

• TABLE_NAME (string): Name of the table.
• COLUMN_NAME (string): Column name.
• DATA_TYPE (string): Data type of the column.
• COLUMN_DESCRIPTION (string, optional): Description of the column.
• IS_NULLABLE (boolean, optional): Whether nulls are allowed.
• COLUMN_DEFAULT (string, optional): Default value, if any.

Here is how to query it foe a specific data integration:

SELECT * FROM INFORMATION_SCHEMA.META_COLUMNS 
WHERE TABLE_SCHEMA = 'integration_name';

INFORMATION_SCHEMA.META_COLUMN_STATISTICS

Provides statistical insights about each column’s values and distribution.

Here are the available columns:

• TABLE_NAME (string): Name of the table.
• COLUMN_NAME (string): Column name.
• MOST_COMMON_VALUES (array of strings, optional)
• MOST_COMMON_FREQUENCIES (array of integers, optional)
• NULL_PERCENTAGE (float, optional)
• MINIMUM_VALUE (string, optional)
• MAXIMUM_VALUE (string, optional)
• DISTINCT_VALUES_COUNT (integer, optional)

Here is how to query it foe a specific data integration:

SELECT * FROM INFORMATION_SCHEMA.META_COLUMN_STATISTICS 
WHERE TABLE_SCHEMA = 'integration_name';

INFORMATION_SCHEMA.META_KEY_COLUMN_USAGE

Describes the primary key columns for tables in the integration.

Here are the available columns:

• TABLE_NAME (string): Name of the table.
• COLUMN_NAME (string): Column name.
• ORDINAL_POSITION (integer, optional)
• CONSTRAINT_NAME (string, optional)

Here is how to query it foe a specific data integration:

SELECT * FROM INFORMATION_SCHEMA.META_KEY_COLUMN_USAGE 
WHERE TABLE_SCHEMA = 'integration_name';

INFORMATION_SCHEMA.META_TABLE_CONSTRAINTS

Lists table-level constraints, including primary and foreign keys.

Here are the available columns:

• TABLE_NAME (string): Name of the table.
• CONSTRAINT_NAME (string, optional)
• CONSTRAINT_TYPE (string): e.g., PRIMARY KEY, FOREIGN KEY

Here is how to query it foe a specific data integration:

SELECT * FROM INFORMATION_SCHEMA.META_TABLE_CONSTRAINTS 
WHERE TABLE_SCHEMA = 'integration_name';

INFORMATION_SCHEMA.META_HANDLER_INFO

Returns a textual summary of the integration implementation, including supported SQL features and capabilities.

Here are the available columns:

• HANDLER_INFO (string): Description.

Here is how to query it foe a specific data integration:

SELECT * FROM INFORMATION_SCHEMA.META_HANDLER_INFO 
WHERE TABLE_SCHEMA = 'integration_name';