What is Outerbase?

Outerbase is the interface for your database, whether you need to query, analyze, visualize, or expose your data to to the world. We're modernizing the tooling around databases that allows you and your entire team to access their data at any time, in a secure, cloud environment.

We simplify database work and boost efficiency. You can collaborate with your team in real-time to speed up tasks. With EZQL, our natural language to SQL agent, querying data is straightforward. You have the option to save these queries for later use. Creating easy-to-read charts is also a breeze. Plus, you can automate your workflows with our Commands.

Traditional tools don't offer this kind of teamwork or automation. Usually, you're on your own, and doing even simple things can take a lot of steps. With Outerbase, you get everything in one place, saving you time and hassle.

Features

Providing an end-to-end database experience that any role in a business can benefit from means there are a lot of features to unbox. Let's take a quick preview into some of the features Outerbase has to offer.

Viewing data

"Table" stakes for any database tool is to have the ability to view the data that resides in your database, and with us you can do that no matter where your database is hosted.

By default we show your database tables in a familiar spreadsheet style view. From here you can edit the data and apply pending changes back to your database quickly and easily.

Plugins

We are introducing a first of its kind plugin interface that can work both independently, taking over the spreadsheet view, or coexist with the spreadsheet table view. Best of all there's an entire marketplace for engineers to develop and share their plugins with the world, and for individuals and businesses to use those creations in their own workspaces.

Table plugins allow you to replace the default table view and re-imagine your data in all new ways. An example of this is maybe your database table has location data of events that are better visualized on a map instead of a spreadsheet. With a click of a button you can change to viewing your data with location-based pins scattered throughout the map.

Column plugins allow you to interact with specific columns of data differently. An example could be that one of your columns is a URL of an image. A plugin could allow you to drag new images into the cells of that column and automatically upload the asset to S3 and update your cells value with the saved image URL.

Querying data

Our built-in SQL query editor allows you to quickly write any execute any SQL statement your database supports and view the results. Whethere you feel comfortable writing SQL on your own, or you prefer asking your database questions in natural language – we have solutions for both.

EZQL

"How many movies were released in the year 2000?"

What if getting a reliable answer was as easy as asking a question? With EZQL it is as easy as that. Outerbase will return you both the SQL statement we interpreted the question into as well as the results from your database so you can ensure the answer given is accurate. Share it with your data team as well to verify its reliability.

SQL Editor

In today's data-driven world, the importance of SQL cannot be overstated. For any team aiming to harness the power of data, understanding and utilizing SQL is not just beneficial—it's essential. Structured Query Language, or SQL, stands as a beacon in the vast landscape of programming languages. Its unparalleled dominance in the database realm is a testament to its efficacy. SQL's strength is its ability to articulate intricate data requests in a clear and efficient manner. Whether extracting specific insights, updating vast records, or orchestrating complex relationships between tables, SQL is the cornerstone of these operations. The products query editor's embrace of SQL further highlights its critical role; mastering SQL is a mandate for anyone aiming to unlock the full potential of their database. With SQL, teams are not merely interacting with data; they are leveraging a powerful language that has, and will continue to, define the trajectory of data management in the digital age.

Data visualizations

Understanding your data while looking at raw output can be quite difficult. Converting raw data into visuals you can easily gleen insights from makes Outerbase a powerful tool for all roles in your team. Using the same SQL query language you use to interact with your database you can now also power your charts directly from it as well – and we make it easy to share with everyone.

Dashboards

Power a variety of charts with a SQL statement or saved query. Dashboards can support any number of charts with a dynamic layout to view all the information you seek. We currently support the following chart types:

• Line
• Bar
• Column
• Pie
• Table
• Single Value

Embeddable Charts

Take your charts and embed them wherever you want. All it takes is a click of a button and copy some text to paste into your project.

Creating API's

Interfacing with your data has more than a single meaning, it is not just a new way to view your data. Outerbase enables teams to create workflows to tunnel data into and out of their databases with our WASM powered multi-language step functions.

Creating an API endpoint can be broken down into logical steps where you can choose the best language for the task each step along the way. In an example where you want to create a "Login" endpoint, maybe one node in the step function would be Javascript to validate all the information is provided and salt the password, then a second node for SQL to check if the username & salted password combination exists in the database, and then a third node to fetch more information to enrich a user profile being returned through the API. Each of those nodes in the previous example can be written in their own language and easily swapped out when your logic needs to change.

We support the following languages:

• Javascript
• Typescript
• Python
• SQL
• Go (coming soon)
• Rust (coming soon)

Data Catalog

The data catalog enriches your experience interacting with your database. When you have business acronyms, verbiage, or language that is only typically sensical to humans when asked but you need the speed and reliability of a machine – that is where the data catalog helps out.

Take the example below where you can define that your favorite movie might be Toy Story. Once defined, you can now ask your database questions on that information and have it return the correct answer.