logo

WhoDB

Data Management

Importing Data

Importing Data

WhoDB's current import flow lives inside the table view and supports two paths:

  • structured file import for CSV and Excel
  • SQL import from a pasted script or .sql file

Open The Import Flow

Open a table, then use the Import button in the grid's bottom footer area, next to Export All, or press Mod + I.

Supported Modes

Data Import

Upload CSV or Excel files, review the preview, and import rows into the current table.

SQL Import

Paste SQL or upload a .sql file and run it through the import panel.

CSV And Excel Import

SQL Import

SQL import can start from either:

  • a pasted SQL script
  • an uploaded SQL file

Use one source at a time: either paste SQL or upload a file. The current flow requires an explicit confirmation checkbox before execution.

Current Limits

The import panel uses these limits:

  • maximum file size: 50 MB
  • maximum row count: 100,000
  • preview rows shown in the UI: 3

Validation Behavior

WhoDB stops the import and shows a validation message for issues such as:

  • invalid or missing column mapping
  • auto-generated columns that require explicit consent
  • parser or file-format errors

Use the preview result to fix the file or adjust the import mode before retrying.

Related Tools

If you need scriptable or terminal-based CSV and Excel imports, use the CLI:

Bash

whodb-cli import --connection mydb --file data.csv --table users

Useful CLI flags include:

  • --schema
  • --delimiter
  • --sheet
  • --header=false
  • --mapping position
  • --mode append
  • --mode overwrite
  • --mode upsert
  • --create-table
  • --allow-auto-generated

For scriptable SQL imports, use the native database client for your engine, such as psql -f seed.sql or mysql database < seed.sql.

See CLI & MCP for the current command surface.

Related Pages

Viewing Data

Return to the table view after importing.

CLI & MCP

Use terminal import commands and other scripted workflows.

Next

Deleting Records