Database

Connect to your PostgreSQL and MySQL databases, browse their schema, and run SQL right in the editor, then export the results so your data can flow into the rest of your workflow.

What you can do

• Add any number of PostgreSQL and MySQL connections and see them all in one tree, each labelled with its engine.
• Browse a connection's schemas, tables and columns, and double-click a table to open a preview query.
• Write SQL in an editor with highlighting and completion, and run it with Cmd/Ctrl+Enter.
• Cap how many rows a query returns with the row limit on the toolbar, 1000 by default.
• Sort the results grid, and copy a cell or a row.
• Pick up earlier work from the query history, or save a query to reuse it.
• Download a result as CSV or JSON, or write the full query result into your workspace as a file that DuckDB, the Data Profiler or a notebook can pick up.

Getting started

1. Install the engine support you need, Database PostgreSQL or Database MySQL.
2. Open the Database panel from the activity bar and click + (Add connection).
3. Enter your connection details, connect, and start browsing or querying.

The command palette also has Database: New Query, Database: Run Query and Database: Refresh Schema.

Requirements

• At least one engine extension, Database PostgreSQL or Database MySQL.
• The Secrets extension, which holds connection passwords.
• The desktop app. Database connections are not available in the browser.
• Node.js 18 or later on your PATH, which runs the database drivers.

Good to know

• A connection's password is handed to Secrets, and it lands in whichever store you use there. The connection list itself keeps only the details that are not secret.
• A running query cannot be cancelled yet. The Cancel button only tells you so.