# Browse the Postgres database

**URL:** https://meta.discourse.org/t/browse-the-postgres-database/215062
**Category:** Feature
**Created:** [January 17, 2022, 8:49am UTC](https://meta.discourse.org/t/browse-the-postgres-database/215062 "2022-01-17T08:49:07Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![cokestroke](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cokestroke/32/242007_2.png) [@cokestroke](https://meta.discourse.org/u/cokestroke)
#### Post date: [January 17, 2022, 8:49am UTC](https://meta.discourse.org/t/browse-the-postgres-database/215062/1 "2022-01-17T08:49:08Z")

</div>

Hi everyone,  
Is there a way to browse the database with something like PHPMyAdmin?  
I can download backups but my MySQL Workbench crashes every time I try to run the script to restore the database.  
-Clement

---

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [January 17, 2022, 8:58am UTC](https://meta.discourse.org/t/browse-the-postgres-database/215062/2 "2022-01-17T08:58:37Z")

</div>

I’ve used pgAdmin for this purpose.

But first consider [the Data Explorer Plugin](https://meta.discourse.org/t/data-explorer-plugin/32566).

---

<div class="post-metadata">

### Author: ![cokestroke](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cokestroke/32/242007_2.png) [@cokestroke](https://meta.discourse.org/u/cokestroke)
#### Post date: [January 17, 2022, 9:05am UTC](https://meta.discourse.org/t/browse-the-postgres-database/215062/3 "2022-01-17T09:05:10Z")

</div>

Thanks @merefield will take a look.

---

<div class="post-metadata">

### Author: ![cokestroke](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cokestroke/32/242007_2.png) [@cokestroke](https://meta.discourse.org/u/cokestroke)
#### Post date: [January 17, 2022, 7:05pm UTC](https://meta.discourse.org/t/browse-the-postgres-database/215062/5 "2022-01-17T19:05:08Z")

</div>

The [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin is fine but I’m more of a visual person and it would take me a while to figure out what SQL to write. Can PGAdmin connect to the database the same way as [Data Explorer](https://meta.discourse.org/t/32566?silent=true) or will I need to set up a local copy on my machine to query things?

What I’m trying to do is generate a report or report of users along with the custom user fields I added.

---

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [January 17, 2022, 8:20pm UTC](https://meta.discourse.org/t/browse-the-postgres-database/215062/6 "2022-01-17T20:20:30Z")

</div>

I use pgAdmin client locally to browse a remote non-docker dev instance via an ssh tunnel.

There might be some additional hoops if you want to connect to a prod instance inside the docker container.

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [January 20, 2022, 3:52pm UTC](https://meta.discourse.org/t/browse-the-postgres-database/215062/7 "2022-01-20T15:52:06Z")

</div>

> [@cokestroke](#):
>
> The [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin is fine but I’m more of a visual person and it would take me a while to figure out what SQL to write.

That makes sense.

> [@cokestroke](#):
>
> What I’m trying to do is generate a report or report of users along with the custom user fields I added.

I think it’ll be easier to write or get help with the SQL than it will be to get pgadmin set up, and I think that even if you do get pgadmin set up, you still won’t have an easy way to get the report you want (unless you’re going to pull a couple tables into excel or something?)
