Skyvia provides advanced SQL support for cloud sources, such as Salesforce, QuickBooks, Dynamics 365, Mailchimp, etc., which don’t support SQL natively. Instead of studying web APIs of each source, you can use familiar SQL statements to access and modify your data.

Our cloud SQL client wraps the specificity of the cloud data source interfaces and greatly extends capabilities of the data access to cloud data sources allowing you to use complex select statements to query data and perform mass cloud data updates with DML statements.

Data in the Cloud? Data in your in-House DBMS? Skyvia can help Manage both or either!

How It Works

Simple queries are directly compiled to web API calls. These API calls are executed by the cloud data source, providing the best performance.

More complex queries are split in parts, and parts of the query are executed against the cloud data source. Our SQL engine processes the results and applies advanced SQL features, used in the query. Returned data are presented to the user.

Query Cloud Data

Immediate Data Access

With Skyvia it’s very easy to select cloud data. Skyvia allows you to quickly select a cloud object, specify filtering and sorting conditions in the query editor in order to get exactly the data you want, execute the query, and retrieve your data.

For example, you can use the SQL query on the screenshot to get all Salesforce customer accounts, ordered by their names.

Support for Advanced SQL Features

Skyvia SQL client is not limited to simple cases like the previous one. Skyvia allows users to create complex SELECT queries with aggregations, SQL functions, etc. to get the data in the format you need — summarized, aggregated, or detailed. For example, look at the SQL query shown in the figure to the left — the query returns total sale amounts grouped in years.

Use the full power of SQL to retrieve your data from the cloud in exactly the form you need it. Make it more efficient to retrieve and analyze your data so your decision-making will be more effective in turn.

Manage Cloud Data

Skyvia fully supports the syntax of INSERT, UPDATE, and DELETE SQL statements for cloud sources. This makes Skyvia a perfect tool to perform mass data update operations on cloud data sources, since you can easily update or delete multiple records with a single update or delete statement.

INSERT

You can use an INSERT statement to quickly create a new record with only the necessary fields filled. The RETURNING clause is supported in INSERT statements. The sample INSERT statement in the figure will create a new Salesforce contact.

UPDATE

With UPDATE statements you can perform mass cloud data updates. Skyvia allows you to preview changes before applying, so the operation is safe. The UPDATE statement in the figure increases all prices in a specific Salesforce Pricebook2 by 5%

DELETE

With a single DELETE statement you can easily delete all the records that satisfy the specified WHERE condition. ID value is not required. The DELETE statement in the figure deletes all Salesforce contacts not assigned to accounts.

Cloud SQL Support in Skyvia Products

Currently Skyvia supports SQL to cloud applications in the Query product. Skyvia Query supports querying cloud data with SELECT statements and managing data via DML statements with changes preview. It allows viewing the returned data in the browser in a grid or as charts and exporting data to various file formats.

Create Queries Easily

Want to query your data but don’t know SQL? Our powerful Query Builder tool can help you to build even complex queries visually via drag-and-drop without typing a line of code. It allows you to focus on data you want to get, automating the query generation. Whenever necessary, you can switch to SQL editor and tweak the generated SQL code if needed.

Key Features

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

Web-Based Query Builder Tool for Visual Query Creation

Create your queries online visually without the need of SQL knowledge

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.

Key Features

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.

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.

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.

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.

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.

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).

Features

Schema Discovery

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

SQL Editor

Use all the power of SQL against both database and cloud app data!

Visual Query Builder

Build 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.

Encryption

All the 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.

Quick Navigation;