{"schemaVersion":"1","contentVersion":"2026-11-01.13","slug":"system-explorer-database","title":"Database","summary":"Use schema diagrams, SQL, visual queries, exports, and recovery tools in Database Studio.","category":"System Explorer","manual":true,"minutes":6,"prerequisites":[],"technical":[],"sources":["Live Rumata workspace reviewed October 15, 2026; controls inspected without modifying resources."],"related":["controls-database-tables"],"sections":[{"id":"before-you-start","title":"Before you start","blocks":[{"type":"paragraph","text":"Open your factory workspace and go to **System Explorer → Database**."},{"type":"paragraph","text":"You'll find four main tools:"},{"type":"list","items":["**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."]},{"type":"note","title":"Good to know","text":"Your database stores information in tables. Each table contains columns describing the information and rows containing the actual records. Relationships connect information across different tables."}]},{"id":"topic-0","title":"1. Explore tables and relationships","blocks":[{"type":"paragraph","text":"The Tables view helps you understand how your application's data is organized."},{"type":"paragraph","text":"Instead of reading database code, you can explore an interactive diagram showing your tables, columns, and how they connect."},{"type":"steps","items":["Open System Explorer → Database → Tables.","Use Find table or column to search for specific information.","Click Choose visible tables to focus on the tables you want to explore.","Use Arrange diagram, Fit diagram, or the zoom controls to adjust the view.","Click Inspect on a table to see its columns, data types, and relationships."]},{"type":"paragraph","text":"You can also:"},{"type":"list","items":["Export diagram: Download a copy of your database diagram.","Refresh database schema: Update the diagram after making changes to your database structure."]},{"type":"heading","text":"Check your result"},{"type":"paragraph","text":"You should be able to identify the tables in your application, understand what information they contain, and see how they relate to one another."},{"type":"note","title":"Tip","text":"Changing the diagram layout or hiding tables from view doesn't change or delete your actual data. Your diagram layout is saved in your browser."}]},{"id":"sql","title":"2. Work in SQL Editor","blocks":[{"type":"paragraph","text":"The SQL Editor gives you direct access to your database using SQL (Structured Query Language)."},{"type":"paragraph","text":"You can use it to find information, analyze records, and run custom database queries."},{"type":"steps","items":["Select SQL Editor and wait for the database connection to be established.","Click New to start a query, or open Saved queries to continue working on an existing one.","Enter your SQL in the SQL query editor. You can use the schema sidebar to check table and column names.","Review your query, then click Run or press Ctrl/⌘ + Enter.","Review the results displayed below the editor.","If needed, click Export results as CSV to download the results, or Save to reuse the query later."]},{"type":"heading","text":"Example"},{"type":"paragraph","text":"To view the first 10 records in a customers table, you could use:"},{"type":"code","language":"sql","text":"SELECT *\nFROM customers\nLIMIT 10;"},{"type":"paragraph","text":"This retrieves information without changing anything in your database. Replace customers with an actual table name from your application."},{"type":"note","title":"Important","text":"Some SQL commands, including UPDATE, DELETE, and structural changes, can modify or remove real application data. Always review your query before running it, especially when working with a production database."},{"type":"paragraph","text":"Saving a query does not execute it."}]},{"id":"builder","title":"3. Build a query visually","blocks":[{"type":"paragraph","text":"Don't know SQL? No problem!"},{"type":"paragraph","text":"The Query Builder lets you search and filter your database using visual conditions. Rumata generates the SQL for you based on your selections."},{"type":"steps","items":["Select Query Builder.","Choose the table you want to explore using Select Table.","Click + Rule to add a condition, such as finding customers from a specific city.","Use + Group to combine multiple conditions when needed.","Choose AND when all conditions should match, or OR when any condition can match.","Set Limit Results to control how many records are returned.","Click Generate SQL to preview the generated query.","Review the SQL, then select Run Query to see the results."]},{"type":"heading","text":"Example"},{"type":"paragraph","text":"Imagine you want to find all customers from London who have an active subscription."},{"type":"paragraph","text":"You could create two rules:"},{"type":"list","items":["City equals London","Subscription status equals Active"]},{"type":"paragraph","text":"Connect them using AND, and Query Builder will generate the corresponding SQL."},{"type":"heading","text":"Check your result"},{"type":"paragraph","text":"You should see records matching your selected conditions."},{"type":"note","title":"Tip","text":"Start with a small result limit, especially when working with large databases. Use only the information you need."}]},{"id":"operations","title":"4. Monitor capacity and export data","blocks":[{"type":"paragraph","text":"Your database needs storage and computing resources to keep your application running."},{"type":"paragraph","text":"The Operations section gives you visibility into how those resources are being used and provides access to management tools."},{"type":"steps","items":["Go to Database → Operations.","Review Database operations and Capacity & recovery.","Check the available information about storage, database state, service class, and compute mode.","If needed, open Manage capacity or Idle hibernation to review the available settings."]},{"type":"paragraph","text":"These tools help you understand your database's current resource configuration and whether any adjustments may be needed as your application grows."},{"type":"paragraph","text":"You can also download a copy of your application's database."},{"type":"steps","items":["In Operations, locate Download SQL export.","Click the download option.","Wait for the export to finish and save the file securely."]},{"type":"paragraph","text":"The export contains your factory's database structure and records in a compressed SQL file."},{"type":"note","title":"Good to know","text":"Database exports count toward your account's download allowance. Exporting doesn't take your database offline, and the compressed download size may differ from the storage your database uses."}]},{"id":"recovery","title":"5. Understand backups and recovery","blocks":[{"type":"paragraph","text":"Rumata provides database backup and recovery tools to help protect your application's information."},{"type":"paragraph","text":"You can review available recovery points, create backups, and recover data when needed."},{"type":"steps","items":["Open Database → Operations.","Find Data protection.","Review the available recovery window and displayed timezone.","Click Create backup when you need an additional recovery point.","Check Operation history to confirm the result."]},{"type":"paragraph","text":"The available recovery window depends on your plan and the recovery points verified by the backup service."},{"type":"paragraph","text":"If you need to restore your database:"},{"type":"steps","items":["Open Data protection and select Recover database.","Review the available recovery points.","Carefully check the recovery scope and confirmation details.","Confirm the recovery only when you're sure it's the intended action.","Monitor Operation history until the operation finishes.","Verify that your application's data and main features work as expected."]},{"type":"note","title":"Important","text":"Database recovery can affect existing data. Review the selected recovery point and its implications before confirming. If you're unsure, create a backup and consult your technical team or [Rumata Support](https://rumata.dev/contact) before proceeding."}]},{"id":"next-steps","title":"Keep exploring Database Studio","blocks":[{"type":"paragraph","text":"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."},{"type":"paragraph","text":"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."}]}],"updated":"2026-09-29","audience":"general","media":[{"src":"https://docs.rumata.dev/media/system-explorer/database-tables.png","sectionId":"topic-0","width":1539,"height":1022,"alt":"Database Studio’s Tables diagram and relationship controls.","caption":"Database Studio’s Tables diagram and relationship controls. Illustrative interface reference; your resources and values may differ."},{"src":"https://docs.rumata.dev/media/system-explorer/database-query-builder.png","sectionId":"builder","width":885,"height":700,"alt":"Build query conditions and review the generated SQL before running.","caption":"Build query conditions and review the generated SQL before running. Illustrative interface reference; your resources and values may differ."},{"src":"https://docs.rumata.dev/media/system-explorer/database-operations.png","sectionId":"operations","width":1529,"height":1028,"alt":"Operations groups database capacity, export, and recovery tools.","caption":"Operations groups database capacity, export, and recovery tools. Illustrative interface reference; your resources and values may differ."}],"video":null,"url":"https://docs.rumata.dev/guides/system-explorer-database"}