---
title: "Import/Export from SQL Databases"
description: "Send and receive data from PostgreSQL, SQLite, MySQL, TigerData, or Snowflake for use in external applications."
url: "https://www.pixeltable.com/notebooks/data-export-sql"
updated: "2026-06-16"
---

# Import/Export from SQL Databases

Send and receive data from PostgreSQL, SQLite, MySQL, TigerData, or Snowflake for use in external applications.

- **Type:** Notebook
- **Group:** Data Import/Export

## What it covers

- Export entire tables or filtered queries to any SQL database
- Importing exported data back into Pixeltable
- Select specific columns for export
- Handle existing tables with replace or append options
- Connect to cloud PostgreSQL services (e.g. TigerData)

## What it uses

- **Install:** `pip install pixeltable snowflake-sqlalchemy`
- **Pixeltable calls:** `pxt.create_table()`, `insert()`, `add_computed_column()`

## A look at the code

```python
# Create a table with images
images = pxt.create_table(
    'sql_export_demo/images', {'image': pxt.Image, 'label': pxt.String}
)

# Add computed columns for metadata
images.add_computed_column(width=images.image.width)
images.add_computed_column(height=images.image.height)
images.add_computed_column(mode=images.image.mode)
```

## Open it

- **Open in Colab:** https://colab.research.google.com/github/pixeltable/pixeltable/blob/release/docs/release/howto/cookbooks/data/data-export-sql.ipynb
- **Docs page:** https://docs.pixeltable.com/howto/cookbooks/data/data-export-sql
- **Source on GitHub:** https://github.com/pixeltable/pixeltable/blob/release/docs/release/howto/cookbooks/data/data-export-sql.ipynb