Database Structure
Find Relevant Database Tables
Use Schema Discovery to identify a focused set of tables and columns for a question when you do not know where the information is stored.
Steps
Open Schema Discovery
Choose Schema Discovery from the Write SQL with AI schema options, then select your database system.
Describe the information you need
Explain the intended result in plain English. You do not need to know the database's table or column names.
Review the metadata extraction SQL
SQL Mocker uses the request to generate a database-specific metadata script for likely schema targets. Review and copy the script.
Run the script in your database
Execute the metadata-only SQL in your own database tool using your existing access controls. SQL Mocker does not connect directly to the database.
Attach the metadata results
Export the returned metadata as CSV, TSV, TXT, JSON, or Excel, then attach it in Schema Discovery.
Confirm the relevant tables and columns
SQL Mocker analyses the actual metadata and presents the smallest likely table set with the relevant columns. Check the selection and confirm it when it matches your schema.
Continue to Review Schema
Inspect the confirmed columns, keys, and relationship/ERD map. Review or investigate missing connections there before asking the original question and generating SQL.
Learn more
Guide: Find Relevant Database TablesOpen the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.