Documentation category

Database Structure

Add, review, and maintain the tables and columns used by a workspace.

Extract Database Metadata

Generate a metadata script, run it in your own database tool, and return the structural results to SQL Mocker.

Create schema context by entering tables, columns, data types, keys, and relationships yourself.

Upload a schema, metadata file, spreadsheet, or supported source file and review the structure SQL Mocker detects.

Extend a workspace with selected tables and columns from additional database metadata.

Confirm that imported tables and columns accurately represent the database structure needed by the workspace.

Reduce workspace scope by removing schema columns that are not needed for SQL generation or query logic.