Languages

SQL editor & Query builder

Do you need to create complex SQL queries and don't know SQL syntax? Use our powerful query builder and possibly combine it with top SQL editor DATADMIN. Install DATADMIN which works also as data admin and data synchronization tool. What can it make for your business?

Query Builder

DatAdmin query builder is the easiest way how to create SQL queries. It helps you creating complex queries, also you can in comfortably use, even if you don't know SQL syntax.

  • Drag & drop tables and joins
  • Support for left, right, inner and outer join
  • Quick adding referenced table (only by clicking on referencing column)
  • Condition builder with handy conditions not directly supported by SQL (column contains text?, column contains one of string?). You can build complex conditions with AND and OR operators in the some as trivial conditions
  • Saving and loading designed scripts, generating SQL from designed query

SQL Editor

Get powerful SQL editor for your business. Our SQL editor supports unique features making SQL condig easier than even before. What is DatAdmin SQL editor able to:

  • SQL Editor with syntax highlighting
  • Advanced search & replace
  • Scripts folder - you don't have to thing about where you have your scripts
  • Saving query context with query (server, database)
  • Viewing more resultsets from one query
  • Query variables, if you use it, you are asked before every query execute
  • History of executed queries
  • Code completion
  • Inserting SQL join based of foreign key information
DatAdmin query designer
Graphical query design
DatAdmin SQL editor
SQL editor with syntax higlighting