Online SQL Client for low code data management


There are many good tools to access and work with relational databases. My favourite one were MS SQL Management Studio and Azure Data Studio. However, there are a number of features that can make exploring, analysing and working with SQL databases much better and easier.

We wanted to go a bit further, beyond a SQL query, beyond simple views or CRUD operations. We wanted to give people tools to leverage SQL robustness and power to allow anybody with fundamental data engineering skills (like citizen developers, business analysts, data analysts and even business people) a low code platform to make robust data management tasks much easier.

We’ve introduced an online SQL client as a core part of WORKSHEETS Data Studio - our low code data management platform. As keeping your data in the database is a fundamental part of any data-centric IT solution.

WORKSHEETS Data Studio can be accessed in your browser straight away. So, to get started you don’t need anything to install.

Short video intro

We do have obvious features, like a tree with data objects, SQL editor with auto-complete, a result panel and everything else you can find in other conventional RMDB tools. However, I would like to highlight the following features:

Share and Collaborate

Since WORKSHEETS Data Studio is a web (browser-based) tool, so sharing and collaboration is a native features. You can create appealing user stories and share to the world with a single URL. An URL, which contains all your filters, sorting and columns, and makes it very useful when you want to share a link. Which will allow other people to see exactly same information as you see it. Obviously, you can permit access to your database for individual users, groups or even grant a public access

Easily navigate and search

WORKSHEET Data Studio layout was inspired by VSCode and you’ll find a lot of similarities e.g. Tabs, Sidebar etc. However, the coolest feature is a search box. A single textbox where you can find and navigate to any database object (table/view/stored procedure) within all databases you are connected to. So, you don’t have to click and scroll anymore. Just type in whatever you are looking for

Data Visualization and Data Analysis

Once you found your table/view you can see data in the excel-like data grids and even plot charts for quick exploratory data analysis and modifications.

Excel-like filter for each column.

By default, we are showing only the first 1000 rows (you can remove this restriction). So, you can use your filters for each column. Here are 2 useful features:

  • A unique list of values
  • You can workout either this column is unique or not

All filters added up and a summary is shown in the bottom left corner

SQL Data Api Components diagram

From the picture above you can tell, that table SampleSupersureSales has 8,399 rows in total. And you can see 821 rows WHERE Customer Segment is 'Small Business' or 'Consumer' and Product Category equal 'Technology'. Also, from the header filter (like in excel) you can get find a breakdown of 21 countries.

Join tables together

We know, how important it is to join things together and get a holistic view of the data. You can effortlessly join or extend tables even if you don't have DDL access. Just use a visual editor. Then effortlessly share with your colleagues or customers with a simple URL

You can use a visual Query Manager to join tables/views, select columns from joined table and specify field expression if needed

Query Manager

Then, from visual query designer, you can generate SQL Query or JSPython code with SQL-Data-Api

Context Menu

Generated SQL Code will look like

Generated SQL Code

Or you can easily plot any table data into graph for a better visibility and story telling

Graph Data

Linked Views

Joining, filtering and customizing your data is an essential data exploration practice. However, sometimes you need to provide an extended view of data. So, you can filter data in the connected views in other browsers.

Linked Views

In this picture you can see that left side browser can control/filter data in 3 other browsers. This is very common use case to explore master details data or any other dependencies.

Import from excel or files

As part of WORKSHEETS Data Studio, you can leverage a low code programming language JSPython or a number of UI tools to comprehensively import data from files or other systems and map them to the table fields

Access your Database via REST API

Your SQL Database will be available through RESTfull API for better integration. We have open source libraries for JSPython, JavaScript, C# and Python

SQL Data Api Components diagram

SQL Data API is a central access point to control access to your databases through a REST API (https). Here is a SQL Data Api JavaScript client or JSPython test harnesses

Role-Based Access Control

On top of existing SQL Security, we add another layer to securely control access to your database for authorised users or public access.

In the cloud or on-premise

The Enterprise version is available for your own servers or in a private/public cloud.

One tool many databases

We are aiming to support all relational databases. At the moment, we have the full support of MS SQL, AzureSQL and PostgreSQL (beta). But, we are going to add MySQL, Oracle etc

SQL Data-Driven Workflow

Automate and streamline SQL Data-Driven Workflow and custom ETL pipelines.

Excel plug-in

WORKSHEETS Data Studio AddIn provides a flexible and controlled way to access and store your spreadsheet data to and from SQL Database

How can I use WORKSHEETS Data Studio

  • Online (run.worksheet.systems). Just type in run.worksheet.systems and you can access any private or public database. Works well with AzureSQL, AWS SQL Google cloud SQL
  • Chrome Extention. Same things, just delivered as a chrome-extention
  • Enterprise. You can have your own version of WORKSHEETS Data Studio behind your firewalls, complied with your security policies etc.
You can try Azure SQL Database free with Azure free account

Conclusion

WORKSHEETS Data Studio simplifies your day to day data management tasks. And makes working with SQL databases with ease, control and confidence.