First steps

How to add a new database

You have created your account on StationDB, now let's see together how to add your first database.

Start by clicking on "New database" on the left panel or on the "Add a database" CTA.



A modal will open, where you can choose the name you give to your database. This is the name that will be displayed on the StationDB interface.



After you click on "Create", the "Database Settings" page will open.
If you're using a private database, think about adding our IP to the authorized ones. If not, skip this step, and choose your driver in the dropdown menu.



Then, fill in the information that will help us authenticate your database.
In Host: include the link to your database
In Database: fill in the name of your database
Username and Password are your identifiers
Then indicate your Port number
For further security, you can choose to Enable SSL using the drop down menu



You can choose to only Enable SSL using the drop down menu, or you can choose to go further by using Custom SSL Certificates. You'll have the option then to upload your Key and/or certificates.

Click on Save to complete the process.




If all the fields have correct information, we will be able to connect to your database, and all the tables and fields will be displayed as in the example below:

Getting to know the interface

Once you have successfully added this database, this is what your admin panel will look like. Let's have a look together!





1- This left panel shows all tables within your database
2- This part displays the table selected on the left panel. You can scroll horizontally to see all columns of your table
3- The search field will allow you to look for information on every field of the displayed table
4- This feature will allow you to filter all fields, regardless of their type




5- The "Media" dropdown allows you to select the columns that you'd like to see interpreted. These columns can be links, images, videos or audio




If you select a column that stores links to images, this is what it would look like:




6- In this dropdown, you can select the columns that you'd like to be shown





7- Allows to choose the number of rows displayed
8- The "Sheet" button allows you to:
Import a CSV file to add records to your table (in your CSV, you must have at least all the columns of your table, the column names must match, but the column order is not important)
Export a CSV file of the table you're viewing. If the filters are on, you will have the same filtered table in your resulting CSV




9- The "Create" button will enable you to add a new entry to your table by filling in the required fields



10- This button is used to modify already existing fields in the table



11- This button is used to permanently delete a row of the table



Last but not least, use the highlighted section to switch between your team's projects, or to add a new one:




Check this essential article on how to manage team members and permissions.

We hope this article was useful, and if you have any further questions, feel free to contact us via the Crisp chat!

Updated on: 02/02/2023