data-peek
Features

CSV Import

Import CSV files into database tables

CSV Import

Import data from CSV files directly into your database tables.

Starting an Import

  1. Open the CSV Import dialog from the sidebar or command palette
  2. Drag and drop a .csv file, or click to browse

Configuration

Column Mapping

data-peek auto-detects CSV headers and attempts to match them to existing table columns. You can:

  • Map CSV columns to different table columns
  • Skip columns you don’t want to import
  • Create a new table from the CSV structure

Import Options

OptionDescription
Target tableExisting table or create new
Batch sizeRows per INSERT batch (100, 500, 1000, 5000)
Null handlingHow to treat empty values
Conflict handlingSkip or update on primary key conflict

Import Progress

A progress bar shows the import status. Large files are imported in batches to avoid timeouts.

Supported Databases

CSV import works with PostgreSQL and MySQL connections.

On this page