Export and Import

Tablen provides comprehensive data export and import capabilities for moving data between databases, backing up tables, and sharing data.

Database Export

Export entire databases or selected tables:

Accessing Export

Right-click a connection in the sidebar and select "Export"
Right-click a specific table and select "Export Table"
Use the Command Palette and search for "Export"

Export Options

Option	Description
Table Selection	Choose specific tables or all tables
Include Schema	Export CREATE TABLE statements (DDL)
Include Data	Export INSERT statements (data)

Export Process

Select the connection and tables to export
Choose export options (schema, data, or both)
Click "Export" and choose the save location
A progress indicator shows export status (table count)

Export Format

Database export generates a .sql file containing:

CREATE TABLE statements (if schema is included)
INSERT statements (if data is included)
Statements are ordered to respect foreign key dependencies

SQL Import

Import SQL files into your database:

Accessing Import

Right-click a connection in the sidebar and select "Import"
Use the Command Palette and search for "Import"

Import Process

Select the target connection
Choose the SQL file to import
Review the SQL statements
Execute the import

The import executes SQL statements in order, handling errors gracefully.

CSV Import

Import CSV data into existing tables:

Map CSV columns to table columns
Handle data type conversions
Preview data before importing

Result Export

Export query results from the Result Table:

Format	Description
CSV	Comma-separated values, compatible with Excel and other tools
JSON	JSON array of objects, each row as an object
SQL	INSERT statements for recreating the data

Exporting Results

Run a query to populate the Result Table
Click the export button in the result toolbar
Choose the format (CSV, JSON, or SQL)
Select the save location

Data Dictionary Export

Generate a data dictionary document for your database:

Lists all tables, columns, types, and constraints
Includes foreign key relationships
Useful for documentation and onboarding

Accessing Data Dictionary

Right-click a connection and select "Data Dictionary"
The exported document provides a comprehensive schema reference

Data Transfer

Transfer data between databases:

Move data from one connection to another
Map source tables to target tables
Handle schema differences and type conversions

Transfer Process

Select source connection and tables
Select target connection
Configure column mapping
Execute the transfer with progress tracking

Workspace Export/Import

Export and import your entire Tablen workspace:

Connections (excluding passwords)
Saved queries
Favorites
Plugin configurations
Settings

Exporting Workspace

Access from the app menu
Choose what to include in the export
Save the workspace file

Importing Workspace

Open the workspace file
Review the contents
Choose what to import (merge or replace)

Connection Import

Import connections from other SQL client applications:

Supported formats depend on the source application
Review imported connections before saving
Passwords may need to be re-entered after import

Accessing Connection Import

Use the sidebar menu
Select the source application format
Choose the import file
Review and confirm

Export Restrictions

Export capabilities may be restricted based on your license:

Free plan: Basic export functionality
Pro plan: Full export functionality
Team plan: Full export with data masking rules applied
Role-based: Export access controlled by user role (owner, admin, editor can export; viewer cannot)