Getting Started
What is SQL Mocker?
SQL Mocker is an AI-assisted workspace for generating schema-aware SQL and reviewing existing queries without giving the hosted application a direct connection to your database.
Steps
Choose a workflow
Use Write SQL with AI to generate queries from reviewed schema metadata, or Review Existing SQL to explain, check, optimise, and update a query you already have.
Provide the relevant context
For SQL generation, extract, upload, or build the relevant tables, columns, data types, keys, and reviewed relationships. Reviewed relationships include connections defined by the database and suggested relationships confirmed through Investigate Relationships. For existing SQL, paste or upload the query.
Review before use
Inspect and test generated or revised SQL in your own database environment before relying on the results.
Open the relevant SQL Mocker tool
Continue with this workflow in SQL Mocker when you are ready.