Query editor

Use powerful SQL and noSQL code editor, view and visualize results.

Writing SQL queries

Syntax highlight - with many highlight color themes

Code completion - see table, column and SQL syntax suggestions as you type

Save queries for later - save queries to “Saved queries” widget with a name, edit and run saved query

SQL formatter - format SQL queries

SQL Generator

Choose multiple objects - choose which tables, view and procedures to generate

Choose which scripts to generate - you could generate CREATE, DROP or INSERT DATA scripts

Live preview - view your script preview immediately

Many options - configure eg. whether to create foreign keys or indexes with your tables

AI Assistant

Text to SQL - describe your query, DbGate will generate SQL query for you

Code completion - insert snippet on cursor

Change query - modify your query from task in natural language

Use any language, which is supported by OpenAI (almost all languages - English, French, German, Spanish, Portuguese, Italian, Japanese, Chinese, Korean, etc.)

And much more

Join wizard - add SQL joins, when you are master of SQL language, but you don’t remember all of those tables, which must be joined together