Getting Started
Create or Review Your First SQL Query
Follow the workflow that matches whether you want to generate a new query or work with SQL you already have.
Write SQL with AI
Generate a new query from reviewed database structure and a natural-language question.
Add and confirm the schema
Extract, upload, or build the relevant tables and columns, then review their data types, keys, and database-defined relationships.
Investigate missing relationships
Open Relationships Overview. If expected tables remain disconnected, use Investigate Relationships to review and confirm evidence-based suggestions before generating SQL.
Describe the result
State what each result row should represent, including the required measures, groupings, filters, date range, and output fields.
Select exact schema fields
Use Find schema fields while writing prompts when a business term could map to more than one table or column.
Review and test
Inspect the generated SQL and dummy-data preview, then test the query in your own database environment before use.
Review Existing SQL
Start from a query you already have and ask SQL Mocker to explain, check, or revise it.
Add the existing query
Paste the SQL into Review Existing SQL or upload a supported SQL or text file.
Choose what you need
Select a predefined task or ask the assistant to explain, review, optimise, troubleshoot, or update the query.
Provide relevant context
Describe the intended result and any requirements the assistant should preserve, such as filters, calculations, output fields, or database dialect.
Review the response
Check the explanation, findings, and complete revised SQL against the original query intent.
Test before use
Run the reviewed query in your own database environment and verify its results before relying on it.
Learn more
Guide: Generate SQL from database schema metadataChoose a SQL Mocker workflow
Select the workflow that matches your starting point.