Query designer, ER diagrams

DbGate has several designers and data visualisation tools, allowing you exploring your DB model, query data without SQL knoledge or create nice charts.

SQL query designer

Powerful classic SQL design - design your SQL queries visually

Use various JOIN types - besides standard SQL joins (INNER, LEFT…), you could use some pseudo-joins (most usable is WHERE NOT EXISTS)

Use powerful filters - use the same filtering engine as for data browser - with support of compoud conditions and filtering by set of values

Great performace - the result is SQL query, so the performance is the same as when writing SQL query by hand

Quick database diagrams

Show table relations or show structure of the full database

Change colors for table and define logical group of tables

Customize columns - define columns, which are shown - all columns, not null columns, columns from primary key

Customize attributes - configure diagrams to show data types or NOT/NOT NULL flag

HTML export - export diagram to simple HTML page

Advanced data visualisation

View cell data in various formats - formatted XML and JSON, raw text data, image

Show Map for GEO data - show maps for spatial data containing GEO locations

Charts - create charts from your query result

Universal query designer - perspectives

Support different data sources - join data from SQL database tables or MongoDB collections

Hiearchic view - view data in hiearchically

Runs on client side - is not limited by source data provider as classic SQL query designer