AI SQL generator
Describe the query in plain language and get the SQL ready
The assistant reads your database structure, including tables, columns and keys, and writes the SQL query that answers your request. You review, edit and apply.
7 days free · Cancel before the trial ends and pay nothing
From request to SQL
-
Pick the tables
Choose the tables that give context to your request in the explorer.
-
Describe what you need
Write it in plain language, or use a suggestion generated from the columns.
-
Review and apply
Check the generated SQL, edit it if you like and apply it in the editor.
AI understands your database structure
The explorer shows schemas, tables, views, columns, primary and foreign keys. AI uses that structure to write joins and filters that make sense for your data.
- Tables, views and columns
- Primary and foreign keys
- Prompt suggestions per table
Refine the query you already have
Turn on refinement and ask for changes to the SQL in the editor, like adding a column, grouping by month or filtering a period.
- Incremental changes
- Draft saved to continue later
- Test with the first rows
Read-only by default
Queries run by the assistant are validated as read-only and row-limited. Connection credentials never show up in the chat.
- Server-side read-only validation
- Row-limited samples
- Protected credentials
Frequently asked questions
Which databases does the generator support?
Hubviz Studio database connections: SQL Server, PostgreSQL, MySQL, Oracle, Firebird, SAP HANA and ODBC.
Does the generated SQL run straight on the database?
You review it before applying it in the editor. Queries run by the assistant are read-only.
Do I need to grant write access?
No. We recommend a database user with read-only permission.
See all your company numbers in one place this week
You get 7 free days to connect your sources and build your first dashboards.