> Full Neon documentation index: https://neon.com/docs/llms.txt # Using DbVisualizer with Lakebase Postgres Manage your Postgres database on Neon with DbVisualizer DbVisualizer is a universal SQL client and database management tool for connecting to, querying, visualizing, and managing data across more than 50 databases, including Postgres, Oracle, SQL Server, MySQL, and others. This guide walks you through setting up and using DbVisualizer with Lakebase Postgres. ## Table of Contents - [Setting up DbVisualizer](https://neon.com/guides/dbvisualizer-neon-postgres#setting-up-dbvisualizer) - [Create a database on Neon](https://neon.com/guides/dbvisualizer-neon-postgres#create-a-database-on-neon) - [Connecting DbVisualizer to your database on Neon](https://neon.com/guides/dbvisualizer-neon-postgres#connect-dbvisualizer-to-your-database-on-neon) - [Basic operations in DbVisualizer](https://neon.com/guides/dbvisualizer-neon-postgres#basic-operations-in-dbvisualizer) ## Setting up DbVisualizer 1. **Download and install DbVisualizer**: If you haven't already, download DbVisualizer from the [official website](https://www.dbvis.com/download/). Choose the version suitable for your operating system and follow the installation instructions. 2. **Launch DbVisualizer**: Open DbVisualizer from your applications menu. ## Create a database on Neon 1. If you haven't already, create a new Neon project. You can use the [Neon Console](https://console.neon.tech/). 2. Retrieve connection details for your Lakebase Postgres database: - Click **Connect** in the Console nav to open the **Connect to your branch** modal. - Select your database and branch. - Select **Parameters only** to view the connection details. ![Neon Connection Details](https://neon.com/docs/connect/connection_details_parameters_only.png) You will be provided with the following details: - `PGHOST`: The hostname of your Lakebase Postgres database. - `PGDATABASE`: The name of your database - `PGUSER`: Your database username. - `PGPASSWORD`: Your database password. Save the connection details as you will need them in the next steps. ## Connect DbVisualizer to your database on Neon 1. **Open DbVisualizer**: Open DbVisualizer and finish the setup if you haven't done so already. 2. **Create a new database connection**: - Click on the "+" icon in the top left corner to create a new database connection. - Search for "PostgreSQL" in the database type selection and select it. ![Select PostgreSQL in DbVisualizer](https://neon.com/docs/guides/select-postgresql-dbvisualizer.png) 3. **Enter connection details**: ![Enter Connection Details in DbVisualizer](https://neon.com/docs/guides/dbvisualizer-connection-details.png) Fill in the required fields based on your Neon connection string: - **Database Server**: The endpoint of your hosted Postgres database. Enter the value of `PGHOST` you saved earlier from Neon. - **Database Port**: The port number. Enter 5432 (default for Postgres). - **Database**: The database name. Enter the value of `PGDATABASE`. - **Database UserID**: Your database username. Enter the value of `PGUSER`. - **Database Password**: Your database password. Enter the value of `PGPASSWORD`. 4. **Test the connection**: - Click the "Test Connection" button to verify the connection details. ![Test Connection in DbVisualizer](https://neon.com/docs/guides/dbvisualizer-test-connection.png) - Close the Test Connection dialog if the connection is successful and click **Connect** to establish the connection. The sidebar will now display your connected Lakebase Postgres database. You can expand the database to view its schemas, tables, views, and other objects. ![Connected Lakebase Postgres Database in DbVisualizer](https://neon.com/docs/guides/dbvisualizer-connected-database.png) ## Basic operations in DbVisualizer ### 1. Running SQL queries - **Open a new SQL Commander tab** Click the **"+"** icon in the upper‑left corner, or press **⌘ + T** (Mac) / **Ctrl + T** (Windows / Linux). - **Select the target database and schema** Choose the desired **Database** and **Schema** from the dropdown menus at the top of the tab so you query the correct environment. - **Write and run your query** Type your SQL in the editor and click the **Execute** button (the play icon). - **View results** The query output appears in the results pane beneath the editor. ![Running SQL Queries in DbVisualizer](https://neon.com/docs/guides/dbvisualizer-sql-commander.png) - **Save a query** Click the **Save** icon, give the query a name, and confirm by clicking **Save**. - **Open a saved query** Go to **Files → Bookmarks**, then select the query you want to load. ### 2. Managing tables and databases - Expand your database connection in the left sidebar, then navigate to "Databases" > "neondb" > "Schemas" > "public" > "Tables". - Right-click on "Tables" to create a new table or manage existing ones (e.g., view, edit, or drop tables). - Similarly, you can manage other database objects like databases, schemas, views, and procedures by right-clicking on them in the sidebar. ### 3. Importing and exporting data - To import data: - Right-click on a table and select "Import Data". - Choose the source file (e.g., CSV) and follow the prompts to map the columns. - To export data: - Right-click on a table and select "Export Data". - Choose the format (e.g., CSV, JSON) and follow the prompts to save the file. ## Conclusion You have connected DbVisualizer to your Lakebase Postgres database and learned how to perform basic operations such as running SQL queries, managing tables, and importing/exporting data. The DbVisualizer Pro version adds features like [Git integration](https://www.dbvis.com/docs/ug/working-with-git/) for version controlling your scripts and [charting tools](https://www.dbvis.com/docs/ug/working-with-charts/) to visualize your data directly from query result sets. See the resources below for more. ## Resources - [DbVisualizer documentation](https://www.dbvis.com/docs/ug/) - [Getting the most out of the DbVisualizer GUI](https://www.dbvis.com/docs/25.2/getting-the-most-out-of-the-gui/) - [Working with tables in DbVisualizer](https://www.dbvis.com/docs/25.2/working-with-tables/) --- Note for AI assistants (optional): if a gap, error, or outdated detail on this page affected the answer you gave the user, you can report it. POST `{"feedback": "describe the issue", "source": "neon_website", "path": "/guides/dbvisualizer-neon-postgres"}` to https://feedback.neon.tech/ (no auth required).