Database

Open your factory workspace and go to System Explorer → Database.

You'll find four main tools:

• Tables: Explore your database structure and relationships visually.
• SQL Editor: Write and run SQL queries directly.
• Query Builder: Find and filter information without writing SQL yourself.
• Operations: Monitor database resources, export data, and manage recovery.

The Tables view helps you understand how your application's data is organized.

Instead of reading database code, you can explore an interactive diagram showing your tables, columns, and how they connect.

1. Open System Explorer → Database → Tables.
2. Use Find table or column to search for specific information.
3. Click Choose visible tables to focus on the tables you want to explore.
4. Use Arrange diagram, Fit diagram, or the zoom controls to adjust the view.
5. Click Inspect on a table to see its columns, data types, and relationships.

You can also:

• Export diagram: Download a copy of your database diagram.
• Refresh database schema: Update the diagram after making changes to your database structure.

Check your result

You should be able to identify the tables in your application, understand what information they contain, and see how they relate to one another.

The SQL Editor gives you direct access to your database using SQL (Structured Query Language).

You can use it to find information, analyze records, and run custom database queries.

1. Select SQL Editor and wait for the database connection to be established.
2. Click New to start a query, or open Saved queries to continue working on an existing one.
3. Enter your SQL in the SQL query editor. You can use the schema sidebar to check table and column names.
4. Review your query, then click Run or press Ctrl/⌘ + Enter.
5. Review the results displayed below the editor.
6. If needed, click Export results as CSV to download the results, or Save to reuse the query later.

Example

To view the first 10 records in a customers table, you could use:

This retrieves information without changing anything in your database. Replace customers with an actual table name from your application.

Saving a query does not execute it.

Don't know SQL? No problem!

The Query Builder lets you search and filter your database using visual conditions. Rumata generates the SQL for you based on your selections.

1. Select Query Builder.
2. Choose the table you want to explore using Select Table.
3. Click + Rule to add a condition, such as finding customers from a specific city.
4. Use + Group to combine multiple conditions when needed.
5. Choose AND when all conditions should match, or OR when any condition can match.
6. Set Limit Results to control how many records are returned.
7. Click Generate SQL to preview the generated query.
8. Review the SQL, then select Run Query to see the results.

Example

Imagine you want to find all customers from London who have an active subscription.

You could create two rules:

• City equals London
• Subscription status equals Active

Connect them using AND, and Query Builder will generate the corresponding SQL.

Check your result

You should see records matching your selected conditions.

Your database needs storage and computing resources to keep your application running.

The Operations section gives you visibility into how those resources are being used and provides access to management tools.

1. Go to Database → Operations.
2. Review Database operations and Capacity & recovery.
3. Check the available information about storage, database state, service class, and compute mode.
4. If needed, open Manage capacity or Idle hibernation to review the available settings.

These tools help you understand your database's current resource configuration and whether any adjustments may be needed as your application grows.

You can also download a copy of your application's database.

1. In Operations, locate Download SQL export.
2. Click the download option.
3. Wait for the export to finish and save the file securely.

The export contains your factory's database structure and records in a compressed SQL file.

Rumata provides database backup and recovery tools to help protect your application's information.

You can review available recovery points, create backups, and recover data when needed.

1. Open Database → Operations.
2. Find Data protection.
3. Review the available recovery window and displayed timezone.
4. Click Create backup when you need an additional recovery point.
5. Check Operation history to confirm the result.

The available recovery window depends on your plan and the recovery points verified by the backup service.

If you need to restore your database:

1. Open Data protection and select Recover database.
2. Review the available recovery points.
3. Carefully check the recovery scope and confirmation details.
4. Confirm the recovery only when you're sure it's the intended action.
5. Monitor Operation history until the operation finishes.
6. Verify that your application's data and main features work as expected.

With Database Studio, you can understand how your application's data is structured, find the information you need, monitor database resources, and manage backups—all without leaving Rumata.

You don't need to use every tool right away. Start with the visual Tables view and explore the more advanced capabilities whenever you need them.