Railway has a built-in Database Management Interface, this allows you to perform common actions on your Database such as viewing and editing the contents of your database services in Railway. The interface is available for all database services deployed within a project.
We expose two high level administrative actions through the interface for database services.
- Reset Database Credentials
- Wipe Database Data
For MySQL and Postgres, Railway displays the tables contained within an instance by default; this is called the Table View.
Shift-clicking on one or multiple tables exposes additional options such as the ability to delete the table(s).
Creating a Table
Under the Table View, clicking the Create Table button at the bottom right of the interface navigates users to the Create Table interface.
For each column a user wants to add to the database, the interface accepts a
constraints. Depending on the SQL database that is used, valid types and constraints may vary.
Viewing and Editing Entries
When a table is clicked, the interface navigates into the Entries View.
Under the Entries View, selecting an existing entry exposes the ability to edit the entry. When button that allows one to add entries to the table.
Add SQL Column
Selecting the add column in the entries view opens a modal that prompts you to add a new column to the table.
Raw SQL Queries
Under the Query tab - there is an option to input raw queries against your SQL databases with context-aware autocompletion. (Currently only available for Postgres)
For non-structured data, Railway has interfaces that permit users to add and edit data within the service.
With Redis, Railway displays the keys contained within a database instance by default.
MongoDB Document View
With MongoDB, Railway displays a list of document collections. Users can add additional collections or add/edit documents within the collection.
Adding MongoDB Databases
Within the Collections View, clicking the plus icon next to the top dropdown allows you to create a new Database.
Edit this file on GitHub