schema-exploration

To map database schema, the skill identifies all relational tables, lists their columns and data types, and traces foreign key relationships to outline how data is organized. It provides a complete structure overview including primary keys and sample data.

Discovering table structures involves listing all available tables and inspecting their column names, data types, and key constraints. This skill performs data discovery by applying schema tools to instantly reveal the complete table architecture and sample rows.

Listing all tables and sample data requires querying the database schema to retrieve table names and column definitions. This skill uses sql_db_list_tables and sql_db_schema tools to instantly extract and display table structures alongside sample data.

Yes, you can trace foreign key relationships automatically. This skill maps table relationships by identifying primary and foreign keys, enabling you to plan joins and perform impact analysis without manually inspecting database constraints.

This schema exploration tool works with any connected SQL relational database that supports standard schema queries. It requires an active database connection to list tables, inspect columns, and extract foreign key relationship structures.

Automated schema mapping focuses on structural metadata like columns, data types, and foreign keys. It may not capture business logic or view definitions, so complex data lineage requiring transformation rules might need additional manual documentation.