Import / Export

Bring data in from CSV and JSON, send results out to anywhere - without leaving the canvas.

Drop a file, get a table

Drag a CSV or JSON file onto the canvas and Peek imports it into your active connection as a table, then drops a query node right where you released it - pre-filled with SELECT * FROM your_file and ready to run.

From there it behaves like any other table: join it against your real data, filter it, feed it into a chart. Column and table names are normalized automatically, so a file like Sales Q1.csv becomes a clean sales_q table you can query straight away.

Send results anywhere

Every Result node is a jumping-off point. Right-click a cell to copy its value, or copy and export whole rows - single rows, or a multi-row selection - as JSON, CSV, or SQL inserts. Right-click a column header to export that column in the same formats, or turn it straight into a variable.

Need to export entire result sets at once? The command palette's Export selected datawrites every selected Result node to a folder as CSV or JSON - and, since you're already running a local model, it names each file descriptively from the query that produced it.