DEV Community

Cover image for Create admin panels for Postgres in 3 short steps
Felipe Freitag Vargas for Seasoned

Posted on

Create admin panels for Postgres in 3 short steps

With Flashboard, you can create admin panels for your Postgres Databases in an instant.

  • Modern look
  • Great UX
  • No need to build the UI
  • Light and dark mode (it follows your OS settings πŸ˜‰)

Let's go from scratch:

1. Create an account

  • Enter your email and choose a strong password.

The password will encrypt your DB connection strings, so make sure you'll remember it!
Sign in to Flashboard

  • Complete your (very short) profile

Complete profile

2. Connect a database

  • Choose "connect my real database"

If you want to look around first, go with "play with a demo".
Connect database

  • Find your connection string and paste it.

If needed, check out this helpful guide to connection URLs.
Paste your connection URL

  • Optional: select 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.

You need to confirm the same password you used to sign in. It will encrypt the connection URL. Only you have access to your DB data.

Create panel

You're connected and ready to build!
Empty panel

3. Build your first tab

Let's create our tab. All your relations are already available, pick one from the selector.
For this example, let's go with "coupons".
Create tab

Almost there. Let's choose some fields!
Empty tab

You can choose what fields to list, reorder the columns with drag-and-drop, pick a default column to order records by.
Edit tab

Filled edit tab

Looking good! We already have a read-only list of coupons, complete with search, filters and pagination.
Coupon list

Let's add some CRUD operations to it. Click on "Build" to see the options.

Build menu

  • Table settings: what appears on the list. We already configured it when creating the tab, but you can change it when needed.

  • Detail settings: enable it if you want users to see the details of a row. Details can show data from columns and relations.

  • New item settings: enable it if users should be able to create new records. You can choose what fields to show on the form.

  • Edit item settings: enable it if users should be able to edit records. You can choose what fields to show on the form.

  • Allow deleting: toggle it if users should be able to delete records.

You don't need to configure everything at once. Each feature is disabled by default to prevent mistakes like "wooops, I forgot to disable XYZ".

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

That's all you need to have an up-and-running Postgres admin panel.

Please let me know what you think!

Sentry blog image

How I fixed 20 seconds of lag for every user in just 20 minutes.

Our AI agent was running 10-20 seconds slower than it should, impacting both our own developers and our early adopters. See how I used Sentry Profiling to fix it in record time.

Read more

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

πŸ‘‹ Kindness is contagious

Explore a sea of insights with this enlightening post, highly esteemed within the nurturing DEV Community. Coders of all stripes are invited to participate and contribute to our shared knowledge.

Expressing gratitude with a simple "thank you" can make a big impact. Leave your thanks in the comments!

On DEV, exchanging ideas smooths our way and strengthens our community bonds. Found this useful? A quick note of thanks to the author can mean a lot.

Okay