View Your Schema
Introduction
To view your schema, look for the schema browser button in the navigation bar on the left edge of the app:
![](https://files.readme.io/d8e9a05-Kapture_2023-08-15_at_14.20.10.gif)
Select a database
Use the connection and database chooser dropdown buttons at the top of the panel to select a server to browse:
![](https://files.readme.io/1d0e90f-Kapture_2023-08-15_at_14.14.54.gif)
Refresh your database schema
To refresh your schema, click the refresh icon:
![](https://files.readme.io/4ec752e-Kapture_2023-08-15_at_14.12.08.gif)
Show or hide schemas
If you have multiple schemas (eg PostgreSQL) or datasets (eg BigQuery), you can use the schema filter to select which to display:
![](https://files.readme.io/da2a44d-Kapture_2023-08-15_at_14.09.33.gif)
Search for tables, columns, etc.
Type a search term to filter your schema data and quickly find what you are looking for. You can filter the results by data type.
![](https://files.readme.io/91eec10-Kapture_2023-08-15_at_14.02.38.gif)
Troubleshooting schema refresh
I connected to my database and I'm able to run queries, but when I click the Schema tab in the top left, I can't see my schema (eg tables, columns, etc). My autocomplete won't work either.
Resolution
- Ensure you're not filtering your schema
![](https://files.readme.io/149a174-Kapture_2022-04-04_at_21.54.13.gif)
- Try clicking the
Refresh Schema
button
![](https://files.readme.io/cc46cab-Screenshot_2022-04-05_at_15.33.16.png)
- Try clearing your PopSQL cache by clicking
Help > Troubleshooting > Clear Cache and Restart
- Contact PopSQL support for help
Updated 12 months ago