Web-Based Query Builder Tool for Visual Query Creation

Create your queries online visually without the need of SQL knowledge

banner

  • Connector

    It’s your on-premise or cloud app source

  • Object list

    Explore the schema of your data

  • Details

    Configure joins, filtering, aggregation without a line of code

  • Export

  • Result pane

Our online SQL Query Builder has intuitive and easy-to-use interface, and you won’t need any SQL knowledge to work with it.It isn’t SQL-centric, you just select which data you want to get, apply functions and aggregations to them, configure sorting and filtering, and that’s all. All this is configured visually, and you won’t need to type a line of code. Skyvia Query is a tool that allows both experts and novice users to get the necessary data from any of the supported cloud applications and databases. For experts it offers all the power of SQL language, and if you don’t know SQL, you can use visual Query Builder to generate a query automatically.

Whenever necessary, you can switch to SQL code editor and tweak the generated SQL code if you need.

Read More

Key Features

1

Aggregations

Aggregations can be configured in one click — just select the field and click the aggregation function to apply. The result is automatically grouped by non-aggregated fields.

2

Type-specific Functions

These functions are type-specific — for example, for date/time fields you can select a date part, or even a separate month, year, or day parts.

3

Automatic Joins

With our visual Query Builder you can simply browse data relations and add columns from related tables to a query, and we add joins by these relations automatically.

4

Easy Sorting

Just drag a field to the sort field area to sort result by this field. You can change sort order in one click. You also can sort data by as many fields as necessary.

5

Typed Filters

Type-specific filter editors for different field types allow you to configure filters effortlessly. For string fields you can pick values from the data source and filter data by a list of these values.

6

Filter Groups

You can add as many filters as you need and unite them into filter groups. Filter groups consist of several filters and/or subgroups, united with a logical operator (AND or OR).