skills.rest
mreferre
mreferreCOMMUNITY
Explore all skills by this author →
Website𝕏@mreferreGitHub

exploring-data-catalog

Inventory AWS Glue, S3 Tables, Redshift-federated, and remote Iceberg catalogs.

Updated May 12, 2026
Search Tags:#aws#inventory#data catalog#iceberg#glue#schema audit#s3 tables
One-click install
npx skills add https://github.com/mreferre/aws-agent-toolkit-skills --skill exploring-data-catalog
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: exploring-data-catalog
Source: https://github.com/mreferre/aws-agent-toolkit-skills/tree/main/.kiro/skills/exploring-data-catalog
Command: npx skills add https://github.com/mreferre/aws-agent-toolkit-skills --skill exploring-data-catalog

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

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."

Frequently Asked Questions about exploring-data-catalog

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I inventory my AWS Glue Data Catalog assets across different regions?▼

You can inventory AWS Glue Data Catalog assets by performing a read-only discovery that enumerates catalogs, databases, and tables. The process requires explicit region specification and scope confirmation before executing any API calls.

Can I audit S3 Tables and remote Iceberg catalogs in the same operation?▼

You can audit S3 Tables and remote Iceberg catalogs in the same operation. The discovery process classifies and inventories Glue, S3 Tables, Redshift-federated, and remote Iceberg catalogs together within a single read-only landscape mapping.

How do I list all databases and tables in my AWS data catalog with their schemas?▼

To list databases and tables with their schemas, run a deep schema analysis that captures columns, types, partitioning, and storage locations for selected scopes. This surfaces missing metadata, stale tables, and unregistered assets in human-readable terms.

Does the data catalog audit support targeted searches for specific table names or S3 paths?▼

The data catalog audit supports targeted searches using a single optional input argument. You can provide a catalog name, database name, S3 path, or table name directly or via a pointer file, routing the request to the correct API path.

What are the limitations of running a schema audit on federated data catalogs?▼

Running a schema audit on federated catalogs requires read-only discovery behavior with dependency and tool verification including CLI fallback. Large result sets require explicit pagination handling via next-token propagation to complete the inventory successfully.

Related Skills

Explore More Data & Analytics Skills→
mreferremreferre

creating-data-lake-table

Create managed Iceberg tables on Amazon S3 Tables with Glue catalog registration.

Community
Advanced
TruCol270TruCol270
1

gsd-audit-uat

Audit UAT and verification items across project phases to generate a prioritized test plan.

Community
Advanced
AndreKuraitAndreKurait

finding-data-lake-assets

Resolve data-lake asset references across Glue Data Catalog, S3, and Redshift.

Community
Advanced
samChang72samChang72
1

ads

Audit and optimize paid advertising campaigns across multiple platforms.

Community
Advanced