Free SQL Virtual Database Emulator

[Pablo Beltran]

SQL Virtual Database Emulator

I'm exiting to introduce this new web app allowing you to read and manage your ServiceNow instance data with standard SQL from your preferred browser!

Short Video Demo

https://www.youtube.com/watch?v=-N3mGzpqY6Q

Overview

This is a Relational Database Emulator:

• It supports CRUD: Insert, Select, Update and Delete.
• It does not support ACID transactions.

Full featured SQL console is provided with:

• syntax highlighting 
• code autocompletion (Shift+Space on Windows)

Other features

• 100% Javascript: t is powered by the popular AlaSQL library with a little of re-engineering.
• No JDBC Driver required. 
• Easy configuration: please open the documentation link and follow the instructions.
• Nothing is installed on your ServiceNow instance.
• Internally Select statements are translated into GraphQL queries. Insert, Update and Delete commands are translated into TableAPI (REST) calls.
• You may want to allow Read only (Select) mode and deactivate Write commands via configuration.
• All tables are virtual: they have no data and are populated in real-time with the minimal data required to answer the SQL query.
• Unique asynchronous database in the World!

Support

The project is officially unsupported, but you can try to contact me out at: pbeltranl@marketplace.expert

Data privacy and Security

• No data is shared with any third-party. The JavaScript database emulator library is loaded in your browser and all the traffic occurs between the library (your browser) and your ServiceNow instance.
• ServiceNow permissions and business rules are respected: users can read and (optionally) modify granted data in ServiceNow previously in the regular way only.
• The ServiceNow API Token is stored in your browser (local storage)

Scalability

• It has been designed to run at scale: every web page runs its own virtual database instance isolated from the rest. 
• Close the web page to stop and destroy the virtual database emulator. It is recreated in a few seconds every time the web page is opened.
• Quotes are honored as it runs on top of official APIs provided by ServiceNow.
• Tables are cached during first start up (it may take a while)

Enjoy!

Link to the application

[lisa2410]

Interesting 

[neverbenfamous]

Thanks for sharing!