schema-exploration

Map database schema by listing available tables and describing columns, data types, primary keys, and foreign keys. This process traces parent-child join paths to support relational database query building and data discovery.

Discover foreign key join paths by identifying Id-suffixed foreign key columns and tracing parent-child chains. This maps table relationships, clarifying which tables to join and what keys to use for analytics workflows.

List all tables and inspect column data types by applying schema discovery tools to the relational database. This produces clear summaries of table purposes, column names, primary keys, and sample rows to orient users to the dataset.

Exploring database structure and sampling rows requires access to sql_db_list_tables and sql_db_schema tools. These tools enable the extraction of table schemas, column data types, and short sample rows to illustrate content.

Sample rows from tables while mapping database schema to illustrate content alongside column names and data types. This provides immediate context for the data stored within specific tables during the data discovery process.

Schema exploration for data discovery is limited to relational databases and relies strictly on sql_db_list_tables and sql_db_schema tools. It focuses on structure and sampling rather than executing complex data transformations or analytics queries.