Back to all prompts
Discovery & Exploration

Schema Discovery

Map available data when onboarding, exploring unfamiliar databases, or kicking off an analytics project.

Prompt Template

Copy Template

Show me the structure of [DATABASE.SCHEMA]:- List all tables with row counts- Identify relationships between [TABLE_A] and [TABLE_B]- Suggest potential join keys- Highlight tables suitable for [USE_CASE]

Industry Example

Copy Example

Show me the structure of CLINICAL_DATA.PATIENT_RECORDS:- List all tables with row counts related to patient encounters and diagnoses- Identify relationships between PATIENT_VISITS, LAB_RESULTS, and PRESCRIPTIONS tables- Suggest potential join keys for creating a unified patient timeline view- Highlight tables suitable for building a readmission risk model

Prompt Details
Category
Discovery & Exploration
Use Cases
Discovery & Exploration