Navigation bar
The top navigation bar provides quick access to all major sections of Prostgles UI. Located at the top of the interface, it allows you to switch between database connections, manage users and server settings, and access your account preferences. The navigation adapts to your user role, showing admin-only sections like Users and Server Settings only to authorized users.
Key sections of the app
Connections
A connection represents a unique postgres database instance (unique host, port, user and database name). The connection list page shows all available connections you can access based on your user permissions.
Connection dashboard
Clicking a connection from the connection list will take you to the dashboard page where you can explore and interact with the database. Available views and tools include SQL Editor, Table, Map, Schema Diagram, AI Assistant, and more.
Dashboard workspaces
The views you open in the dashboard are saved automatically to the current workspace. This allows you to return to the same views later, even after closing the application. You can create multiple workspaces to organize your views by project, team, task, or any other criteria.
Navbar items
- Connections: Manage database connections
- Users: Manage user accounts (admin only)
- Server Settings: Configure server settings (admin only)
- Account: Manage your account
- Logout: Logout of your account
- Theme Selector: Switch between light and dark themes
- Language Selector: Change the interface language
- Toggle Menu (visible on small screens): Toggle the mobile navigation menu on smaller screens