Data Viewer

Introduction

During the development and testing process, there is sometimes the need to view the data in the database being used to validate and debug api outputs, or to construct access operations. Neurelo offers a handy data viewer inside environments to quickly view data from the database attached to the environment.

Also, the Data Viewer uses the same API key to access the data as you would use in your API/SDK calls to Neurelo, which makes it easier to confirm and validate, or debug the data you are working with when using the key. Any access control policies applied to the API Keys will also be enforced.

This feature is supported for PostgreSQL, MySQL, and MongoDB

Video Guide

If you prefer a more visual experience, please check out this video overview for this feature

Using the Data Viewer in an environment

Loading the Data Viewer

Step into your project from Neurelo's dashboard and navigate to the Environments section of your project using the left side navigation bar.

Select the Environment you wish to use and you will find the “Data Viewer” button on the environment card. Click the “Data Viewer” button to take you to the "Data Viewer" tab under Environment Detail Page.

The data viewer feature needs the environment to be running before you can use it. Please make sure the runners for the environment have been started. You can validate the runner status from the status dot next to the environment name -- green means running, red means stopped, and orange means they are in the process of being deployed.

Make sure the environment is using the commit with the schema you are working on, has all migrations applied and is using the database that you want to view.

To use the Data Viewer, you need a valid API Key. If no API Key has been configured for the data viewer, you will see this message: “Please enter a valid API Key to view data” and the “Enter API Key” button will be shown. Click on this button to see API Key dialog box for Data Viewer.

If you already have an API Key for your environment, you can paste it into the displayed input box. If not, you can click the “Plus” button inside the input box to create a new API Key. Now you can hit the “Save & Apply” button. This will refresh the page and you will be able view the data from your tables and collections.

If you do not have any data, you can check our “Data Generator” feature to populate your data source with some random data to get you started.

Hide Columns

This feature lets you hide selected fields from your table view, you can view them later by simply un-checking the column name.

Rows per page

• This feature is a select box that lets you configure how many rows are fetched and displayed on a single page.

• By default, 20 rows per page will be displayed

Pagination

• Displayed data is paginated and you can click on the right and left arrows to view the previous or next page respectively.

• It also lets you input a page value directly. Click the current page number to view an input box. You can directly navigate to any page and click outside the input box to apply changes.

• When the input box is focused, you can click up or down to increase or decrease page number respectively.

Long values inside the table cell

• Long values inside displayed cells will be auto truncated. To see the fulls values inside your “Data Viewer” table, you can click the cell to expand the value in a scrollable section.

• To collapse and view the previous state, click the expanded cell.

Refresh Data

• At times when you are testing your application you might need to reload the displayed data to view updated results.

• For this you can use the “Refresh Data” button located above the content section of “Data Viewer”

• Clicking on this button will instantly reload data without the need to refresh the page.