PostgreSQL

Integrate PostgreSQL with Flashboard

Create an admin panel for your Postgres database in seconds

1. Find your database credentials

Check the documentation of your PostgreSQL hosting service to find your Database Credentials. The credentials can appear in two formats: a Connection URL, also called a Connection string, or a list containing username, password, host, database and port.

If you find a connection string, copy it. That's all you need.

If you find the list of credentials, you'll need to format them as a connection URL. They contain a "user", "password", "host","database" and "port". If "port" isn't mentioned, the default port is 5432, so try that one.

Create your connection URL from the credentials using the following template. Substitute each part between "<>" for your credential values.

postgres://<user>:<password>@<host>:5432/<database>

For example, if your credentials are:

user: bob
password: 123456
host: db.example.com
database: awesomedb

Your connection URL will be:

postgres://bob:[email protected]:5432/awesomedb

Copy it to use in the next step.

2. Create a Flashboard account

Enter your email and choose a strong password. The password will be used to encrypt your database credentials, so make sure you remember it!

login

Complete your profile:

profile

3. Connect a database

Choose Connect my real database

connect

Paste the Connection String you copied from step 1 on the field Connection URL.

connectionUrl

Optional: select a namespace. Most of the times, it will be"public". If there's only one namespace, you'll go directly to the next step.

namespace

Choose a panel name and slug, then confirm the same password you used to sign up. It will be used to encrypt the connection URL. Only you and your team will have access to your data.

panel

You're connected and ready to go!

manage

4. Optional: customize your tabs

We generated a panel for you, and enabled all actions on your tabs by default. But you can always customize the fields or disable specific actions, like creating, updating, or deleting items.

build

Congratulations, you have a live admin panel for your PostgreSQL database! 🎉

From here on, you can use it as-is, create more tabs, or share panels with team members.

Felipe Freitag, Flashboard founder

Need help?

Hey! I'm Felipe, Flashboard's founder. I'll personally help you and make sure you get your admin panel up and running.