Query

What is Query ?

Access your data online, view, export and manage it in the browser

BUILDER MODE

You can create complex queries visually through the drag-and-drop feature without entering code.

SQL MODE

Online SQL Editor.

DATA MODE

This mode is useful for viewing your data in the browser and preparing it for export.

Universal query tool for any data source

Wherever your data is, you can always access and manage it with Skyvia Query:

ON-PREMISES DATABASES

Easily manage data in local Oracle, MySQL, SQL Server, PostgreSQL, and MariaDB databases on the Internet. Connect to them via Secure Skyvia Agent.

CLOUD DATABASES

Access data from different cloud databases and cloud data warehouse services with a cloud tool.

CLOUD APPLICATIONS

Query data from cloud applications as a database. Use filters, joins, groupings, aggregations - all the power of the SQL language.

Easily create queries

Want to query your data but don't know SQL? Our powerful Query Builder tool can help you create visually complex queries by dragging and dropping without typing a line of code. It allows you to focus on the data you want to obtain by automating query generation. Whenever necessary, you can switch to the SQL editor and adjust the generated SQL code if necessary.

MAIN FEATURES

• Type-specific functions
• One-click aggregations
• Typed filters
• Automatic joins and groupings

Resources

SCHEMA DISCOVERY

Explore the schema of your data: tables, relationships, field types.

EDITOR SQL

Use all the power of SQL in database and cloud application data!

VISUAL QUERY BUILDER

Create queries visually - configure joins, filtering, aggregation without a line of code!

EXPORT DATA

View your data in the browser or export it to CSV or PDF.

QUERY GALLERY

Easily save and reuse your queries. See sample queries for common use cases.

CRYPTOGRAPHY

All data transmissions between the service and your browser are securely encrypted with TLS. Data source connections can be encrypted if a data source supports it.

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768