exploring-data-catalog

What problem does it solve?

You need a complete, read-only inventory of what data assets exist in your AWS account across Glue Data Catalog, S3 Tables, and federated/remote Iceberg catalogs—along with formats and schema details for governance and planning.

Core Features & Use Cases

• Catalog landscape mapping: Enumerates and classifies catalogs (Glue, S3 Tables, Redshift-federated, Remote Iceberg) so you know where each dataset lives.
• Database and table inventory: Lists databases and tables per catalog, capturing table counts and key metadata.
• Deep schema and quality analysis: For selected scopes, captures schema attributes (columns/types/partitioning/storage locations) to surface missing metadata, stale tables, and unregistered assets.
• Targeted exploration with guardrails: Supports a single optional input (search term, catalog name, database name, S3 path, or table name) while confirming scope before discovery API calls.

Quick Start

Ask the AI to inventory the full catalog landscape in your target AWS region: "Explore the AWS Data Catalog inventory for my account in us-east-1 and summarize catalog types, database counts, and table formats."