Database

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

What you can do

• Connect to multiple databases — add any number of PostgreSQL and MySQL connections and see them all in one tree, each with an engine badge.
• Browse the schema — expand a connection to see its schemas, tables, and columns. Double-click a table to open a preview query.
• Run SQL — a full editor with SQL highlighting and completion, plus a fast results grid you can sort and copy from (cell, row, or load-more).
• Export results — download a query result as CSV or JSON, or write it into your workspace as a file that DuckDB, the Data Profiler, or a notebook can pick up.

Passwords are kept in the secure secrets store, never in plaintext.

Getting started

1. Install the engine support you need: Database PostgreSQL and/or Database MySQL.
2. Open the Database panel from the activity bar and click + to add a connection.
3. Enter your connection details, connect, and start browsing or querying.

Requirements

• Desktop app (Electron) — database connections aren't available in the browser host.
• Node.js 18+ on your PATH — used to run the database drivers.

Settings

Setting	Default	Description
database.defaultRowLimit	1000	Default row cap applied to query results.